Database

To Enter Data in a Database showing only ONE record at a time, what must you create ?

• A Record

• A Report

• A Form

• A Query

Microsoft's version of a Database Management System

• Excel

• Access

• Word

• PowerPoint

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

• Record

• Field

• Number

• Text

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

• Cells

• Fields

• Tables

• Records

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

• Forms

• Tables

• Reports

• Queries

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

• Ascending

• Descending

• Auto Sort

• Advanced Sort/Filter

Which data type would be most suitable for the 'Age' field?

• Currency

• Date & Time

• Number

• Long Text

The command for "not equal to" is...

• <>

• <=

• >=

• ><

Which is the best example of a primary key?

• Driver's License Number

• Date of Birth

• Price

• First and Last Name

What must be common between two tables to create a relationship?

• Records

• Fields

• Tables

• Files