Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

9/10/2013 12:40:21 AM
Microsoft Access Expert 13
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

Microsoft Access Expert Level 13 is 1 hour, 22 minutes long. This tutorial will focus on using Update Queries to manipulate data in your tables. Topics include:

- Update Queries
- Types of Action Queries
- Report Where Conditions
- Datasheet View vs Run Query
- UCase, LCase, Proper Case
- Deleting Tables with Relationships
- Assign Sales Rep by State
- Add 5% to all Product Prices
- Update Paid Orders with Ship Date

Click here for more information on Access Expert Level 13, 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 12. The next class in the series is Access Expert Level 14.

Permanent Link
Course Link: Microsoft Access Expert 13
Keywords: access expert 13 update queries
Page Tag: whatsnew
Post Reply

Order2Q not OrderQ Comment from Michael Larsen @ 12/7/2015
Dear Richard
At 17:09 you say "Order2Q", but you go on to open OrderQ and modify that Query.
Just a slight slip of the tongue.

Thanks for an excellent course.

Show Just This Thread        Post Reply
Refresh Macro Comment from Bonnie Staib @ 2/3/2015
In Access 2013 Expert 13, just as lesson one is ending (at 26:12) Richard tests his browse between dates button. The prompt comes up immediately. My macro will only work if I remove the refresh record action in the macro. (Message: The Command or action "Refresh' isn't available now.")Once I remove the RefreshRecord action, it works fine. Yet, it looks like Richard did not have to remove this. Why would he be able to leave it in? Did anyone else have this problem?
Thanks, Bonnie

Reply from Alex Hedley:

Try repeating the lesson again, there might be something missed.
Anyone else have this happen to them?
Show Just This Thread        Post Reply
Just a point of clarification Comment from Chris Thompson @ 1/29/2015
Just a point of clarification. At 18:41 you say that "...the focus of the advanced classes is going to be on Macro design; but there are some things at are so much easier to do if I can just teach you a little bit macro editing...".

Is that what you meant to say or should it have been "VBA design" and "macro editing"?

Reply from Alex Hedley:

More than likely, probably a bit of word salad.

Show Just This Thread        Post Reply
CustomerT Comment from Kenny Nelson @ 12/30/2014
At 3:15, you are restoring your saved copy of the CustomerT.  To avoid the relationship issue, can you copy the Copy Of CustomerT2 back to the CustomerT?  I was afraid if I deleted the CustomerT it would affect my queries that used that table.

Reply from Alex Hedley:

Do you mean rename or copy the data from one to another as that would cause the AutoNumbers to change?
Show Just This Thread        Post Reply
Can you use the Choose function instead of the IIf Comment from Bruce Reynolds @ 11/24/2014
Can you use the Choose function instead of the IIf function? Is there a Choose function in Access?

Reply from Alex Hedley:

Yes there is and yes you can.
The CHOOSE function is covered in Access Expert 25.
Show Just This Thread        Post Reply
Parameter Value Comment from vicki Hudson @ 10/26/2014
at aprrox 26:12 after the build event I get an Enter parameter  value, Forms!OrderF!OrderID. Why should I have a form open at this point? I can click "OK" and it prompts for BeginDate and EndDate like it should. Just not sure about the Forms parameter value.

Reply from Alexander Hedley:

Is your OrderF Form closed?
Show Just This Thread        Post Reply
prompt calendar Comment from ryan Chung @ 7/7/2014
Just a quick question, instead of making it prompt to enter the dates how can i make it prompt a calender? where i can select the dates?

Reply from Richard Rost:

If you're using a parameter query, you have no choice but to type in dates. If you're getting the values from a FORM then you can use the date field popup calendar from a text box.
Show Just This Thread        Post Reply
Disabled Mode Comment from Brauna @ 11/27/2013
Hi again Richard,
You could ignore my question.  As it turns out the database I was working with at the time was not in a "Trusted Location" It is fixed now.  Thanks again.  
Your tutorials are great, by the way.  I have been able to create a database for a doctor's office and is now functioning very well.

Reply from Richard Rost:

That'll do it. :)
Show Just This Thread        Post Reply
Disabled Mode Comment from Brauna Rosen @ 11/26/2013
Hi Richard,
I tried to correct name fields to Upper and Lower case but I got an error message: 'This action or event has been blocked by Disabled Mode"  Do you know why that is happening?

Reply from Richard Rost:

Not sure what you mean. Could you give me more details, please?
Show Just This Thread        Post Reply
Locking an invoice Comment from Maurice C @ 10/2/2013
Thanks for another excellent lesson. My question today is a general question about invoicing procedures. At some stage an invoice should be "locked down" so it can't be accidentally altered thereby affecting your year-to-date records.
I've been wondering about this for a while but can't work out how to do this.
Have you any ideas on this?

Kind regards


Reply from Richard Rost:

This would involve some programming. I would make an OnCurrent event which would set the AllowEdits and AllowDeletions properties of the form to NO after the invoice is a certain number of days old.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 5+5:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



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

8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9

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 Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
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 Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP