Access 2007-2016
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  
 
 
 

< Previous: Access Beginner 4

Next: Access Beginner 6 >

Access Beginner Level 5
Beginner Microsoft Access Tutorial - 1 Hour, 14 Minutes

 
 
This Microsoft Access video tutorial picks up where Level 4 left off. This class covers query criteria in a lot more depth, parameter queries, wildcards, and lots more. Topics include:
 
  - Query Criteria
  - Multiple AND, OR Conditions
  - Inequalities
  - Records Between Two Dates
  - Dealing with Null Values
  - Wildcards and LIKE

  - Parameter Queries
  - Top X Values
  - Formatting Query Field Output

Order Now

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




 

Access 2010 Beginner Level 5
Description: Access 2010 Beginner Level 5
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Beginner Level 4
Running Time: 1 Hour, 14 Minutes
Cost: $12.99


This class picks up where Level 4 left off. We will begin by learning a lot more about query criteria. We will learn how to use multiple AND / OR conditions in the same query. We will learn about the IN keyword to show records in a specified list of values. We'll learn about the BETWEEN keyword to view records between two values.

 

You will learn how to use the NOT keyword. We'll learn about the different kinds of inequalities that you can use in your query criteria. We'll learn about the Show Box which you can use to hide fields from the query output. This is handy if you need to hide sensitive data, like a credit limit, but still need to use that data for your criteria. You'll learn how to use date-based criteria with the Date() function to show, for example, all records in the past, or all records that are more than 30 days old.

 

We'll learn how to deal with empty/blank values with the Is Null and Is Not Null keywords. We'll cover wildcard characters and the LIKE keyword. This will allow you to find things like "all ZIP codes starting with 142," or "all customers with last names starting in S." We'll also see how to use wildcards to find records from a specific month.

 

Next we'll learn about Parameter Queries. These are extremely powerful. A parameter query allows the end-user to type in a value for a query criteria when the query runs. This way if you want to run reports for each state, for example, you don't have to make 50 different queries. The user can just specify "NY" or whatever state they want when the query runs.

 

Finally, in our Questions from Students lesson, we'll cover several different topics, like how to show the Top 10 Values (or Top X values, or Top X percent) in a query, what the drop-down box for the field name in a query is for, why there is a RUN button for queries (instead of just the datasheet view button), and how to format the ouput of query fields.

 

This is a great class for anyone who is wants to learn how to work with queries in Microsoft Access. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access 2010 Beginner Level 5

00. Introduction (6:49)

01. Query Criteria 1 (16:30)
Multiple OR Conditions
Delete a query
Rename a query
"NY" OR "PA"
"NY" OR "PA" OR "TX"
IN ("NY","PA","TX","CA")
Criteria OR Rows
From NY and are Active
AND condition across columns
AND across, OR down
(State=NY) OR (State=PA AND Active=TRUE)
Customers with Credit Limit over $1000
From NY with $1000 or anybody with $1500
AND OR inside of a single critera
BETWEEN keyword

02. Query Criteria 2 (15:40)
NOT Keyword
NOT "NY"
Inequalitites Review
NOT "NY" AND NOT "OH"
"NY" AND "PA"
AND limits query results
OR expands query results
Show box
Hide fields from query
Prevent odd names like "Field1"
Move a query column
Dates in pound symbols
<#1/1/2005#
Recent customers
BETWEEN two dates
d/m/y or m/d/y regional settings
Whether to include endpoints
BETWEEN #1/1/05# AND #12/31/05#
Dates with times can be tricky
>=#1/1/05# AND <#1/1/06#
<Date()
Customers before 30 days ago
<Date()-30
<Now()
Became customers yesterday
>=Date()-1 AND <Date()
03. Query Criteria 3 (8:47)
Is Null
Is Not Null
ZipCode LIKE "142*"
State LIKE "N*"
Email LIKE "*amicron*"
Date LIKE "*/2012"
Date LIKE "5/*/2012"

04. Parameter Queries (11:45)
Separate query for each state
[Enter the state]
Missing field names from tables
Parameters with other criteria
Multiple parameters
Between [Start Date] and [End Date]
Like [Company Name]
Teach your users about wildcards
XYZ*
Like "*" & [Company Name] & "*"
Will cover String Concatenation Later
Build report based on this query

05. Questions from Students (7:55)
Top X Values
Top X% Values
Bottom X Values
Drop-Down List in Query Columns
Change Field
Why the Run Button for Queries
Format Query Field Output
Property Sheet for Query Fields

06. Review (6:40)

 


 
Keywords: Query Criteria, Parameter Queries, Wildcards, LIKE, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 training, AND, OR, BETWEEN, NOT, inequalities, inequality, show box, hide fields, move column, between dates, is null, is not null, like *, multiple parameters, top values, top x, format query field, property sheet
 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
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