Importing
True or False: In K201 we always import data into a new table or append to an existing table.
True
When creating a relationship between two tables, what two boxes must be checked to be counted correctly in K201?
Enforce Referential Integrity and Cascade Update Related Fields
What is the correct data type and field size for a ZipCode?
Data Type: Short Text (leading 0's, don't forget our friends on the East Coast)
Field Size: 10 (don't forget the hyphen)
Name the type of query needed: "What percentage of revenue comes from each store location?"
Query on Query
If Access asks you to "Enter Parameter Value" when you run a query, what error is occurring?
A misspelled field name
Remember: Parameter queries are not on the exam
What are the three kinds of file types we import into an Access Database?
1. Excel Files
2. Access Database Files
3. Text Files
True or False: It is acceptable to Cascade Delete in K201.
FALSE
What Data Type displays as a Check box?
Yes/No Data Type- it can also display as True/False or -1 and 0
Name the type of query needed: "Create a query that lists all the item codes and descriptions of products that Premiere Foods has but have not sold."
Query Wizard: Unmatched Query
Premiere Foods carries the item (tblProduct), but the item has not sold (tblTransactionDetails)
What are the three arguments in an Immediate IF (IIF) function?
IIF(logical test, value if true, value if false)
True or False: We can import Functions from Excel
False: In K201, we import Named Ranges or Worksheets into Access.
True or False: Relationships can only be created between two fields with the same name.
FALSE
The data must be the same. For example, EmployeeID and SoldOrPackagedBy contain the same data, but have different field names.
What is the difference between creating a format for the data and creating an input mask for the data?
Format: How the data will be displayed
Example: Capitalizing all the letters in a last name even if the user enters their name in lowercase.
Input Mask: How data will be entered
Example: Phone Number template (___) ___-____
What operator do you use in a query when both criteria must be true?
AND
Ex: *Apple* AND *OG*
When using a function like DATE() in a Form, what must come before the function?
An equals sign (=)
When importing, what box do you have to check so that Access knows the data has headers?
First Row Contains Field Names
When creating a lookup between two tables, what must you do before creating the lookup?
Delete the relationship between the two tables if it already exists.
True or False: Making a field Required is a two-step process.
True
1. Change the Required Property to Yes
2. Change Allow Zero Length Property to No
What operator do you use in criteria when you only want to return customers who have an email address?
Is Not Null
In a form, if we want some values to show in red font and others in blue font, what do we use to do this?
Conditional Formatting
True or False: When importing a text file, you do not have to specify the delimiter (tab, comma, space, semicolon, etc.).
False
What do you need to remember to do after creating a lookup between two tables?
Editing the relationship to include Cascade Update
Remember: The lookup wizard gives us the option to Enforce Referential Integrity, but we have to go back and edit the relationship to enable Cascade Update.
What would you do to automatically display yesterday's date in a field?
Enter Date()-1 in the Default Value property
When the Totals Row is being used, what does the WHERE option do?
It stops grouping by the particular field you have selected and it hides the field.
Remember: Just hiding the field by unselecting the Show check box does not stop group by. You may still have duplicates.
What symbol helps us connect fields like First Name and Last Name into one field?
The ampersand or &
The plus sign also works.