Beginning Access Class - $199
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.
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.
Use Report Wizard to create professional looking reports based on tables and queries. Edit reports in Design View.