Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced

Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable.

The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.

Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and IAO. This makes it 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.

CPD

COURSE CURRICULUM

Microsoft Access - Beginner

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help and Configure Options in Microsoft Access
• Modify Table Data
• Sort and Filter Records
• Create Basic Queries
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Create Basic Access Forms
• Work with Data on Access Forms
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Organize Report Information
• Format Reports

Microsoft Access - Intermediate

• Relational Database Design
• Create a Table
• Create Table Relationships
• Create Query Joins
• Relate Data Within a Table.avi
• Work with Subdatasheets from
• Use Field Validation
• Use Form and Record Validation
• Create Parameter Queries
• Summarize Data
• Create Subqueries
• Create Action Queries
• Create Unmatched and Duplicate Queries
• Data Normalization
• Create a Junction Table
• Improve Table Structure
• Include Control Formatting in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report

Microsoft Access - Advanced

• Add Controls to Forms
• Enhance Navigation and Organization of Forms
• Apply Conditional Formatting
• Import Data into Access
• Export Access Data
• Link Tables to External Data Sources
• Create a Mail Merge
• Create a Macro
• Restrict Records by Using a Condition
• Validate Data by Using a Macro
• Automate Data Entry by Using a Macro
• Manage a Database
• Determine Object Dependency
• Manage a Database
• Determine Object Dependency
• Document a Database
• Splitting a Database for Multiple User Access
• Implement Security
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Start up Options

Assessment and Certification:

Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of GBP24 for a PDF copy and GBP39 for an original print copy sent to you by post.

We are a company who is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level.

As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.