Beginning Access Class

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.