Suggested Study Topic: Access

BASICS
- Creating a database
- Creating a table
- Inserting data
- Viewing database, table, data from different views
TABLES AND RECORDS
- Modifying table field properties
- Inserting, modifying, deleting, and finding records
- Sorting records
- Filtering records by selection
- Previewing and printing table data
TABLE RELATIONSHIPS
- Assign primary key
- Assign primary key with multiple fields
- Creating and modifying relationships
QUERY (Query by Example)
- Creating, saving, and running a query
- Creating a query with multiple tables
- Creating and formatting a calculated field
- Using functions in query expressions
FORMS AND REPORTS
- Creating a form using a wizard
- Modify form controls
- Setting form properties
- Creating a report using a wizard
- Adding sorting and grouping levels
- Adding a calculated control to a report
- Adding a control to calculate total

Resources