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 301
Get notifications when this page is updated

Intro

In lesson 301 you will learn how to start building an order entry system in Microsoft Access, including designing order and order detail tables, creating an order form with a subform, setting up fields and default values, and picking up some new tips and tricks for working with forms. We will also have an introduction to VBA (Visual Basic for Applications) to give you the foundation you need for coding in Access.

Transcript

Welcome to Microsoft Access 301, Access Developer Level 1, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.

Today's class is all about starting our order entry system. We are going to design an order table and an order detail table, along with an order form and subform. We will learn some new tips and tricks for dealing with the forms, fields, and default values.

We are also going to have an introduction to VBA, or Visual Basic for Applications coding. Today's class is really a foundation class that is going to get us started learning VBA.

This class follows Microsoft Access 223, and I strongly recommend that you take all of our 100 level and 200 level classes before beginning Access 301. We will be using Microsoft Access XP and Windows XP, however, this class is valid for every version of Access or Windows.

I strongly recommend that you sit back, relax, and watch the video the first time through, and then watch it again a second time while following along with the examples on your computer.

In case you do not wish to build the database yourself, you can get a copy of the database files from AccessLearningZone.com/access/301. If you installed from one of our CD-ROMs or downloaded the tutorial package from our website, you can also look in the Help folder in your program files for this course.

I strongly recommend, however, that you build the database yourself while following along with the videos to get the most out of this course.

Quiz

Q1. What is the primary focus of Microsoft Access 301, Access Developer Level 1?
A. Data analysis using queries and reports
B. Building an order entry system with forms and VBA introduction
C. Advanced database security measures
D. Creating complex charts and graphs

Q2. Which two tables will be designed in this class?
A. Customer and product tables
B. Order and order detail tables
C. Employee and payroll tables
D. Inventory and shipping tables

Q3. What is a key topic introduced in this course?
A. SQL Server integration
B. VBA (Visual Basic for Applications) coding
C. Excel pivot tables
D. Macros for Word

Q4. What is strongly recommended before starting Access 301?
A. Completing all 100 and 200 level classes
B. Skipping to VBA tutorials
C. Having experience with Photoshop
D. Learning C++ programming

Q5. What advice is given for how to approach watching the video lessons?
A. Watch them without taking any notes
B. Skip sections that seem too easy
C. Watch through once, then watch again while following along
D. Only read the transcripts

Q6. Where can students obtain the database files for this course?
A. From their local library
B. By downloading from AccessLearningZone.com or from the course CD-ROM
C. By contacting Microsoft Support
D. By searching Google for sample databases

Q7. Why is it recommended to build the database yourself while following along?
A. Because the pre-built database has errors
B. To get the most learning benefit from the course
C. To win a free course giveaway
D. Because video examples are incomplete

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

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 focuses on beginning our journey into creating an order entry system in Microsoft Access. In this lesson, I will guide you through designing both an order table and an order detail table. We will also work on setting up an order form along with a subform, so you can see how these components interact in a real-world application. As we develop these pieces, I will share useful tips for managing forms, fields, and assigning default values to streamline your workflow.

Another major component of this class is an introduction to VBA, or Visual Basic for Applications. VBA is the programming language that runs inside Access, and today is all about laying the groundwork you will need to start working with coding concepts within your database.

This course builds upon the material covered in Microsoft Access 223, so if you have not already completed the 100 and 200 level classes, I highly recommend doing so before starting Access 301. We are working in Microsoft Access XP and Windows XP for this tutorial, but the lessons and techniques are relevant for any version of Access or Windows.

To get the best results, I suggest you watch the entire lesson once without interruption. After that, go through it again and follow each step on your own computer. This hands-on approach will help reinforce the skills you are learning.

If you prefer not to create the database yourself, you can obtain the database files for this class directly from my website at AccessLearningZone.com, under Access 301. For those who have installed the course from one of our CD-ROMs or have downloaded the complete tutorial package, you can find all necessary files in the Help folder within your program's directory.

I believe that building the database yourself as you watch the videos will ensure you gain a thorough understanding of all concepts, so I strongly recommend taking that approach.

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

This is an introduction to a Microsoft Access tutorial course, outlining what will be covered and providing recommendations for how to follow along.