Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Tips   Templates   Forums   Help   Order   Contact   Logon  
NEW: Excel Expert 11 - Learn XLOOKUP    dismiss
Microsoft Access Expert 4
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4/29/2013 10:19:54 PM

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.

Microsoft Access Expert 4 Link 
Ida Hangen - 9/24/2018
First off I LOVE these classes.  I went back and review Access Expert 4 and was trying to use an option group in another database. However, I do not have a Option Group button in my toolbar.  I do have the Wizard Controls turned on but can not seem to locate the Option Group Button in order to create control buttons.   I went through a repair on Access but still not Option Group.   Do I need to go through a manual process to add a group of toggle or option buttons?  I must have had it at one time as my training Database has these groups on the form per this lesson. Read More...
Add Your Comments
Microsoft Access Expert 4 Link 
Chad M - 1/20/2018
First, thank you for these courses as they have been extremely helpful.  I have two questions about toggles:  1.  Is it possible to create a 3-state toggle (e.g. Green, Yellow & Red options)?  2.  Are toggle buttons able to be printed on either forms or reports?  I've tried both and they disappear... using Access 2013.  Thank you for any insight. Read More...
Add Your Comments
Vannak Hou - 3/26/2016
at 26:05 -- you really confused.  some how I kept typing C:\photos\myfilename but it didn't take b/c I realized that the property is a Textbox not a OLEObject box.  It took me a while.  I was so confused for 30 minutes. Later I found out how to do it.
Add Your Comments
VBA Link 
Vannak Hou - 3/26/2016
Richard, i want to get start learning VBA; do you have anything like this? I have no knowledge in programming at all. Please advise.

Reply from Alex Hedley:

The advanced courses from 301 onwards cover VBA, they are Access 2003 but it hasn't changed much in that respect. Read More...
Add Your Comments
pop up and modal Link 
Elizabeth R - 3/18/2016
Nope. I did figure out a work around. I have multiple displays (3). I found a site that discussed issues that Access has with multiple display setups. They recommended that I set (form property) Auto Center = yes. That fixed the shift of the left shutter bar and the form doesn't disappear off screen (which is why I could see it, or access it.) Not sure if that is the correct work around because I am new and I don't know what auto center is supposed to do. Thanks. Elizabeth Read More...
Add Your Comments

Show Older Posts


Post Your Comments
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:

5/30/2020Two New Access Handbooks
5/30/2020Access Tip Sleep Timer
5/18/2020Access Record Source Property
5/3/2020Access Replace Function
5/1/2020Microsoft Access Tutorials
4/24/2020Access Discontinued?
4/21/2020Date Time Clock Picker Template
4/20/2020Access Backup Record Before Edited
4/17/2020ZIP Code Lookup Template
4/16/2020Access Round Nearest 10

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access expert 4 form controls one to one image option groups toggle buttons tab controls  Page Tag: whatsnew  PermaLink