Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. This Microsoft Office 2016 Access Beginner is designed for them who wish to establish a foundational understanding of Microsoft Office Access 2016. In this course, you will use Access 2016 to manage your data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Learning Outcomes:
- 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
- And much more
Method of Assessment:
Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).
Certification:
Upon completing this course, you can enhance your professional credentials and showcase your achievement by ordering a CPD-accredited certificate. Choose the option that best suits your needs:
- PDF Certificate: £9.99
- PDF Certificate + PDF Transcript: £11.99
- Hardcopy Certificate + Hardcopy Transcript: £23.99
- Complete Package – Certificate & Transcript (Hard Copy + PDF): £29.99
Requirements
There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
Course Curriculum
Module 01 | |||
Orientation to Microsoft Access | FREE | 00:39:00 | |
Create a Simple Access Database | 00:10:00 | ||
Get Help and Configure Options in Microsoft Access | 00:06:00 | ||
Module 02 | |||
Modify Table Data | 00:17:00 | ||
Sort and Filter Records | 00:05:00 | ||
Module 03 | |||
Create Basic Queries | 00:15:00 | ||
Sort and Filter Data in a Query | 00:14:00 | ||
Perform Calculations in a Query | 00:08:00 | ||
Module 04 | |||
Create Basic Access Forms | 00:07:00 | ||
Work with Data on Access Forms | 00:23:00 | ||
Module 05 | |||
Create a Report | 00:23:00 | ||
Add Controls to a Report | 00:12:00 | ||
Enhance the Appearance of a Report | 00:05:00 | ||
Prepare a Report for Print | 00:03:00 | ||
Organize Report Information | 00:15:00 | ||
Format Reports | 00:12:00 | ||
Mock Exam | |||
Mock Exam – Microsoft Office 2016 Access Beginner | 00:20:00 | ||
Final Exam | |||
Final Exam – Microsoft Office 2016 Access Beginner | 00:20:00 |
Course Reviews
No Reviews found for this course.