AIN100B: Microsoft Access Training Part 2
Book List
Course Links
Tuition:
$165.00 per student
Length: 1 day
1 day introductory course covering database design, subdatasheets, data validation, advanced queries, and advanced reporting techniques. Using our courseware students may update several small database applications, including any created in AIN100A. This course is the same as AIN100 Introduction to Microsoft Access day 2.
Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.
Flexible to suit your requirements. Both onsite and online classes are custom scheduled.
2-4 students 20%, 5-8 30%, >8 quote
Session 1
Tables and Queries
3.0 Hours
- Designing a Relational Database
- Relational Database Design
- Create a Table
- Joining Tables
- Joining Tables
- Create Query Joins
- Relate Data Within a Table
- Work with Subdatasheets
- Using Data Validation
- Use Field Validation
- Use Form and Record Validation
Session 2
Advanced Queries and Reporting
3.0 Hours
- Creating Advanced Queries
- Create Parameter Queries
- Summarize Data
- Create Subqueries
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Organize a Database for Efficiency
- Data Normalization
- Create a Junction Table
- Improve Table Structure
- Using Advanced Reporting Techniques
- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report