Microsoft Access 2016® Fundamentals

Who Should Attend:

• IT Professionals who provide tech support
• Business Users with database requirements

Course Objectives

• An overview of the features available in Microsoft Access 2010®
• Learn how to use an Access 2010® database
• Learn how to create databases and simple tables
• Learn how to build data-entry forms
• Learn how to display data and produce reports.

What will you gain?

By the end of this course you will be able to:

• Gain proficiency in the basic features of Microsoft Access and use it effectively to organise information
• Manage your data by creating simple databases and relational databases
• Construct simple and complex tables
• Create queries to filter and sort data, and join data from different tables
• Design and format the look and appearance of forms
• Get the know-how to create and present reports based on the data entered
• Acquaint yourself with the various printing options available in Access and use them to print different objects.

Course Content

• Work in Access 2010
• Understand database concepts
• Explore tables
• Explore forms
• Explore queries
• Explore reports
• Preview and print Access objects
• Create databases from templates
• Create databases and tables manually
• Manipulate table columns and rows
• Refine table structure
• Create relationships between tables
• Create forms by using the Form tool
• Change the look of forms
• Change the arrangement of forms
• Sort information in tables
• Filter information in tables
• Filter information by using forms
• Locate information that matches multiple criteria.