We hope you enjoyed this lesson.
Cool lesson, huh? Share it with your friends
About this lesson
Who this course is for, what to expect and a first look at the database we will be creating in this course.
Download this lesson’s related exercise files.Introduction to Access 2021 - Exercise
110.6 KB Introduction to Access 2021 - Solution
49 KB TechGurusTicketing_Completed_Database.accdb
Introduction to Access 2021
An introduction to Access 2021 including what to expect, how to use the course files, who the course is for, and a quick look at the database we will be building in this course.
When to use
Go through the introduction lesson to gain an understanding of how this course works and to see the finished version of the database.
Who is this course for?
Access 2021 for Beginners is aimed at complete beginners or people who have a basic level of Access knowledge and would like to solidify their foundational skills. No prior knowledge of databases is required to complete this course.
What is Access?
Access is a relational database management system. We create one or more tables to hold our data, create relationships between the tables and use queries, forms, and reports to interrogate the data.
What Are We Aiming For?
In this course, we will be creating a fictional database for a company called 'Tech Gurus'. Tech Gurus is an IT Solutions company that provides IT Support to customers. We will be creating a basic ticketing system to log issues.
- Open the file 'TechGurusTicketing_Completed_Database.accdb' to see the finished version of the database.
- In the navigation pane, double-click on the form 'frmTicketMaintenance'.
This beginners course will not include complex reporting, advanced skills, macros, or modules.
Before we begin this course, open Access Options and check the default location for saved files.
- Click the File tab.
- Click Options.
- From the General page, ensure the Default database folder is set to a folder that is easily accessible.
Course and Exercise Files
This course contains downloadable course and exercise files. Each lesson contains two course files: a start file eg. 'TechGurusTicketing01.accdb' and a completed file, 'TechGurusTicking01 - Complete.accdb'.
Open the start file to work along with me. If you get lost, stuck, or want to skip ahead, there is a completed version for each lesson.
Exercise files are included in the course so we can practice the skills we have learned. A solution file is included so we can check our answers.
Ensure that you have all course and exercises files downloaded to an easily accessible folder.Login to download
Lesson notes are only available for subscribers.