Microsoft Access Advanced Level
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Duration
1 Year
-
Start date
Different dates available
-
Support service
Yes
-
Virtual classes
Yes
Learn how to safely and securing import, export and manage your data with this comprehensive online qualification. Microsoft Office 2016 Access Advanced course is the final stage of our Access training, covering expertise in database management needed for more senior digital analysis and office administration roles. You learn through video tutorials which explain each function in an accessible, user-friendly manner, augmented by PDF handouts, mock exams, and online multiple-choice assessments.
The Microsoft Office 2016 Access Advanced – Complete Video Course builds on our beginners and intermediate qualifications to walk you through the more advanced functionality of Microsoft Access. This includes applying conditional formatting to your database, validating data entry and automating functions using macros, splitting a database for multiple user access, and efficiently managing a database switchboard.
Facilities
Location
Start date
Start date
About this course
The Microsoft Access Advanced Level is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Upon successful completion you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £19 and Hardcopy Certificate for £34.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 5 years
Subjects
- Access
- Office IT
- Database
- Database training
- Ms Office
- Export
- Import
- Microsoft Access
- Microsoft Office
- Controls
Course programme
Module 01
- Add Controls to Forms
- Enhance Navigation and Organization of Forms
- Apply Conditional Formatting
Module 02
- Import Data into Access
- Export Access Data
- Link Tables to External Data Sources
- Create a Mail Merge
Module 03
- Create a Macro
- Restrict Records by Using a Condition
- Validate Data by Using a Macro
- Automate Data Entry by Using a Macro
Module 04
- Manage a Database
- Determine Object Dependency
Module 05
- Manage a Database
- Determine Object Dependency
- Document a Database
Module 06
- Splitting a Database for Multiple User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Module 07
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Start up Options
Mock Exam
- Mock Exam- Microsoft Access Advanced Level
Final Exam
- Final Exam- Microsoft Access Advanced Level
How is the course assessed?
- To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Microsoft Access Advanced Level