Microsoft Access 2016 Beginner to Advanced
Microsoft Access 2016 Beginner to Advanced
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - HOLIDAY SALE
OR
Or
Take All courses for £49
1 Year Access 
Advanced
10 Students -
1 day, 18 hours
Get access to 5000+ courses including this for
Overview
Empower your career journey with our in-demand course: Microsoft Access 2016 Beginner to Advanced
Boost your proficiency and propel your career forward with our meticulously crafted course, designed to be your ultimate guide to professional development. Our super-accessible modules break down complex topics into bite-sized, easy-to-understand lessons, filling your knowledge gaps and equipping you with real-world, practical skills.
Seeking career advancement and application of your skills? You’ve found the right place. This Microsoft Access 2016 Beginner to Advanced is your exclusive passport to unlocking your full potential.
Enroll today and enjoy:
- 100% online flexibility: Learn at your own pace, from anywhere in the world.
- Expert support: We're by your side throughout your journey, providing guidance and assistance.
- Comprehensive curriculum: Dive deep into relevant topics aligned with industry standards.
- Practical focus: Apply your learnings to real-world scenarios and situations.
This sought-after course is your key to a successful and lucrative career. Don’t miss out on this transformative opportunity. Enroll now and take your professional life to the next level!
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Exam & Retakes
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
Course Curriculum
| Module - 1 | |||
| Orientation to Microsoft Access | 01:00:00 | ||
| Create a Simple Access Database | 01:00:00 | ||
| Get Help in Microsoft Access | 00:30:00 | ||
| Modify Table Data | 00:30:00 | ||
| Work with Records | 01:00:00 | ||
| Sort and Filter Records | 00:30:00 | ||
| Create Lookups | 01:00:00 | ||
| Join Data from Different Tables in a Query | 01:00:00 | ||
| Sort and Filter Data in a Query | 01:00:00 | ||
| Perform Calculations in a Query | 00:30:00 | ||
| Create Parameter Queries | 00:30:00 | ||
| Create Action Queries | 00:30:00 | ||
| Create Find Duplicate and Find Unmatched Queries | 00:30:00 | ||
| Summarize Data | 00:30:00 | ||
| Create a Report | 01:00:00 | ||
| Add Controls to a Report | 00:30:00 | ||
| Enhance the Appearance of a Report | 00:30:00 | ||
| Prepare a Report for Print | 00:30:00 | ||
| The Access Options Dialog Box | 01:00:00 | ||
| Relational Database Design | 00:30:00 | ||
| Create a Table | 01:00:00 | ||
| Modify a Table and Fields | 00:30:00 | ||
| Create Table Relationships | 00:30:00 | ||
| Create Query Joins | 00:30:00 | ||
| Join Tables That Have No Common Fields | 00:30:00 | ||
| Relate Data within a Table | 00:30:00 | ||
| Work with Subdatasheets | 00:30:00 | ||
| Create Subqueries | 00:30:00 | ||
| Data Normalization | 01:00:00 | ||
| Create a Junction Table | 00:30:00 | ||
| Import Data into Access | 00:30:00 | ||
| Export Data to Text File Formats | 00:30:00 | ||
| Export Access Data to Excel | 00:30:00 | ||
| Create a Mail Merge | 00:30:00 | ||
| Organize Report Information | 00:30:00 | ||
| Format Reports | 00:30:00 | ||
| Include Charts in a Report | 00:30:00 | ||
| Add a Calculated Field to a Report | 00:30:00 | ||
| Add a Subreport to an Existing Report | 00:30:00 | ||
| Create a Mailing Label Report | 00:30:00 | ||
| Publish a Report as PDF | 00:30:00 | ||
| Activities – Microsoft Access 2016 for Beginners | 00:00:00 | ||
| Module - 2 | |||
| Add Controls to Forms | 01:00:00 | ||
| Set Form Controls | 01:00:00 | ||
| Create Subforms | 00:30:00 | ||
| Organize Information with Tab Pages | 00:30:00 | ||
| Enhance Navigation with Forms | 00:30:00 | ||
| Format a Form | 01:00:00 | ||
| Apply Conditional Formatting | 00:30:00 | ||
| Field Validation | 00:30:00 | ||
| Form and Record Validation | 00:30:00 | ||
| Create a Macro | 01:00:00 | ||
| Restrict Records Using a Condition | 00:30:00 | ||
| Validate Data Using a Macro | 00:30:00 | ||
| Automate Data Entry Using a Macro | 00:30:00 | ||
| Convert a Macro to VBA | 00:30:00 | ||
| Link Tables to External Data Sources | 00:30:00 | ||
| Manage a Database | 00:30:00 | ||
| Determine Object Dependency | 00:30:00 | ||
| Document a Database | 00:30:00 | ||
| Analyze the Performance of a Database | 00:30:00 | ||
| Split a Database for Multiple User Access | 00:30:00 | ||
| Implement Security | 00:30:00 | ||
| Set Passwords | 00:30:00 | ||
| Convert an Access Database to an ACCDE File | 00:30:00 | ||
| Package a Database with a Digital Signature | 00:30:00 | ||
| Create a Database Switchboard | 01:00:00 | ||
| Modify a Database Switchboard | 00:30:00 | ||
| Set Startup Options | 00:30:00 | ||
| Activities – Microsoft Access 2016 Advanced | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Access 2016 Beginner to Advanced | 00:30:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Access 2016 Beginner to Advanced | 00:30:00 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
