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.





