Access Fundamentals

In the table which customer does not have a Company associated with their information?

• Nancy Marshall

• Carl Wilco

• Susan Lindross

• Sheila Hagar

What is the advantage of reports over queries?

• Reports can access more data

• Queries can be formatted

• Reports can be formatted

Look at the information in the database table. What field is being used to FILTER the table?

• Name

• Phone

• Address

• City

• State

If you wanted to delete Shelia Hagar's record from the table, what would you do first?

• Right-click in Shelia Hagar's Customer ID

• “Select Shelia Hagar's record and then right-click in the record

• Right-click anywhere in the record

In the table, where would you click to enter a new record?

• A

• B

• C

• D

You have a table that holds names and phone numbers for 1000 people. How many records are there?

• 2

• 1000

• 2000

• None

A database contains a Customer table. What would be stored in a record of the Customer table?

• nformation about one order

• Information about every order

• Information about all the customers

• Information about one customer

The image represents a database. What does Item A indicate in the database?

• A database

• A table

• A record

• A field

The image represents a database. What does Item A indicate in the database?

• A database

• A table

• A record

• A field

A primary key field from one table appears in a second table. What is the field in the second table called?

• A linked key

• A primary key

• A foreign key

• A relationship key