Microsoft Access 2016 – Level 1 / Intro
Course Description
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. 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.
Highlights
In this course, you will learn how to 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.
Target 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.
Course Outline
Getting Started with Access
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access
Working with Table Data
- Modify Table Data
- Sort and Filter Records
Querying a Database
- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a Query
Using Forms
- Create Basic Access Forms
- Work with Data on Access Forms
Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
Prerequisites
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
ALL ACCESS PASS FROM
$3,995
per license
Sign Up for All Access Pass and gain 12-month access up to 300+ Live instructor-led courses.
BUY NOWUpcoming Courses
Contact us to book a training.
We can plan a specific customized training session tailored to you or your organization's requirements,
or we can sign up several students for a future class.
We’re Ready Lets Talk
Do You Have More Questions? We're delighted to assist you!