Overview
This comprehensive course on Microsoft Access Complete Course (Beginner, Intermediate, Advanced) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Access Complete Course (Beginner, Intermediate, Advanced) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder.
How will I get my certificate?
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
Who is This course for?
There is no experience or previous qualifications required for enrolment on this Microsoft Access Complete Course (Beginner, Intermediate, Advanced). It is available to all students, of all academic backgrounds.
Requirements
Our Microsoft Access Complete Course (Beginner, Intermediate, Advanced) is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.
There is no time limit for completing this course, it can be studied in your own time at your own pace.
Career Path
Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to—
- Open doors of opportunities
- Increase your adaptability
- Keep you relevant
- Boost confidence
And much more!
Course Curriculum
- 25 sections
- 121 lectures
- 6 hours, 44 minutes total length
-
Introduction 00:01:00
-
What is a Database? 00:03:00
-
Understanding Database terminology 00:05:00
-
Navigating the Access Interface 00:06:00
-
What is a flat file database 00:04:00
-
What is a relational database 00:09:00
-
Relating Tables 00:06:00
-
Reviewing the Access Ribbon 00:04:00
-
Working with Tables 00:04:00
-
Navigating Tables 00:02:00
-
Editing Data 00:03:00
-
Adding New Records 00:02:00
-
Using Subdatasheets 00:04:00
-
Understanding Database and Table Design Principles 00:10:00
-
Using Table Data Sheet View 00:04:00
-
Working with Field Data Types 00:04:00
-
Using Table Design View 00:04:00
-
Using Calculated Fields 00:04:00
-
Calculating Numbers 00:03:00
-
Calculating Dates 00:01:00
-
Calculating Strings 00:02:00
-
Using the Lookup Wizard 00:05:00
-
Editing Lookups 00:04:00
-
Using Indexes 00:02:00
-
What are Queries 00:03:00
-
Creating Simple Queries 00:05:00
-
Understanding the Dynaset 00:02:00
-
Entering Criteria: Exact Match and Range Operators 00:04:00
-
Understanding AND versus OR 00:03:00
-
Using Wild Cards 00:02:00
-
Using Keywords 00:03:00
-
Sorting and Hiding Fields 00:02:00
-
Creating Multi-Table Queries 00:03:00
-
Additional Tips 00:03:00
-
What are Reports 00:03:00
-
Understanding Report Types 00:03:00
-
Building Effective Reports 00:02:00
-
Using AutoReport 00:04:00
-
Understanding the Report Wizard 00:04:00
-
Using the Report Design View 00:08:00
-
Creating Labels 00:02:00
-
What are Forms 00:04:00
-
Understanding Form Types 00:02:00
-
Creating Forms 00:02:00
-
Navigating Forms 00:02:00
-
Editing Data in Forms 00:03:00
-
Understanding the Form Wizard 00:03:00
-
Using the Form Design View 00:04:00
-
Working with Controls 00:03:00
-
Using Form Layout View 00:02:00
-
Additional Tips 00:03:00
-
Course Recap 00:01:00
-
Reviewing Table Design Principles 00:04:00
-
Setting Field Size, Formats and Captions 00:06:00
-
Setting Default Value and Required Fields 00:03:00
-
Restricting Data Entry Using Data Validation 00:02:00
-
Restricting Data Entry Using Input Masks 00:06:00
-
Exporting Tables and Queries to Excel 00:03:00
-
Importing Data from a TXT File 00:03:00
-
Importing Data from Excel 00:02:00
-
Exporting Data to a TXT File 00:02:00
-
Linking External Data Sources 00:03:00
-
Using Word Merge 00:02:00
-
What are Action Queries 00:02:00
-
Creating an Update Query 00:02:00
-
Creating an Append Query 00:03:00
-
Creating a Delete Query 00:02:00
-
Creating a Make Table Query 00:02:00
-
Changing the Start Number of an Auto Number Field 00:03:00
-
Creating Query Joins 00:05:00
-
Creating Find Unmatached and Find Duplicate Queries 00:03:00
-
Creating Parameter Queries 00:04:00
-
Using -Like- Keyword in Parameter Queries 00:02:00
-
Creating a Top X Query 00:01:00
-
Reviewing Calculated Query Fields 00:03:00
-
Summarizing Query Data with Totals 00:02:00
-
Inserting Where Statements in Summary Queries 00:01:00
-
Creating a Crosstab Query 00:03:00
-
Understanding Macro Basics 00:06:00
-
Creating Macros to Open Forms by Record 00:04:00
-
Validating Data Entry with Macros 00:04:00
-
Creating a Macro to Automate Data Entry 00:04:00
-
Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00
-
Using Conditional Formatting 00:02:00
-
Organizing Form Fields with Tab Controls 00:03:00
-
Creating a Combo Box Control 00:02:00
-
Creating an Option Group Control 00:03:00
-
Using a Subform to Show Data from a Related Table 00:03:00
-
Inserting a Chart on a Report 00:03:00
-
Showing Data in Columns 00:02:00
-
Inserting a Subreport 00:02:00
-
Configuring Reports with Parameter Queries 00:04:00
-
Sending Reports 00:02:00
-
Using the Table Analyzer Wizard 00:05:00
-
Append Querying to Normalize a Table 00:08:00
-
Creating a Junction Table 00:06:00
-
Backing Up a Database 00:02:00
-
Using the Compact and Repair Database Tool 00:03:00
-
Using the Object Dependencies Tool 00:02:00
-
Using the Database Documenter Too 00:02:00
-
Using the Performance Analyzer Tool 00:01:00
-
Understanding the Access Switchboard 00:03:00
-
Using The Switchboard Manager 00:09:00
-
Modifying a Switchboard 00:05:00
-
Setting the Startup Options 00:04:00
-
Using the database Splitter 00:04:00
-
Configuring Trusted Locations 00:02:00
-
Password Protecting a Database 00:03:00
-
Password Protecting Modules 00:01:00
-
Converting a Database to an ACCDE file 00:01:00
-
Understanding VBA Basics 00:06:00
-
Exploring Variables and Control Flow Statements 00:10:00
-
Exporting a Table or Query with VBA 00:06:00
-
Converting a Macro to VBA 00:02:00
-
Understanding Table Events 00:02:00
-
Using the Before Change Event Command 00:04:00
-
Using the After Change Event Command 00:04:00
-
Course Recap 00:01:00
Frequently Bought Together
4.8 course rating - 15 reviews
Private
This course includes:
-
Duration:6 hours, 44 minutes
-
Access:1 year access
-
Units:121
-
Level:
-
CPD Points:10
-
Certificate:Yes
