Access Fundamentals AES

In the image, where would you click to look for a name in the database?

• A

• B

• C

Data can be entered into the Datasheet view, but it can be easier to use a ______ instead.

• Primary Key

• Field

• Record

• Form

In the image, what is the highlighted area of the screen called?

• Database Form

• Database Table

• Navigation Pane

• Ribbon

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 foreign key

• A primary key

• A relationship key

Which ribbon tab do you use to make a new table?

• File

• Home

• Create

• External Data

Which of the following is an easy way to enter and browse data in a large database?

• Spreadsheets

• Tables

• Records

• Forms

A store tracks suppliers and inventory in a database. Which of the following would be a field in the supplier table?

• Phone Number

• Amount in Stock

• Inventory Cost

• Data Integrity

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

• Information about all the customers

• Information about one order

• Information about one customer

• Information about every order

Does Microsoft Access need to be told about relationships between tables?

• No, relationships are automatically detected.

• No, relationships are not supported.

• Yes, relationships need to be defined.

• Yes, only when the fields have different names.

What is it called when you "ask the database a question"?

• Data Integrity

• Query

• Report

• Relationship