Microsoft Access 2016 Beginner to Advanced

Course details

Get this comprehensive course to get a complete collection with all the contents necessary to give you an overview of Microsoft Access 2016!

The Microsoft Access 2016 Beginner to Advanced is designed to teach you all the essentials of working with the Microsoft Access tutorial. By learning from here you will be able to create a database of your own right from scratch, understanding table structures and their relationships, creating queries with various criteria’s, building forms with form controls, creating reports with labels, implanting macros in buttons and all other important applications to make your database more effective and efficient.


Who is this Course for?

Microsoft Access 2016 Beginner to Advanced is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background.

Entry Requirement:

• This course is available to all learners, of all academic backgrounds.
• Learners should be aged 16 or over to undertake the qualification.
• A good understanding of the English language, numeracy and ICT are required to attend this course.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.
 

• Module - 1
• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access
• Modify Table Data
• Work with Records
• Sort and Filter Records
• Create Lookups
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• The Access Options Dialog Box
• Relational Database Design
• Create a Table
• Modify a Table and Fields
• Create Table Relationships
• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries
• Data Normalization
• Create a Junction Table
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge
• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report
• Create a Mailing Label Report
• Publish a Report as PDF
• Activities – Microsoft Access 2016 for Beginners
• Module – 2
• Mock Exam
• Final Exam

Updated on 10 May, 2021