Access Specialist Certification Program
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Earn a certification in Microsoft Access. This program includes two Access classes, two hours of private training, and the Access Certification exam.
Curriculum
What you'll learn
- Create a simple database and customize Access configuration options.
- Organize and manage data stored within Access tables and use queries to join, sort, and filter data from different tables.
- Design a relational database.
- Join tables to retrieve data from related tables and validate the data entered into a database.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Customize reports to organize the displayed information and produce specific print layouts.
Course outline
-
Microsoft Access Level I 6 hours
Learn the basics of relational database management in Microsoft Access Level I. This introductory course covers creating new databases, building tables, designing forms, generating reports, and more. By the end of the course, you'll be able to join, filter, and sort data in Microsoft Access.
- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
- Organize and manage data stored within Access tables
- Use queries to join, sort, and filter data from different tables
- Use forms to make it easier to view, access, and input data
- Create and format custom reports
-
Microsoft Access Level II 6 hours
Take your Microsoft Access skills to the next level with advanced lessons on data validation, table structure improvement, and advanced reporting techniques. Learn how to create relational databases, code advanced queries, and increase your database management efficiency.
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Customize reports to organize the displayed information and produce specific print layouts.
What's included
- Microsoft Office
- Free course retake within one year to refresh the material and gain practice.
- Access Certification exam with retake
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Wed, Thu
10:00–17:00 · America/New_York (EDT)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 60 days. You can choose when to start your access period. Once you activate, you will have 60 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $859
- Course length
- 14 hours
- Schedule
- On your schedule
Become a certified expert in Microsoft Access through this comprehensive self-paced program, which includes two Access courses and the Access Certification exam.
You’ll build and manage relational databases, create tables, queries, forms, and reports, and apply data validation and table structure improvements. The program then prepares you for, and includes, the Microsoft Access certification exam.
Self-paced curriculum
What you'll learn self-paced
- Build and manage relational databases in Microsoft Access
- Create tables, queries, forms, and reports
- Apply data validation and improve table structure
- Work through two full Access courses at your own pace
- Prepare for the Microsoft Access certification exam
- Sit the certification exam
Self-paced course outline
-
Microsoft Access Level I (Self-Paced) 6 hours
Get started with relational database management in Microsoft Access Level I. This introductory course teaches you how to create databases, build tables, design forms, generate reports, and more. By the end of the course, you’ll be able to join, filter, and sort data in Microsoft Access.
- Navigate the Microsoft Access environment and create a simple database
- Organize and manage data within Access tables
- Use queries to join, sort, and filter data from multiple tables
- Use forms to simplify data entry, viewing, and access
- Create and format custom reports to meet your needs
-
Microsoft Access Level II (Self-Paced) 6 hours
Take your Microsoft Access skills to the next level with advanced lessons on data validation, table structure optimization, and complex reporting techniques. Learn to design relational databases, write advanced queries, and improve database management efficiency.
- Design a relational database and join tables to retrieve data from multiple sources
- Validate data entered into the database to ensure accuracy
- Use advanced queries to manipulate and analyze data
- Organize your database for better performance and data integrity
- Customize reports to format data and create specific print layouts
What's included with self-paced
- Microsoft Office
- Access Certification exam with retake