Learn to design a simple database, enter, and correct information, filter, and sort data; create tables, use forms, perform queries by using practical examples and generate reports.
Class Outline
Lesson 1: Working with an Access Database
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Microsoft Access
Lesson 2: Creating Tables
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
Lesson 3: Creating Queries
- Topic A: Create Basic Queries
- Topic B: Add Calculated Columns in a Query
- Topic C: Sort and Filter Data in a Query
Lesson 4: Creating Forms
- Topic A: Start a New Form
- Topic B: Enhance a Form
Lesson 5: Creating Reports
- Topic A: Create a report
- Topic B: Enhance Report Layout