Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 32 Minute(s)
Language
English
Taught by
Kirt Kershaw
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Microsoft Access skills that will give you a solid foundation from a Microsoft Certified Access Specialist
Quickly Get a Solid Foundation on Access Basics
During this Microsoft Access Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Access experience on. Enroll now and I'll guide you step-by-step, through the basics of creating relational databases and working with Tables, Queries, Forms and Reports. In very little time you will master the basics of Access that'll provide a sure foundation for more advanced Access techniques.
At completion of this course you will have mastered the most popular Access basic tools and have the foundational skills with a sureness to complete many daily Access tasks with efficiency and ease. Below are just a few of the topics that you will master in Access:
Build a solid understanding on the basics of Microsoft Access
Step by step in creating Microsoft Access Databases
Create Tables and how to enter, filter and sort Records
Create Primary, Composite and Foreign keys to link Tables
How to create relationships One-to-One and One-to-Many
Create a Query and how to add calculating fields
Create Forms to view records in a more organized layout
Use Reports to display your records in printable and/or email formats
Course Content
- 8 section(s)
- 46 lecture(s)
- Section 1 Access Introduction
- Section 2 Access Level 1 - Beginner
- Section 3 Basics
- Section 4 Tables
- Section 5 Queries
- Section 6 Forms
- Section 7 Reports
- Section 8 Course Wrap Up
What You’ll Learn
- How to create an Access Database from scratch
- Create Tables to store and organize all raw data
- Use a Query to search and retrieve data fast
- Enter and view records in a more organized layout using Forms
- Generate very detailed, professional looking Reports
- Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training
Skills covered in this course
Reviews
-
RRaymond George Feyes
Too complicated
-
MMarie Elena Villanueva
It was a good course, however, many times throughout the course the audio would fade out and the screen would go out of focus. Maybe it is time to rerecord the course.
-
AAleksandra Falkowska
A very good course. It feels like it covers everything.
-
CC
Excellent very clear and methodical. I have extensive knowledge of Word and Excel but none in Access so I did know some common features but the teaching is so concise I wasn't sat for whole lessons bored. It doesn't matter that this is a couple of years old - most features are the same but more importantly he teaches the principles of doing things, where commands are likely to be, so these skills are easily transferable. Highly highly highly recommended.
