Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Microsoft Access Expert 4
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 years ago

This is the fourth Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 3 left off.

This class is 1 hour, 48 minutes long and focuses primarily on new types of form controls including option groups, toggle buttons, the image control, and more. We'll also learn about one-to-one relationships, and practice more with one-to-many relationships. You will learn:

- Additional Form Controls
- Option Groups, Tab Control
- Toggle Buttons, Enhanced Formatting
- List Box, Image Control
- Display Image Without Storing
- One-to-One Relationships
- Extended Customer Details
- More One-to-Many Relationships
- Track multiple family members

This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. Click here for more information on Access Expert Level 4, including a course outline, sample videos, and more.

Extended family circular ref Upload Images   Link 
Andres Trujillo 
21 days ago
Gold standard for database design: as in the case of the extended family member.  Is the gold standard to have one table for contact list and then have fields for identifying/classifying others i.e. customer vs employee, parent vs child?  If you have one table with classification of customer versus employees and then you develop family members, would you put the family in the same table and how do you relate them to someone else in the same table and classify them.  Are you not creating a circular reference?
Adam Schwanz
21 days ago
Tables that store the same information should be grouped together generally. In this case "People", it could be employees, customers, children or whatever you want, if you store the same information for all of them, it's easier to put them together in a table and then add fields to identify what they are. If you are not storing the same information and you don't really care about the childs information, you just want to link the child to the parent, you could make another table with a one to many relationship if you want.
Scott Axton
20 days ago
Check out the Self Join Relationships video.  That might help clarify some of your questions.
Add a Reply
Toggle buttons Upload Images   Link 
Andres Trujillo 
21 days ago
The biggest issue I have as an end-user with toggle buttons is: identifying if they are depressed, does the color change mean they are depressed, whats the base/foundation color and wheat her they are depressed or not, does that mean yes or no, true or false, off or on?
Adam Schwanz
21 days ago
You can use the text caption too. Make it "THIS BUTTON IS PRESSED" if you want to ;).
Richard Rost
19 days ago
I personally don't like toggle buttons. I almost never use them. I just show you how to use them in class because... well... I kinda have to. LOL. I personally use check boxes for everything that's yes/no.
Add a Reply
Access Expert 4 Video 2 Upload Images   Link 
Andres Trujillo 
21 days ago
When developer makes a list box as in the reward list box and setting setting it to 0 so there is no default, the problem: when end-user highlights any option,  it can no longer be 0. Is there a way so end-user can have nothing selected?
Scott Axton
21 days ago
A list box can be "blank" to start up say in a new record. Unfortunately  once you select an item from the list box there  isn't any easy to clear the selections.

You best option would be to put a "None" selection in the box and then use that value to handle the criteria for your needs.  There are other options if you know some VBA.

Richard Rost
19 days ago
Yeah, clearing the selected value from the list box requires one line of VBA:

MyListBox = 0

That assumes the bound column (ID) is based on an AutoNumber.
Add a Reply

Show Older Comments...
View in Table Format

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:

10/17/2021Date Only?
10/16/2021Relink Tables
10/16/2021Access Developer 34
10/16/2021Access Developer 34 Lessons
10/16/2021Access Developer 34
10/10/2021Copy Text from Field
10/10/2021Access for Free
10/8/2021Label Resize
10/2/2021Criticisms of Access

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
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 expert 4 form controls one to one image option groups toggle buttons tab controls  Page Tag: whatsnew  PermaLink