What are records and fields?

What Are Relationships?

What is a Relational Database?

What is referential integrity?

Freeze Columns

Sorting Records

Filtering Records

Designing a Database

Working With Wizards

Different Views

Query - A question asked of the data contained in tables or other queries. (e.g., What students passed the final?).

Form - A screen used to format the output of a query or table for display or to allow for data entry.

Report - Formatted output of data for printing, receives data from tables and queries.

Field - A column of data in a table, consisting of a single category of data like names, address, company, phone number, account number.  A field consists of many records.

Record - A row of data in a table, consisting of data about one person or thing.  A record contains many fields. 

Primary Key - The field on which a table can be related to another table to join the two together. (e.g. Your account number at your bank ties you to a table of transactions, loans, personal data. Etc).

Cross-tab Report - Rotation of data to allow a more organized view of the information. Creates a spreadsheet like view of data.