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 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 Beginner Level 5
Description: Access Beginner Level 5
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access Beginner Level 4
Running Time: 1 Hour, 14 Minutes
Cost: $9.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 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 tutorial, microsoft access 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
 
 

 

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/28/2024 9:35:09 AM. PLT: 0s