Access 365 Beginner

Access 365 Beginner

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

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

Certification

After completing this course's assessment, you will be eligible for:

OE Certificate@2x-100 (1) (1) (1)
Transcript

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

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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon