Microsoft Access 2013 / 2010: Level 2
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- Understanding relational databases
- Understanding Different Join types to combine table information
- Advanced queries
- Implementing many-to-many relationships
- Import/export data
- Advanced reporting
Prerequisites
- Microsoft Access 2013 / 2010: Level 1 or equivalent experience
Outline
- Lesson 1: Designing a Relational Database
- Topic A: Relational Database Design
- Topic B: Create a Table
- Topic C: Create Table Relationships
- Lesson 2: Joining Tables
- Topic A: Create Query Joins
- Topic B: Join Tables That Have No Common Fields
- Topic C: Relate Data within a Table
- Topic D: Work with Subdatasheets
- Lesson 3: Creating Advanced Queries
- Topic A: Create Parameter Queries
- Topic B: Create Action Queries
- Topic C: Create Unmatched and Duplicate Queries
- Topic D: Summarize Data
- Lesson 4: Organizing a Database for Efficiency
- Topic A: Data Normalization
- Topic B: Create a Junction Table
- Topic C: Improve Table Structure
- Lesson 5: Sharing Data Across Applications
- Topic A: Import Data into Access
- Topic B: Export Data to Text File Formats
- Topic C: Export Access Data to Excel
- Topic D: Create a Mail Merge
- Lesson 6: Advanced Reporting
- Topic A: Organize Report Information
- Topic B: Format Reports
- Topic C: Include Control Formatting in a Report
- Topic D: Add a Calculated Field to a Report
- Topic E: Add a Subreport to an Existing Report