Course description
Access 2016 Advanced - Part 1
About this course:
This is the first in a series of advanced Access 2016 courses, aimed at increasing your proficiency in managing databases within Microsoft’s popular business program. Learn to create and design a database, explore tables and forms, query data, create advanced reports, and use Macros to develop automation.
Access is a database creation and management program. It helps you design and build a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Who should attend?
Audience:
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
Prerequisite:
To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships.
Training content
Course Objective:
In this course, you will learn to create and manage a fundamental Access 2016 database.
You will:
- Customize a form layout to improve usability and efficiency of data entry.
- Share data across applications.
- Use macros to improve user interface design.
- Use VBA to enhance tasks.
- Organize data into appropriate tables to ensure data dependency and minimize redundancy.
- Lock down and prepare a database for distribution to multiple users.
- Create and modify a database switchboard and set the startup options.
Why choose QuickStart?
98% increased workplace productivity
94% instructor and course effectiveness
Partnered with vendors including Microsoft, Cisco, and Citrix
Contact this provider
Meet your career goals with QuickStart!
QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple...