Access - Part 1
In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports.
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
Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships
Topic A: Create Basic Queries Topic B: Perform Calculations in a Query Topic C: Sort and Filter Data in a Query
Topic A: Start a New Form Topic B: Enhance a Form
Topic A: Start a New Report Topic B: Enhance Report Layout
Topic A: Restrict Data Input Through Field Validation Topic B: Restrict Data Input Through Forms and Record Validation
Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity
Enroll in this course
Select a start date for your 2 Day course
This course begins at 9:00 Eastern
And ends at 17:00 Eastern
Questions About This Course?
Need Help Finding The Right Training Solution?
Our training advisors are here for you.