Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Beginner > B2 > < B1 | B3 >
Access Beginner 2

Form Design, Intro to Relationships, Combo Boxes

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now


This course continues where Access Beginner Level 1 left off. We will continue working with form design, adding more to our customer form that we started in the last class. We will then get an introduction to relationships, one of the most important concepts in Access database design. We will add an appointments table & form, and learn how to make a combo box to select a customer from a list. 


Topics Covered

In Lesson 1, we will download the sample database from Level 1. We'll learn about the security warning and what it means that "active content has been disabled." We will set up a Trusted Location on our computer to put our database files in, and then make a shortcut to our database on the Desktop. We'll go over a quick review of the topics covered in Level 1.

In Lesson 2, we will begin rebuilding the customer form we started in Level 1. We will learn how to add, remove, and resize controls. We'll see how to align and size objects relative to each other. We'll see how to modify the foreground (font) and background colors.

In Lesson 3, we will continue working with form design. We'll focus on additional kinds of form formatting. We'll learn the difference between the grid lines and grid dots, and how to change between them. We'll learn how to size objects to the grid. We'll work with some additional object properties like colors, outlines, and fonts. We'll learn about Themes.

In Lesson 4, we will get an introduction to relationships, one of the most important features of an Access database. We will learn what relationships are, why we want to use them, and about the different types of relationships. We'll learn about primary and foreign keys. We'll build a table to track appointments for each customer. We'll learn how to set default values using the Now and Date functions.

In Lesson 5, we will continue working with relationships. We'll build an appointment form. We'll learn how to build a relational combo box so we can pick a customer from a list of customers. We'll make a command button so that we can open the appointment form and see just the appointments for the selected customer.

Finally, we'll take some time to go over popular questions that I've been asked over the past 20 years of teaching this course. We'll discuss customizing the Ribbon and the Quick Access Toolbar. What's the problem if you can't see text as you are typing into a form? How to print a form in design view. How to get your AutoNumbers to start higher than 1. What's a combo box that's always open? What is the maximum size of an Access database, and the max number of fields per table. Can you run Access on a Mac? How to restore a deleted textbox. What's the green triangle that shows up on your fields in design mode. What is a #Name? error? How to deal with "unrecognized database format" errors. Can you change the background color of a checkbox? How to put data from multiple tables on a form. What are the thumbtacks on the file list for? What's an LACCDB file?

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.


Please feel free to post your questions or comments below. Thanks.


Access Beginner 2 Upload Images   Link  
Alexis Cao 
4 days ago
what's the diffirence between the old vision and new beginner 2, i have all the beginner lessons, so need i pay again? Mr. Richard
Scott Axton
3 days ago
Alexis Hello!  This is my perspective as a previous student looking in from the outside.

There is much the same and much that has changed.

The basic difference is that Richard is using the most current version of Access as of the time of the recording.  I think you will find that his teaching style has changed a little bit too.  In my opinion, Richard has grown personally as a Teacher over the years since he last recorded the Beginner 1 and Beginner 2 series.

One of the big advantages that I see so far is the fact that he has recorded lessons now that he can point you to for more information if you want greater detail on a subject right now.  In the past, when the other classes didn't exist, he constantly said, "We will get to that in a future lesson."

Another BIG plus for me is that Richard has included in his lessons coverage of topics that were possibly missed, not covered in depth, or were unclear to people in the past.  He really listened - and still listens - to the feed

Scott Axton
3 days ago
back of his students.  

Some courses you get a free upgrade to the latest version of the recording.  Some there is a small upgrade charge (usually greatly reduced since you are already a student).  I honestly forget what the rules are so will defer to Richard on that one.

To answer an unasked question - Do I need to have / watch this again since I already watched the old version?
Technically - no.  Is it beneficial?  My opinion is absolutely!  
I personally learn in steps and by repetition. (And from my errors. LOL)
I find that going back again reinforces what I knew and I pick up little bits of knowledge I missed the first time.

Sorry for the long reply.  Hope it helps.
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

1/18/2022Access B2 Upgrade
1/17/2022Access Beginner 2 Links
1/17/2022Access Beginner 2
1/17/2022New Record on Top
1/13/2022Missing References
1/13/2022Access Beginner 1 Links
1/11/2022Access Fast Tips
1/11/2022System Defaults
1/10/2022Multi Select List Box

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access beginner 2 form design, intro to relationships, combo box, appointments  Page Tag: whatsnew  PermaLink