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  
 
 
Access 2010 Expert 3
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 years ago

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

This class is 1 hour, 26 minutes long and teaches you the basics of SQL (the language behind all of the queries in your database), form footer totals, subforms, and lots more You will learn...

- SQL Basics
- Future Callbacks for Customers
- Default Value to Tomorrow at 9 AM
- Creating Subforms
- Link Master & Child Fields
- Using SQL in Form Record Source
- Form Footer Totals
- Sum, Avg, Max, Min, Count
- Modifying Embedded Macros

Click here for more information on Access 2010 Expert Level 3, including a course outline, sample videos, and more.

Callback Date Time Upload Images   Link 
Carlos Espinosa 
13 months ago
When adding a new record the call back date and time, will not show up.
Richard Rost
13 months ago
Sometimes the date and time will not appear in a new record of the start adding some kind of data like the notes or description than the default values will populate such as the date and time.
Carlos Espinosa
13 months ago
Fixed it by placing the date/time formatting as a default value on the property sheet of each text box control.
Add a Reply
Awesome teacher Upload Images   Link 
Alexandra George 
5 years ago
Ok, I see. This report is grouped (by Project), but I had the count and avg fields in the page footer before, and now I've moved them to the report footer. Now they work as expected!
Add a Reply
Awesome teacher Upload Images   Link 
Alexandra George 
5 years ago
First of all, you are an awesome teacher--I started off knowing nothing about Access and I have learned so much already! I came back to this video to review form footer totals--I am trying to use the average and count aggregate functions.  I have a report that displays RateIn, RateOut, and Margin (which is a calculated field) for all of my active consultants, along with FirstName, LastName, and Status.  I tried to create a text box for the average margin in my form footer by copy pasting the Margin text box and adjusting the control source to =Avg([Margin]), as well as a count for number of active consultants by doing the same thing only changing control source to =Count([Margin]). When I look in print preview, these fields come up as #Error. Have I done something wrong? Or does it have something to do with either the Margin field being a calculated field or these fields being stored as currency? Thank you for your wisdom! Read More...
Add a Reply
Insert Fields Upload Images   Link 
Elizabeth Roche 
5 years ago
Praise 1st: Love this series of tutorials. I know they've been around a while, but I'm new and they are perfect for the new Access programmer.
Now for my Question:

It is odd to me that I can create a sub form (child) to a parent and not need to have the linking field ie. the ProductID and the Primary Key field ProductCategoryID somewhere in the form. Ie. how does Access handling the insert of these records without that information? Thanks. Elizabeth Read More...
Add a Reply
Callbacks Upload Images   Link 
Kevin Gill 
5 years ago
In lesson Access 2010 Expert 3 part 2 Callbacks. You instruct how to create a button to open customer. How would/do you create a button if the callback is a new contact/client. I understand the theory, and have attempted to SQL it (no joy) and create a button for new record, but still not what I'm wanting. I prefer the button to open the new customer form so that I can enter in this new contact. Read More...
Add a Reply
Can each ID field show up at most 2x in a database Upload Images   Link 
Joe Beniacar 
5 years ago
Can each ID field show up at most 2x in a database   as the P.K. of 1 Table, and the F.K. of another?


Reply from Alex Hedley:

You can have a Foreign Key in as many Tables as you require. You could have many extra tables that hang off CustomerT or need a CustomerID relating to them. Read More...
Add a Reply
Questions Upload Images   Link 
Joe Beniacar 
6 years ago
Hi Richard, I just have a few questions about this lesson:
1)In the ProductT, shouldn't the Quantity field refer to "the Quantity that costs the UnitPrice" (rather than "the Quantity in Inventory") - or, at least, in addition to that QtyOnHand field (for Calculated fields later)? Read More...
Add a Reply
Table access Upload Images   Link 
Joe Beniacar 
6 years ago
Hi Richard.
Thank you for your helpful classes.
Why it is a bad idea for users to have access to the Tables, if they can make the same updates on the forms?
I appreciate the clarification.
Read More...
Add a Reply
Close Tab Upload Images   Link 
Richard Bray 
6 years ago
If I put a button in a form to return to the Main menu, the Form I was in remains in the tab.  Can I get rid of that tab without doing it direct through the x?


Reply from Alex Hedley: Read More...
Add a Reply
How can I add together Sum values in a report foo Upload Images   Link 
Richard Bray 
6 years ago
How can I add together Sum= values in a report footer?


Reply from Alex Hedley:

You can rename your Textboxes in the footer then just add them together in the Control Source of another textbox. Read More...
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.
 
Subscribe
 

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

7/24/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access 2010 expert 3 sql subforms form footer totals  Page Tag: whatsnew  PermaLink