Access 365 Advanced
Access 365 Advanced
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Intermediate
2 Students -
2 hours, 1 minute
Overview
Discover how to reach the next level of data management when you elevate your knowledge of Microsoft’s primary information handling tool with this Access 365 Advanced course. The most current version of Microsoft Access is an integral part of the company’s Office suite and allows for improved links and shared functions between each app. Using this training, you will learn how to gain the full benefits from this reliable and adaptable platform, empowering you to produce more advanced reports and calculations for business and personal use.
This Microsoft Access 365 tutorial is the most progressive and complete way to ensure that you are fully aware of all of the functions and techniques that are available to you for data management and associated tasks. You will impress others as to the professional methods and outcomes you can utilise in your work, making you the “go-to” person for using this tool and the functionality it holds. Everything you need to know about database maintenance, database configuration, and automating processes is presented here for you, all available in easy-to-follow online modules. Be the best with Access 365 by enrolling now.
- Learn how to significantly improve the structure of a database
- Discover how to perform effective and reliable database maintenance
- Know how to work with navigation forms and create start-up options
- Gain the ability to provide multiple points of access for authorised users
- Explore ways to automate processes with VBA (Visual Basic for Applications)
- Understand how to use table events to drive future activities
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 Advanced 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: Improving the Structure of a Database | |||
| Using the Table Analyzer Wizard | 00:09:00 | ||
| Append Querying to Normalize a Table | 00:10:00 | ||
| Creating a Junction Table | 00:06:00 | ||
| Module 2: Maintaining a Database | |||
| Backup Up a Database | 00:03:00 | ||
| Using the Compact and Repair Database Tool | 00:03:00 | ||
| Using the Object Dependencies Tool | 00:03:00 | ||
| Using the Database Documenter Tool | 00:02:00 | ||
| Using the Analyze Performance Tool | 00:02:00 | ||
| Module 3: Working with Navigation Forms and Startup Options | |||
| Creating a Navigation Form | 00:03:00 | ||
| Modifying a Navigation Form | 00:05:00 | ||
| Setting the Startup Options | 00:03:00 | ||
| Module 4: Configuring Access for Multiple Users | |||
| Using the Database Splitter | 00:04:00 | ||
| Configuring Trusted Locations | 00:03:00 | ||
| Password Protecting a Database | 00:04:00 | ||
| Password Protecting Modules | 00:02:00 | ||
| Converting a Database to an ACCDE File | 00:02:00 | ||
| Module 5: Automating Processes with VBA | |||
| Understanding VBA Basics | 00:03:00 | ||
| Exploring Variables and Control Flow Statements | 00:10:00 | ||
| Exporting a Table or Query with VBA | 00:09:00 | ||
| Converting a Macro to VBA | 00:02:00 | ||
| Module 6: Using Table Events | |||
| Understanding Table Events | 00:02:00 | ||
| Using the Before Change Event Command | 00:07:00 | ||
| Using the After Update Event Command | 00:04:00 | ||
| Resource | |||
| Resource – Access 365 Advanced | 00:00:00 | ||
| Final Exam | |||
| Final Exam – Access 365 Advanced | 00:20:00 | ||
Related Courses
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