Access 365 Beginner
- Bestseller
- Great Service
- Highly Rated
- Trending
Access 365 Beginner
PRIVATE
Save 0.00 % - OFFER ENDS SOON
OR
Or
Take All courses for £49
1 Year Access 
Advanced
0 Students -
4 hours, 53 minutes
Get access to 5000+ courses including this for only £49. Learn More.
Overview
Discover how to improve your information management skills by mastering Microsoft’s Office suite solution with this Access 365 Beginner course. Access distinguishes itself from other platforms by being an easy-to-use tool for creating business applications, using templates or personal requirements. Its versatile design tools make it an excellent choice for those with minimal IT knowledge to learn how to perform database management tasks and produce reports. This insightful and comprehensive training makes that possible for anyone at any level.
This Microsoft Access tutorial provides all of the hints and tips that you would expect from a computer skills beginner’s course… and much more besides. It has been written, crafted, and presented by experts in the field in order to engage and teach those with minimal experience with the system. With its guidance, you will soon be relating data tables, adding records, calculating details, and so much more. Take advantage of the latest version of the popular business application tool and ensure that your data handling skills give you the edge in business.
What you'll learn
- Learn how to get started with Access and understand data terminology
- Discover how to work with raw data and navigate tables
- Know how to create databases and objects
- Gain the ability to calculate numbers and link tables
- Explore the best ways to create and work with data queries
- Understand how to use wildcards and keywords to find results
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 Beginner 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 Getting Started with Access | |||
| What is a Database | 00:03:00 | ||
| Database Terminology | 00:05:00 | ||
| The Access Interface | 00:08:00 | ||
| What is a Flat File Database | 00:03:00 | ||
| What is a Relational Database | 00:10:00 | ||
| Relating Tables | 00:10:00 | ||
| Reviewing The Access Ribbon | 00:02:00 | ||
| Module 2 Working with Data | |||
| Working with Tables | 00:07:00 | ||
| Navigating Tables | 00:04:00 | ||
| Editing Data | 00:03:00 | ||
| Adding New Records | 00:05:00 | ||
| Using Subdatasheets | 00:04:00 | ||
| Module 3 Creating Databases and Objects | |||
| Understanding Database and Table Design Principles | 00:08:00 | ||
| Using Table Data Sheet View | 00:03:00 | ||
| Working with Field Data Types | 00:07:00 | ||
| Using Table Design View | 00:04:00 | ||
| Calculating Numbers | 00:05:00 | ||
| Calculating Dates | 00:02:00 | ||
| Calculating Strings | 00:03:00 | ||
| Using The Lookup Wizard | 00:12:00 | ||
| Lookup Wizard Linking Tables | 00:09:00 | ||
| Using Indexes | 00:04:00 | ||
| Module 4 Working with Queries | |||
| What are Queries? | 00:08:00 | ||
| Creating Simple Queries | 00:05:00 | ||
| Entering Criteria-Exact Match and Range Operators | 00:05:00 | ||
| Understanding And Versus Or | 00:06:00 | ||
| Using Wild Cards | 00:05:00 | ||
| Using Key Words | 00:04:00 | ||
| Sorting and Hiding Fields | 00:03:00 | ||
| Creating Multi-Table Queries | 00:03:00 | ||
| Additional Tips C4 | 00:06:00 | ||
| Module 5 Working with Reports | |||
| What are Reports | 00:05:00 | ||
| Understanding Report Types | 00:03:00 | ||
| Building Good Reports | 00:02:00 | ||
| Using AutoReport | 00:08:00 | ||
| Understanding The Report Wizard | 00:11:00 | ||
| Using the Report Design View | 00:08:00 | ||
| Printing Reports | 00:04:00 | ||
| Creating labels | 00:08:00 | ||
| Additional Tips C5 | 00:10:00 | ||
| Module 6 Working with Forms | |||
| What are Forms | 00:04:00 | ||
| Understanding Form Types | 00:03:00 | ||
| Creating Forms | 00:03:00 | ||
| Navigating Forms | 00:03:00 | ||
| Editing Data in Forms | 00:05:00 | ||
| Understanding the Form Wizard | 00:05:00 | ||
| Using Form Design View | 00:04:00 | ||
| Working with Controls | 00:10:00 | ||
| Using Form Layout View | 00:04:00 | ||
| Additional Tips C6 | 00:07:00 | ||
| Resource | |||
| Resource – Access 365 Beginner | 00:00:00 | ||
| Final Exam | |||
| Final Exam – Access 365 Beginner | 00:20:00 | ||
