Microsoft Access - Beginners - Advanced

Course details

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.

COURSE CURRICULUM

Microsoft Access for Beginners

• 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
• Activities – Microsoft Access for Beginners

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
• Activities – Microsoft Access Intermediate Level

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
• Activities – Microsoft Access Advanced Level

Why choose us?

• Affordable, engaging & high-quality e-learning study materials;
• Tutorial videos/materials from the industry leading experts;
• Study in a user-friendly, advanced online learning platform;
• Efficient exam systems for the assessment and instant result;
• The UK & internationally recognised accredited qualification;
• Access to course content on mobile, tablet or desktop from anywhere anytime;
• The benefit of applying for NUS Extra Discount Card;
• 24/7 student support via email.

Updated on 29 March, 2018