Importing
True or False: In K201 we always import 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 field size and data type for a ZipCode?
Field Size: 10 (don't forget the hyphen)
Data Type: Short Text (leading 0's, don't forget our friends on the East Coast)
Name the type of query needed: "What percentage of revenue comes form 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 of the item codes and descriptions of products that Premiere Foods carries, but that they 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 things must be true?
AND
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 a query when you only want to return customers who have an email address?
Is Not Null
How do you calculate revenue or sales?
Quantity x Price or Volume x SellingPrice and so on
*remember, the fields names could be different
True or False: When importing a text file, you do not have to specify the delimiter (tab, comma, space, semicolon, etc.).
False
What step do we tend to forget 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.
After entering a Validation Rule, what is the next step in K201?
Enter the Validation Text or the error message for users.
When the Totals Row is selected, 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 separate fields like First Name and Last Name into one?
The ampersand or &