Mastering Access 2016 – Intermediate
Everything you need to know about Microsoft Access–delivered in easily searchable, highly informative video lessons
MicrosoftAccess lets ordinary users develop powerful apps customized for their business needs.
In this course experienced Microsoft Access trainer, Kathy Jones, will walk you through building your first Microsoft Access database, including creating tables, using queries, and implementing forms and reports
- Relational Database Design
- Creating a Table
- Creating Table Relationships
- Creating Query Joins
- Relating Data within a Table
- Working with Subdata Sheets
- Using Field Validation, Part 1
- Using Field Validation, Part 2
- Using Forms and Record Validation
- Creating Parameter Queries
- Summarizing Data
- Creating Subqueries
- Creating Action Queries
- Creating Unmatched and Duplicate Queries
- Data Normalization
- Creating a Junction Table
- Creating a Table Structure
- Including Control Formatting in a Report
- Adding Calculated Fields to a Report
- Adding a Sub-report to an Existing Report
