logo
ABD
LiveZilla Live Chat Software



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
While System Source is working from home, we are still available for all of your calls and support needs.

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
09/29/20 - VIR - Virtual Online Training - Virtual Instructor-Led
11/05/20 - VIR - Virtual Online Training - Virtual Instructor-Led
12/16/20 - VIR - Virtual Online Training - Virtual Instructor-Led

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.