ACCESS BASICS:
Create, edit, and save a simple one-table
database.
|
CREATE & EDIT TABLES:
Use
Design View to create and edit
tables. Add, format, move, and
delete fields.
Adjust width of columns, change
font/font size of text. Add Default
Values, Lookup fields, and Input
Masks to speed up data entry. Add
Validation Rules to protect the
integrity of your data. Import Excel
data into a table.
 |
| |
CREATE & EDIT FORMS:
Create forms based on existing tables. Enter
and edit data and forms. Change
background color of form,
move and resize fields.
|
 |
| |
DATA ENTRY:
Enter, edit, and delete data in
forms and tables.
SORT AND FILTER DATA:
Use
Find & Replace to edit data in
table, use Quick Sort to sort
data alphabetically (A-to-Z or
Z-to-A), use Filter by
Selection to locate specific
data in tables.
|
| |
CREATE QUERIES:
Create a number of different
queries.
Sort
and filter data using different
criteria such as name, amount, and
date. Use multiple criteria to
narrow a search, use wildcards,
filter data
by a range of dates or amounts, etc. |
| |
 |
| |
REPORTS:
Use
Report Wizard to create professional
looking reports based on existing tables and
queries. Edit reports in Design
View.
|
 |
