Access Module 1

A Primary Key is a code that uniquely identifies a _____________ in a Database.

• Record

• Field

• Text

• Number

A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

• Query

• Report

• Database

• Spreadsheet

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

• Cell

• Field

• Column

• Record

Which view allows you to configure the field properties of a Table? change the field size, add a caption

• 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

The best data type to choose for date of birth would be

• Number

• Text

• Date/Time

• Currency

A field for street address is being used, which data type should you apply?

• Date/time

• Yes/no

• Short Text

• OLE object

To create a field for account number select the data type?

• Short Text

• Number

• Currency

• yes/no

What is an example of a database that you use at school? It holds data like your demographics, your grades, your attendance and your schedule?

• Excel

• Access

• Infinite Campus

• Google