-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Access 365 Intermediate
Access 365 Intermediate
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Advanced
27 Students -
4 hours, 32 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
Overview
Discover how to enhance and develop your existing skills with Microsoft’s primary information handling tool with this Access 365 Intermediate course. Access 365 continues to be one of the most reliable and effective ways to integrate data and link to other tools in the Office 365 suite. This informative training will ensure that your skills are updated and take full advantage of all the primary functions and utilities that Access can offer you and your workplace.
This Microsoft Access 365 tutorial has been carefully crafted to offer valuable hints and tips for those that want to enhance and improve their use of it. It offers useful ways to manipulate data tables, information records, and specific fields to a much greater extent and level of intracity. This will allow you to be more creative with reports and statistics, providing valuable input and foundations for important business decisions. Get ready to take the next step to be an Access expert by enrolling now.
What you'll learn
- Learn how to design information tables for improved data entries
- Discover how to share data with other apps such as Excel and SharePoint
- Know how to work with action queries and create appropriate versions
- Gain new techniques for writing advanced queries and combining data
- Explore ways of automating processes with macros
- Understand how to create advanced forms and professional reports
Certification
After completing this course's assessment, you will be eligible for:
- A CPD QS accredited Certificate from One Education.
The CPD QS Accredited Certificate Is Available In PDF Format, At The Cost Of £9, Or A Hard Copy Can Be Sent To You Via Post, At The Cost Of £15.
Order Your Certificate here
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
Why study this course
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Access 365 Intermediate is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
Course Curriculum
| Module 1: Design Tables for Better Data Entry | |||
| Reviewing Table Design Principles | 00:11:00 | ||
| Setting Field Size, Formats, and Captions | 00:11:00 | ||
| Setting Default Values and Required Fields | 00:05:00 | ||
| Restricting Data Entry-Validation Rules | 00:07:00 | ||
| Restricting Data Entry-Input Masks | 00:09:00 | ||
| Module 2: Share Data with Other Apps | |||
| Exporting Tables and Queries to Excel | 00:05:00 | ||
| Exporting Data to a SharePoint List | 00:02:00 | ||
| Importing Data from Excel | 00:06:00 | ||
| Importing Data from a SharePoint List | 00:02:00 | ||
| Linking External Data Sources | 00:05:00 | ||
| Using Word Merge | 00:06:00 | ||
| Module 3: Work with Action Queries | |||
| What are Action Queries | 00:04:00 | ||
| Creating an Update Query | 00:06:00 | ||
| Creating an Append Query | 00:04:00 | ||
| Creating a Delete Query | 00:04:00 | ||
| Creating a Make Table Query | 00:04:00 | ||
| Changing Start Number of an Auto Number Field | 00:04:00 | ||
| Module 4: Advanced Query Techniques | |||
| Modifying Query Joins | 00:06:00 | ||
| Using Self Joins to Combine Data | 00:06:00 | ||
| Creating Find Unmatched and Find Duplicate Queries | 00:09:00 | ||
| Creating Parameter Queries | 00:05:00 | ||
| Creating a Top X Query | 00:02:00 | ||
| Reviewing Calculated Query Fields | 00:06:00 | ||
| Summarizing Query Data with Totals | 00:04:00 | ||
| Creating Crosstab Queries | 00:06:00 | ||
| Module 5: Automate Processes with Macros | |||
| Understanding Macro Basics | 00:14:00 | ||
| Creating Macros to Open Forms by Record | 00:09:00 | ||
| Validating Data Entry with Macros | 00:10:00 | ||
| Creating a Macro to Automate Data Entry | 00:08:00 | ||
| Advanced Data Entry Using Macros and DLOOKUP | 00:11:00 | ||
| Module 6: Advanced Form Techniques | |||
| Using Conditional Formatting | 00:04:00 | ||
| Working with the New Label Name Property | 00:03:00 | ||
| Organizing Form Fields with Tab Controls | 00:09:00 | ||
| Creating an Option Group Control | 00:06:00 | ||
| Creating a Combo Box Control | 00:04:00 | ||
| Configuring a Combo Box Control to Show Search Results | 00:04:00 | ||
| Using a Subform to Show Data From a Related Table | 00:06:00 | ||
| Module 7: Advanced Report Techniques | |||
| Inserting a Chart on a Report | 00:07:00 | ||
| Showing Data in Columns | 00:07:00 | ||
| Inserting a Subreport | 00:05:00 | ||
| Configuring Reports with Parameter Queries | 00:03:00 | ||
| Sending Reports | 00:03:00 | ||
| Resource | |||
| Resource – Access 365 Intermediate | 00:00:00 | ||
| Final Exam | |||
| Final Exam – Access 365 Intermediate | 00:20:00 | ||
Related Courses
Intermediate
Intermediate
COPYRIGHT © 2022 One Education
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