Name: 

Access is a __________.

If a width is not assigned to a text field, Access assumes the width is __________.

To enter value $1,505.50 in a Currency type field, type: 

__________ means storing the same fact in more than one place.  For efficiency, this should be avoided.

To find all customers whose city is either Lake Barrington, North Barrington, South Barrington, Barrington Hills, Port Barrington, or Barrington, enter ______ as the criteria.

To find all BHS students who have a 6 as the 2nd digit of their Student ID number, enter ____ as the criteria.

To find all customers whose amount paid is $1,500.00 or more enter __________ in the Criteria row of the Amount Paid column in the accompanying figure.

To find all customers whose amount paid is $0.00 enter __________ in the Criteria row of the Amount Paid column in the accompanying figure.

Less than (<), greater than (>), and NOT (not equal to) are examples of __________.

Connecting tables on a common field  is referred to as

To add an additional table to a query, which button is used?

To add add a row that allows grouping in a query, which button is used?

Which of the following would create a prompt if entered as the criteria of a query?

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click _________.

Organize the following items in order from smallest to largest

Assume Query 1 would display the data shown below.   (note, there are 312 rows in the data, but only the beginning is shown in the image.)

Query 1:
  

Resulting data from Query 1


Resulting Data from Query 2:


Query 1 was modified to create Query 2.  Which of the following is Query 2?

A database must include

(CA2) To add text to a report, use the __________ tool in the toolbox.

(CA2) To add a field to a report, use the __________ tool in the toolbox.

Which field would be the best choice for the primary key of the Shippers table?

To create a field that will add the Amount Paid to the Current Due, save the query, then select ______ to complete Step 1.  Next, create the formula in Step 2.
Step1:


Step 2:

Every table must have one field designated as the  primary key.

To change the field size for a text field, use the Field Size property box in the lower pane of the Table window.

When adding records to a table, it is necessary to click the Save button on the toolbar after adding each new record.

A query is a question represented in a way that Access can understand.

Microsoft Access does not allow you to save queries.

The asterisk (*) wildcard represents any individual character.

The question mark (?) wildcard represents any individual character.

All fields included in a query’s design grid must show in its datasheet view.

To sort records by city within state, specify State as the major sort key and City as the minor sort key.  To do this, State must be to the left of City in the design grid.

When two tables are joined in a query, Access draws a line between matching fields of the two tables.

In Access, to specify referential integrity, define a relationship between the tables by using the Relationships window.

In the Alisa Vending Services database, a many-to-many relationship exists between the Driver table and the Customer table.

In the Alisa Vending Services database, the Driver ID is the foreign key in the Customer table, and the primary key in the Driver table.

Using Access, it is possible to create a report from more than one table or query.

Match the buttons to their functions

Match the query design the the resulting data.

Match the views.