logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Access Bits & Bytes: Queries

SS Course: 1000169

Course Overview

TOP

During this one-hour live webinar session, our top-rated instructor will demonstrate types of queries that will help students find and analyze data in their own databases. Students are encouraged to ask questions in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files required.

                                                                  

Scheduled Classes

TOP

What You'll Learn

TOP

During this live demonstration you will learn to:

  • Add criteria
  • Calculate
  • Use Parameters

Outline

TOP
Viewing outline for:
  • Adding Criteria
    • Text criteria, wildcards
    • Numerical data, using arithmetic operands
    • Dates using between for ranges
  • Calculating
    • Creating text expressions, concatenating
    • Calculating with numerical fields
    • Summarizing calculations using the totals tool
  • Using Parameters
    • Creating parameters for criteria
    • Creating parameters with wildcards

Prerequisites

TOP

    Who Should Attend

    TOP

    Students looking for an introduction to queries. Students that have a need to make information out of data.

    Next Step Courses

    TOP

    Other Bits & Bytes sessions and Microsoft Office courses.