Access 365 Intermediate
Access 365 Intermediate
PRIVATE
Save nan % - NEW YEAR SALE
OR
Or
Take All courses for £49
1 Year Access 
Advanced
27 Students -
4 hours, 32 minutes
Get access to 5000+ courses including this for
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.
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 | ||
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.
