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.