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.