Microsoft Access Intro

What Query view is shown in this image?

• Datasheet View
• Design View

Where do you configure the field properties of a Table?

• Design View

• Datasheet View

• Access View

What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?

• Query

• Form

• Report

Access can import a table of data from Excel.

• True

• False

A unique identifier used in creating a table that assures there will be no duplicate data.

• Primary Key

• Query

• Data Type

Microsoft's version of a Database Management System (DBMS)

• Excel

• Access

• Word

What is a complete row of data within a table?

• Table

• Field

• Record

To sort from the smallest to the largest (from A to Z and 0 to 9)

• Ascending

• Descending

• Advanced Sort/Filter

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell

• Field

• Column

• Record

Forms, queries, and reports are created based on the information in the _________

• Form
• Table
• Report