Queries are the "workhorses" of Microsoft Access. This course exhausts the query topics, giving the Access developer amazing tools to use when developing user-friendly, functional databases.
See specific content information below in section and "Attend and You Will Learn."
Who Should Attend
This course is designed for the Access user who wants to be totally proficient with queries. All Access query topics are covered, and participants walk through great examples of each. It is assumed that course participants have had Access Level 1 and Access Level 2 prior to taking this course.
Attend and You Will Receive
Participants who successfully complete this course will receive a certificate of completion from NC State University
Students must have completed Access Levels 1 and 2 prior to attending this course; otherwise, instructor permission is required.
Attend and You Will Learn / Expected Outcome
Attend And You Will Learn
- Show Box
- Naming Fields and Supplying Captions
- Boolean Logic
- Expression Builder
- Summarizing Data Using Subtotals
- Substring Functions
- The IIF Statement
- Displaying Top Values
- Displaying Unique Values
- Join Queries
- Find Unmatched Queries
- Crosstab Queries
- Find Duplicate Queries
- Self-Join Queries
- Make Table