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