About Lesson
After completing this course, participants will have learned to:
Topic 1
Getting Started with Access
- Microsoft Access 2016
- Database Templates
- Using Tell Me
Topic 2
Working with Table Data
- AutoCorrect
- Adding New Records
- The Sort Feature
- Lookup Fields
Topic 3
Querying a Database
- Query Views
- Query Criteria
- Arithmetic Operators
Topic 4
Creating Advanced Queries
- Parameter Queries
- Action Queries
- The Find Duplicates Query Wizard
- Crosstab Queries
Topic 5
Generating Reports
- Report Creation Tools
- Report Sections
- Galleries
- Adding a Header or Footer
Topic 6
Customizing the Access Environment
- Access Options
Topic 7
Designing a Relational Database
- Relational Databases
- Table Creation Options
- Renaming a Table
- The Relationships Window
Topic 8
Joining Tables
- Query Joins
- Joining Tables with No Common Fields
- Self-Joins
- Subdatasheets
- Subqueries
Topic 9
Organizing a Database for Efficiency
- First Normal Form
- Many-to-Many Relationships
Topic 10
Sharing Data Across Applications
- Data Importing
- Data Exporting
- Exporting Access Data to Excel
- The Microsoft Word Mail Merge Wizard
Topic 11
Advanced Reporting
- Report Design Elements
- Report Format Tools
- Data Bars
- Calculated Fields
- Sub reports
Topic 12
Additional Reporting Options
- The Label Wizard
- Publishing a Report as PDF