Microsoft Access Beginners, Intermediate & Advanced

Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It can also import or link directly to data stored in other applications and databases. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 for the beginner, intermediate, and advanced-level users. Then you learn the different components of the database so that you understand the structure underlying your data.

Professionals who want to learn about the Microsoft Access 2013

People who have an interest in learning all the features of the Access 2013

CPD

COURSE CURRICULUM

Microsoft Access

• Module One - Getting Started
• Module Two - Opening and Closing Access
• Module Three - An Introduction to Databases
• Module Four - Sharing Data Using Apps
• Module Five - Working in Your App
• Module Six - An Introduction to Desktop Databases
• Module Seven - Performing Basic Table Tasks
• Module Eight - Working with Fields
• Module Nine - Working with Table Relationships
• Module Ten - An Introduction to Queries, Forms, and Reports
• Module Eleven - Protecting Your Data
• Module Twelve - Wrapping Up

Microsoft Access for intermediate level

• Module One - Getting Started
• Module Two - Creating a Custom App
• Module Three - Customizing App Actions
• Module Four - Customizing Your App Views with Macros
• Module Five - Working with Validation Rules and Messages
• Module Six - Working with Macros
• Module Seven - Advanced Query Tasks
• Module Eight - Designing Forms
• Module Nine - Advanced Reporting Tasks
• Module Ten - Advanced Database Tools
• Module Eleven - Working with the Access Environment
• Module Twelve - Wrapping Up

Microsoft Access Advanced Level

• Module One - Getting Started
• Module Two - Using App Views
• Module Three - Customizing Apps, Part One
• Module Four - Customizing Apps, Part Two
• Module Five - Working with More Record Tasks
• Module Six - Using Advanced Field Tasks
• Module Seven - Working in Table Design View
• Module Eight - Working with the Expression Builder
• Module Nine - Working with External Data
• Module Ten - Creating Queries
• Module Eleven - Creating Forms and Reports

• Module Twelve - Wrapping Up

• Assessment:

• At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.

• Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

In addition to the course price there is an additional charge for certificate. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at the following price:

• Hard Copy by post - GBP39.00
• Soft Copy PDF via email - GBP24.00

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.