ACCESS 1
ACCESS 2
ACCESS 3
ACCESS 4
ACCESS 5
100

The unique identifier

What is a primary key?

100

A question asked of the database

What is a query?

100

Used to view, add, delete and update records

What is a form?

100

The values in each field of a table for a single entity

What is a record?

100

A collection of fields that describe one entity (person, place, thing, idea)

What is a table?

200

Create a query in design view

What is click on Create and Query Design button?

200

Table is viewed as series of rows and columns

What is Datasheet view?

200

The view used to modify the table

What is the Design view?

200

The character that lets you search     S*

What is a wildcard?

200

View with form on top and datasheet on bottom

What is a split form?

300

Maximum number of characters in Short Text

What is 255 characters?

300

The type of database where data is stored in one or more tables

What is a relational database?

300

Query that selects data from one or more tables

What is a select query?

300

The two ways to create a form

What are the Form button or Form Wizard?

300

Easiest way to import data into Access?

What is External Data>Import> (type) Excel

400

A sales rep has many customers, customers only have one sales rep, type of relationship

What is a one-to-many relationship?

400

Data type that lets you look up data in another field

What is a lookup field?

400

Query that changes values of data in one more more tables

What is an update query?

400

Query that prompts input whenever it is used

What is a parameter query?

400

Query that adds to a group of records

What is an append query?

500

Property of a field that defines the pre-determined values allowed

What is an input mask?

500

The most common query language of most DMBS (including Access)

What is SQL (Structured Query Language)?

500

Rule that ensures only valid data will be entered

What is the validation rule?

500

The view used to input validation rules

What is design view?

500

Key used to match primary key to match another table

What is a foreign key?