Microsoft Access Course Overview

Part 1:
In this course, students will learn how to use Access to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Part 2:
In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.
Instructor Led Learning
Duration: 3 Days
Registration Open Now!
Video Learning
Duration: 3 Days
Registration Open Now!
What you will learn
Part 1 (Basic)
- Lesson 1Getting Started with Access
- Lesson 2Working with Table Data
- Lesson 3 Querying a Database
- Lesson 4Creating Advanced Queries & Using forms
- Lesson 5 Generating Reports
- Lesson 6 Customizing the Access Environment
- Lesson 7 Designing a Relational Database
Part 2 (Intermediate)
- Lesson 1 Designing a Relational Database
- Lesson 2Joining Tables
- Lesson 3 Organizing a Database for Efficiency
- Lesson 4 Joining Tables
- Lesson 5 Organizing a Database for Efficiency
- Lesson 6 Sharing Data Across Applications
Part 3 (Advanced)
- Lesson 1 Implementing Advanced Form Design
- Lesson 2Using Data Validation
- Lesson 3 Using Macros to Improve User Interface Design
- Lesson 4 Using Advanced Database Management
- Lesson 5 Distributing and Securing a Database
- Lesson 6 Managing Switchboards
Basic computer skills
Computers made easy course
Introduction to Microsoft Office course
Microsoft Excel Level 1-3
FULL COURSE OUTLINE
Join Over 10,000 Students that have studied with MasterGrade IT Now
Become Part of MasterGrade IT to Further Your Career.
