ZPDI1298 - Microsoft Access 2016 (Online)

Course Description

Microsoft Access is now much more than a software to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues.  

This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels: Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.

This course includes:

• Visual Demonstrations and Multimedia Presentations
• Quizzes and Exam Simulators
• Social Learning and Networking
• Flash Cards and Educational Games
• Enhanced Navigation and Controls

Course Outline

Access Beginner                   

• 1.1 Introduction Part 1
• 1.2 Introduction Part 2
• 1.3 Elements Part 1
• 1.4 Elements Part 2
• 1.5 Reviewing Data
• 1.6 Queries Part 1
• 1.7 Queries Part 2
• 1.8 Tracking Time Part 1
• 1.9 Tracking Time Part 2
• 1.10 Tracking Time Part 3
• 1.11 Design Work With Forms

Access Intermediate

• 1.1 Relationships Part 1
• 1.2 Relationships Part 2
• 1.3 Changing Information
• 1.4 Loading Tables
• 1.5 Relating Invoices Part 1
• 1.6 Relating Invoices Part 2
• 1.7 Relating Invoices Part 3
• 1.8 Relating Invoices Part 4
• 1.9 Time Entry Form

Access Advanced

• 1.1 Queries Part 1
• 1.2 Queries Part 2
• 1.3 Queries Part 3
• 1.4 Queries Part 4
• 1.5 Reports Based on Queries
• 1.6 Adding Additional Information
• 1.7 Update Query Part 1
• 1.8 Update Query Part 1
• 1.9 Creating Report From Scratch Part 1
• 1.10 Creating Report From Scratch Part 2
• 1.11 Creating Report From Scratch Part 3

Notes

Participants will have 12 months to complete this self-paced online course.

All necessary materials are included.

Certification(s):

This course prepares students to take the Microsoft Office Specialist: Access Associate certification exam.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online-based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla Firefox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite (Microsoft Office, OpenOffice or LibreOffice)
• PDF reader program (Adobe Reader, Foxit)
• Courses may require other software that is denoted in the above course outline.