Lessons

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Access 101
Get notifications when this page is updated

Intro

In this lesson, you will get a beginner-friendly introduction to Microsoft Access. We will talk about what a database is, review the different parts of a database, and learn how to design tables, enter and edit data, create basic queries, build a simple data entry form, and make mailing labels. This lesson covers essential concepts to help you start working with Microsoft Access, regardless of which version you are using. This is lesson 1.

Transcript

Welcome to Microsoft Access 101 Introduction to Access. Brought to you by my online learning partner.com and 599CD.com. My name is Richard Rost. I will be your instructor for today's course. You can reach me at Richard at nyolb.com.

Let's go over the objectives for today's course. We are going to learn about Microsoft Access. We are going to learn what a database is and the parts of a database. We are going to design a table. We are going to enter and edit data. We will build a few sample queries. We will construct a data entry form. And we will create some mailing labels.

Our goal is to get you up and running quickly today. We will cover more details in future classes. In today's class, my goal is to just get you up and running, get you building a database, get you working with some data. So we are going to quickly go over tables, queries, forms, and different access database components. In our future classes, we will dive into these topics in more detail. But for today, we want to get you up and running quickly.

Prerequisites. The prerequisites for this course are Windows 101, Introduction to Computers, and Windows 102 or Windows 110, our Introduction to Windows 98 or Windows XP classes respectively. It is also strongly recommended that you have also taken Word 101 and Excel 101. In our Word class, we go over a lot of crucial concepts like cut, copy, and paste. Knowing spreadsheet fundamentals like rows and columns from Excel will really help you when it comes to understanding database technology. So if you have Word 101 or Excel 101, we recommend you watch those courses first. Again, these courses are not required, but they are recommended.

Versions used. In this course, we are going to be using Microsoft Access XP, the 2002 edition, and Windows XP. However, most of this course is valid for just about every version of Microsoft Access or Windows. Whether you are using Access 2000 or even 97, just about everything we are going to cover in today's course will be the same for you.

In addition, the version of Windows that you are using really does not make a difference for today's course. You could be using Windows 95, 98, and so on, and still be able to use this course.

Quiz

Q1. What is the main goal of today's Microsoft Access 101 course?
A. To cover all advanced features of Microsoft Access in detail
B. To get students up and running quickly with the basics of Access
C. To teach programming with Access VBA
D. To demonstrate only form creation in Access

Q2. Which of the following is NOT listed as an objective for today's course?
A. Learning what a database is
B. Designing a table
C. Building complex macros
D. Constructing a data entry form

Q3. Which database components will be introduced in this course?
A. Tables, Queries, Forms, and Mailing Labels
B. Macros, Reports, Security, and Relationships
C. Tables, Reports, Security, and Code Modules
D. Forms, Reports, Charts, and SQL Scripts

Q4. What prior courses are recommended before taking this Microsoft Access course?
A. PowerPoint 101 and Publisher 101
B. Word 101 and Excel 101
C. Outlook 101 and Project 101
D. Visio 101 and OneNote 101

Q5. Which of the following best describes the software versions used in the course?
A. Only the latest version of Microsoft Access is supported
B. Only older versions of Access are used
C. Access XP 2002 edition is used, but the material applies to most versions
D. Access for Mac OS is required

Q6. What knowledge from Excel is said to be helpful for this course?
A. Drawing charts and graphs
B. Understanding spreadsheet fundamentals like rows and columns
C. Writing complex Excel formulas
D. Working with Power Query

Q7. According to the video, how important is the specific version of Windows for completing this course?
A. It must be Windows XP
B. It must be Windows 2000 or higher
C. The version of Windows does not really matter
D. Only Windows 98 is supported

Q8. Which of the following following statements is TRUE about the prerequisites for this course?
A. Word 101 and Excel 101 are required for this course
B. You cannot take this Access course without Windows 102
C. Prerequisite courses are recommended but not required
D. No knowledge of Windows is needed at all

Answers: 1-B; 2-C; 3-A; 4-B; 5-C; 6-B; 7-C; 8-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone is an introduction to Microsoft Access, where I will be guiding you through the very basics of this powerful database application. My name is Richard Rost, and I'll be your instructor for the course. If you ever need to get in touch with me, you can send an email to Richard at nyolb.com.

Let me lay out the objectives for today's lesson. We'll be exploring what exactly Microsoft Access is, what a database is, and the different parts that make up a database system. Together, we will design a table, learn how to enter and edit data, create some sample queries, build a simple data entry form, and even generate mailing labels.

The purpose of this class is to get you started as quickly as possible. We will cover the essential components so that you can begin working with Access right away. I want to make sure you are comfortable setting up a basic database and working with data. As such, we'll take a broad look at tables, queries, forms, and the other core pieces of an Access database. More advanced detail will be reserved for upcoming courses.

Before you start, there are some recommended prerequisites. Ideally, you should have already completed Windows 101, Introduction to Computers, and Windows 102 or Windows 110, which are my introductory classes for Windows 98 and Windows XP. Additionally, I suggest taking Word 101 and Excel 101. In the Word course, we discuss important skills like cut, copy, and paste. Meanwhile, the basics of spreadsheets, such as understanding rows and columns from Excel, are valuable when learning how databases are structured. These courses are not mandatory, but they are strongly encouraged to make learning Access easier for you.

In this class, I am using Microsoft Access XP, which is the 2002 edition, along with Windows XP. Despite this, most of what I'll be teaching applies to almost every version of Microsoft Access or Windows. So, if you have Access 2000 or even Access 97, nearly all instructions and examples will still be relevant. The same goes for your version of Windows. Whether you are working with Windows 95, 98, or a different release, you will still be able to follow along with this course.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Introduction to Microsoft Access

Understanding what a database is

Exploring the parts of a database

Designing a table in Access

Entering and editing data in tables

Building sample queries

Constructing a data entry form

Creating mailing labels