The unique identifier
What is a primary key?
A question asked of the database
What is a query?
Used to view, add, delete and update records
What is a form?
The values in each field of a table for a single entity
What is a record?
A collection of fields that describe one entity (person, place, thing, idea)
What is a table?
Create a query in design view
What is click on Create and Query Design button?
Table is viewed as series of rows and columns
What is Datasheet view?
The view used to modify the table
What is the Design view?
The character that lets you search S*
What is a wildcard?
View with form on top and datasheet on bottom
What is a split form?
Maximum number of characters in Short Text
What is 255 characters?
The type of database where data is stored in one or more tables
What is a relational database?
Query that selects data from one or more tables
What is a select query?
The two ways to create a form
What are the Form button or Form Wizard?
Easiest way to import data into Access?
What is External Data>Import> (type) Excel
A sales rep has many customers, customers only have one sales rep, type of relationship
What is a one-to-many relationship?
Data type that lets you look up data in another field
What is a lookup field?
Query that changes values of data in one more more tables
What is an update query?
Query that prompts input whenever it is used
What is a parameter query?
Query that adds to a group of records
What is an append query?
Property of a field that defines the pre-determined values allowed
What is an input mask?
The most common query language of most DMBS (including Access)
What is SQL (Structured Query Language)?
Rule that ensures only valid data will be entered
What is the validation rule?
The view used to input validation rules
What is design view?
Key used to match primary key to match another table
What is a foreign key?