Microsoft Access Complete Course (Beginner, Intermediate, Advanced)
Overview Grasp the science of and how it relates to launching a lucrative career. Prepare for future needs by looking …
15 Students
Overview
Grasp the science of Microsoft Access Complete Course (Beginner, Intermediate, Advanced) and how it relates to launching a lucrative career. Prepare for future Microsoft Access Complete Course (Beginner, Intermediate, Advanced) needs by looking beyond the ongoing Microsoft Access Complete Course (Beginner, Intermediate, Advanced) impact with Discover Training’s up-to-date Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course .
Discover Training’s Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course gives you a solid foundation in Microsoft Access Complete Course (Beginner, Intermediate, Advanced) in many settings of human development. With industry expert interviews, you’ll gain a greater understanding of Microsoft Access Complete Course (Beginner, Intermediate, Advanced)‘s applications and limitations, as well as how it’s already been efficiently used in the field. Discover Training’s Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course will help you obtain facts and knowledge to strengthen your abilities on both standard Microsoft Access Complete Course (Beginner, Intermediate, Advanced) techniques.
As you progress through the interactive modules of this online program, you will have a strong grasp of Microsoft Access Complete Course (Beginner, Intermediate, Advanced) to identify new opportunities for innovation and drive digital growth within your organization. Enrol in the Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course today and leverage your knowledge tomorrow.
Description:
Industry professionals developed the content of this online Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course, combining their expertise and in-depth knowledge. The curriculum was developed by Discover Training to assist you in growing in your current role by providing you with the necessary information and concepts. As you progress through the modules of this course, you’ll learn the fundamentals of Microsoft Access Complete Course (Beginner, Intermediate, Advanced) and explore the essential concepts.
Who is this course for?
This Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course is for you if you want to learn about the revolutionary potential of Microsoft Access Complete Course (Beginner, Intermediate, Advanced). Whether you are a newbie or a seasoned veteran, a grasp of challenges that Microsoft Access Complete Course (Beginner, Intermediate, Advanced) techniques can tackle would benefit anyone working in the Microsoft Access Complete Course (Beginner, Intermediate, Advanced) sector. This Microsoft Access Complete Course (Beginner, Intermediate, Advanced) training covers crucial subjects that will help you overcome challenges and improve your practices.
Requirements:
- Prerequisites: None
- Age Limit: 16+
- Gadgets: Smart devices and internet
Certification
Once the Microsoft Access Complete Course (Beginner, Intermediate, Advanced) course is successfully completed, the learner can obtain the PDF certificate without any cost. The hardcopy version of the certificate is also available for only £9.99. However, anyone ordering the hardcopy certificate from outside the United Kingdom may need to pay an additional delivery charge.
Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course Reviews
An outstanding online course with clear explanations and practical examples. I could study at my own pace and still feel fully supported throughout. It’s truly boosted my confidence and career prospects
The course was well-structured, engaging, and easy to follow. The flexibility made it perfect alongside my full-time job. I’ve gained valuable, real-world skills that I can apply immediately.
Excellent learning experience from start to finish. The content was professional, up-to-date, and highly relevant. I would highly recommend it to anyone looking to upskill online.
Course Curriculum
| Introduction | |||
| Introduction | 00:01:00 | ||
| Getting Started | |||
| 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 Data | |||
| 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 | ||
| Creating Databases and Objects | |||
| 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 | ||
| Working with Queries | |||
| 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 | ||
| Working with Reports | |||
| 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 | ||
| Working with Forms | |||
| 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 | ||
| Conclusion | |||
| Course Recap | 00:00:00 | ||
| MS Access Intermediate | |||
| Introduction | |||
| Introduction | 00:01:00 | ||
| Designing Tables for Better Data Entry | |||
| 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:07:00 | ||
| Sharing Data with Other Applications | |||
| 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 | ||
| Working with Action Queries | |||
| 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 | ||
| Advanced Query Techniques | |||
| 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 | ||
| Automating Processes with Macros | |||
| 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 | ||
| Advanced Form | |||
| 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 | ||
| Advanced Report Techniques | |||
| 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 | ||
| Conclusion | |||
| Course Recap | 00:01:00 | ||
| MS Access Advanced | |||
| Introduction | |||
| Introduction | 00:01:00 | ||
| Improving the Structure of a Database | |||
| Using the Table Analyzer Wizard | 00:05:00 | ||
| Append Querying to Normalize a Table | 00:08:00 | ||
| Creating a Junction Table | 00:06:00 | ||
| Maintaining a Database | |||
| 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 | ||
| Working with Access Switchboards | |||
| 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 | ||
| Configuring Access for Multiple Users | |||
| 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 | ||
| Automating Processes with VBA | |||
| 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 | ||
| Using Table Events | |||
| Understanding Table Events | 00:02:00 | ||
| Using the Before Change Event Command | 00:04:00 | ||
| Using the After Change Event Command | 00:04:00 | ||
| Conclusion | |||
| Course Recap | 00:01:00 | ||
Frequently Asked Questions
Yes, Discover Training provides accredited and CPD-certified courses, ensuring learners receive recognised qualifications that support career progression and professional compliance.
Anyone can enrol, including students, professionals, job seekers, career changers, and organisations. Most courses do not require previous experience, making them accessible to learners at all levels.
Discover Training offers courses across multiple sectors, including business, health and safety, compliance, leadership, IT, personal development, and professional skills training.
You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.
Yes, learners receive a downloadable digital certificate upon successful completion, suitable for CPD records, CVs, and professional portfolios.
-
Number of Units:
121 -
Access:
1 Year -
Duration:
6 hours, 44 minutes -
PDF Certificate
Included
- Item added to cart