Microsoft Access Complete Course (Beginner, Intermediate, Advanced)
Microsoft Access Complete Course (Beginner, Intermediate, Advanced)
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Advanced
46 Students -
6 hours, 45 minutes
Overview
Microsoft Access is the number 1 database management system in the world, which is also super easy to learn. No matter how novice or amateur you are, this course will make you an expert of Microsoft Access within hours. So simply enrol, get certified, and upgrade your skillset today.
This Microsoft Access Complete Course (Beginner, Intermediate, Advanced) is the best way for you to gain expertise in database management. You will learn from industry experts and obtain an accredited certificate after completing the course.
Like all the courses of One Education, this Microsoft Access Complete Course (Beginner, Intermediate, Advanced) has been designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.
We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support.
Our expert instructors are always available to answer all your questions and make your learning experience exquisite.
After completing the Microsoft Access Complete Course (Beginner, Intermediate, Advanced), you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.
If you want to learn about this topic and achieve certifications, you should consider this Microsoft Access Complete Course (Beginner, Intermediate, Advanced) from One Education.
There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course.
Description
Here at One Education, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. We aim always to provide value to our learners with quality courses.
Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Microsoft Access Complete Course (Beginner, Intermediate, Advanced).
The certification that you will receive upon completing this Microsoft Access Complete Course (Beginner, Intermediate, Advanced) will help to boost your resume and will help you stand out among your peers in the competitive job market.
Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from One Education. Enrol now!
Why People Love And Enrol In The Microsoft Access Complete Course (Beginner, Intermediate, Advanced) From One Education
- Instantly accessible CPD-accredited certificate on successful completion of this Microsoft Access Complete Course (Beginner, Intermediate, Advanced)
- 24/7 access to the course for 12 months
- Study at your own pace
- No hidden fees
- Full Tutor support on weekdays (Monday – Friday)
Will I receive a certificate of completion?
Who is This course for?
This Microsoft Access Complete Course (Beginner, Intermediate, Advanced) is ideal for
- People looking to start learning Microsoft Access with any level of expertise
- People aspiring to start learning database management
- Students
- Anyone looking to learn a new skill or acquire some knowledge
Requirements
There are no specific prerequisites to enrol in this Microsoft Access Complete Course (Beginner, Intermediate, Advanced). Anyone and everyone can take this course.
The Microsoft Access Complete Course (Beginner, Intermediate, Advanced) is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home!
All you need is a passion for learning, literacy, and to be over the age of 16.
Career Path
This Microsoft Access Complete Course will help you procure a job in the relevant field and will allow you to advance your career. Many relevant job roles will be available for you to explore after completing this course. This Microsoft Access Complete Course also increases your competency to be eligible for promotions at work.
Course Curriculum
| MS Access Beginner | |||
| 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:01: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 | ||
| Course Certification | |||
| Order Your Certificate | 00:00:00 | ||
Important Links
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.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add