Microsoft Access 2016 Beginner to Advanced

Microsoft Access is a database management system application; it stores data in its own form on the Access Jet database engine. This application is used by mainly software developers to develop application software. Microsoft Access 2016 Beginner to Advanced course is a complete collection with all the contents necessary to give you an overview of this application.

In this course, you will learn about its interface, create and edit databases, sorting and filtering data in a query, performing calculations, summarization of data, data normalization, advanced reporting, etc. By the end of this course, users should be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

Microsoft Access 2016 Beginner to 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

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

Module - 2

• Add Controls to Forms
• Set Form Controls
• Create Subforms
• Organize Information with Tab Pages
• Enhance Navigation with Forms
• Format a Form
• Apply Conditional Formatting
• Field Validation
• Form and Record Validation
• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Convert a Macro to VBA
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
• Split a Database for Multiple User Access
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup 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.