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 16
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 years ago

Microsoft Access Expert Level 16 is 1 hour, 19 minutes long. In this class we will continue to learn how to use Action Queries. We will start by creating a macro to run multiple queries at once, and we'll learn about make-table and union queries. Topics include:

- Macro to Run Multiple Queries
- Delete Query on Multiple Tables
- Referential Integrity with Delete Queries
- Make Table Queries
- Backup Table to Another Database
- Multiple Parent Student Mailings
- Include Multiple Parents in Mailings
- UNION Queries
- Merge New Contacts with Archived Ones

Click here for more information on Access Expert Level 16, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 15. The next class in the series is Expert Level 17.

Lesson 2 Delete Query Multipl Upload Images   Link 
Michel Paul 
33 days ago
I am using Acccess 365. When trying the example shown in the video, I have realized that doing the first way to filter the records directly in the query now works fine. I don't need to use nested queries like you showed. Read More...
Richard Rost
32 days ago
Awesome. Thanks for sharing.
Add a Reply
Missing Customers Upload Images   Link 
Katheryn Hartig 
5 years ago
At 3:38 you had 3 CA customers in the CustomerT but at 3:52 when you ran the query, only 2 CA customers displayed...?


Reply from Alex Hedley:

Did the Query have a criteria on it? Read More...
Add a Reply
Homework Upload Images   Link 
Stephen Egan 
6 years ago
I am working on the homework for Expert 16.  I tried to run the OrderBackupMakeTableQ and received a message Calculated Columns are not allowed in Select Info statements.  I checked the fields in OrderT.  It looks like DayToShip is the problem as it is a calculated field. I am not sure how to handle this.  I don't think I can change is like we did with the Notes field in CustomerT.  I need a clue on how to handle this Read More...
Add a Reply
State CustomerT Upload Images   Link 
Clarice Barkhordarian 
6 years ago
Sorry, I figured out what it was.  In my CustomerT for the State I have input mask = >L?? that was not transferred to the new table.
Add a Reply
State CustomerT Upload Images   Link 
Clarice Barkhordarian 
6 years ago
The State in my CustomerT is 2 letters in Caps but in the new table it changes to lower case.  Why is that? and how can I change that?
Add a Reply
Set Warnings Homework Upload Images   Link 
Michael 
6 years ago
Alex - Amazing! I opened a blank database and put a command button on a blank form. I was able to activate "Show All Actions." I wonder if the issue is that I started the PC Resale.com database in Access 2007 and imported it into Access 2013? No worries. I plan to take all of the courses over again, so I'm sure it'll work when I start the DB from scratch in 2013. Thanks for your help! M. Read More...
Add a Reply
Set Warnings Homework Upload Images   Link 
Michael 
6 years ago
Hi Alex, No, there aren't any warnings that challenge me when I open the PC Resale.com database. (I don't have to enable anything.)


Reply from Alex Hedley:

Can you try with a blank new database also in the trusted location. Read More...
Add a Reply
Set Warnings Homework Upload Images   Link 
Michael 
6 years ago
On my previous question about the Set Warnings, I wanted to let you know that I am using Access 2013 and I do have the database saved in a trusted location. Thanks again for your help.
Add a Reply
Set Warnings Homework Upload Images   Link 
Michael 
6 years ago
Hi Richard/Alex,
Our homework assignment from Expert 15 was to turn the Set Warnings off, run the append query, run the delete query and then turn Set Warnings back on. I'm not sure why, but I cannot activate the "Show All Actions" command in the Macro Ribbon to adjust the Set Warnings. My database is saved in a trusted folder. I'm not having any luck finding help on the Internet - can you help me? Read More...
Add a Reply
Broken Union Query Upload Images   Link 
Chris Thompson 
6 years ago
Around 5:00 you speak of the Union Query button not working or not sure. I have also found it is broken and did the same thing as you have shown - SQL only. The reason for my stating this is to also state that it is broken (or behaves the same) in both Access 2007 and 2010 as well. Read More...
Keith Stanton
4 months ago
Using Office 365, clicking the union button does the same thing still.
Richard Rost
4 months ago
Yeah, the Union query button is garbage. Doesn't work. You need to write it in plain SQL yourself.
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/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/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
 

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 expert 16 make table macro union  Page Tag: whatsnew  PermaLink