2 days ago: New Feature: you can now upload your Profile Picture to the site. Check it out!  Dismiss
 
Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

< Previous: Access Expert 2

Next: Access Expert 4 >

Access Expert Level 3

Expert Microsoft Access Tutorial - 1 Hour, 26 Minutes
 
 
This Microsoft Access video tutorial picks up where Expert Level 2 left off. This class 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

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first and last lessons of this course (free of charge), or scroll down for more information.




 

Access Expert Level 3
Description: Access Expert Level 3
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access Expert Level 2
Running Time: 1 Hour, 26 Minutes
Cost: $21.99


This class picks up where Expert Level 2 left off. We'll begin by learning about SQL (Structured Query Language) which is the code behind all of the queries, forms, and combo boxes in your database. You'll learn about the basic components of an SQL statement. You don't have to learn how to write your own SQL at this point, but I want to teach you enough so you can modify the SQL that Access provides for you. It adds a lot of power and flexibility to your database.

 

In the last two classes, we built a Contacts form to track the previous contact history with our customers. In today's class we'll modify it a bit so we can track callbacks for those customers. Need to call Joe Smith tomorrow at 9am? We'll put that into the callback form and tomorrow you can quickly generate a list of everyone you need to call. It's a way to reuse a single table with similar data for multiple purposes.

 

Next we'll learn about something that's VERY powerful in Access: the subform. This is a way for you to show related records inside another form. For example, wouldn't it be nice if you could see the last couple of contacts for a customer right on the customer form without having to open another form up? That's what a subform does for you.

 

Finally, we'll learn how to calculate totals in a form footer. We'll create a products form, a product category form, embed products as a subform, and then create some footer totals to show inventory levels.

 

 

This is the third class in the Access Expert series. If you want to take your database skills to the next level, this is the class for you. Understanding subforms and form footer totals are important tools to the success of your projects. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access Expert Level 3

00. Introduction (7:38)

01. SQL Primer (11:39)
Combo Box Row Source
SELECT FROM
ORDER BY
WHERE
Change Combo Sort
Change Combo Field Order
Record Source for Form

02. Callbacks (19:26)
Modify ContactT
Default Value for Dates
Today's Date
Tomorrow's Date
Tomorrow at Noon
Tomorrow at 9 AM
Modify Contact Form
Custom Date Format
ddd mm/dd/yyyy hh:nn am/pm
Callback Query
Sort by Date
Callback Form
Add button to Main Menu
Add customer name to list
Button to open Customer Form
03. Contact Subform (16:27)
What is a Subform
Master and Sub Forms
Parent and Child Forms
Copy and modify Contact Subform
SQL Statement as Record Source
Sort by Date Reverse Order
SELECT ORDER BY DESC
Subform Object Control
Click and Drag to create Subform
Subform Object Properties
Subform Form Properties
Access Autoform with Subform
Link Master Fields
Link Child Fields

04. Form Footer Totals (23:59)
Product Category Table
Product Table
ProductSubformF
ProductCategoryF
Aggregate Functions
SUM AVG MAX MIN COUNT
Modify Embedded Macro
Change Form Name in Macro
Moving to Access 2013

05. Review (6:41)

 


 
Keywords: SQL, Subforms, Form Footer Totals, microsoft access tutorial, microsoft access tutorial, microsoft access training, select from, order by, where, combo, custom format, master, child, parent, sub form, order by desc, link master fields, link child fields, embedded macro, aggregate functions, sum, avg, max, min, count
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/19/2024 12:07:24 AM. PLT: 0s