Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Using SQL View in Microsoft Access 2007 (Course Id 259)

Registry   Add to Cart 
Author : Jay R Carlson, MCSE, MCDBA, A+ Certified
Status : Production
CPE Credits : 3.0
IRS Credits : 0
Price : $26.95
Passing Score : 70%
Course Type: Text - NASBA Registry
Primary Subject-Field Of Study:

Computer Software & Applications - Computer Software & Applications for Course Id 259

Description :

In this course you will learn to work with Design View and SQL View within Access 2007 to create queries. This course will also show how to calculate within the Access database using aggregate functions and operators for computation. This course is designed for moderate to intermediate users of databases.

Usage Rank : 0
Release : 2009
Version : 1.0
Prerequisites : None
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None
Delivery Method : Self-Study
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 04-Apr-2009
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

Text - NASBA Registry - 259

Keywords : Computer Science, Using, SQL, View, Microsoft, Access, 2007, cpe, cpa, online course
Learning Objectives :

Module One
Overview of Access 2007 and Using SQL View

After completing this module, you will be able to:
    1. Document similarities between Excel 2007 and Access 2007
    2. Access and modify Datasheet and Design View options for a table
    3. Use the Query Wizard to create queries
    4. Access and modify Design and SQL View options of a query
    5. Save a query using Save Object As
    6. Create a JOIN statement
    7. Use the WHERE clause and INTO statement.

Module Two
Calculations in SQL View

After completing this module, you will be able to:
    1. Recognize a mathematical operator in Access
    2. Perform basic arithmetic in Design View query
    3. Perform basic arithmetic in SQL View query
    4. Recognize an aggregate function in Access
    5. Use aggregate functions in SQL View query
    6. Use GROUP BY and ORDER BY in SQL View query
    7. Use Ascending and Descending command in a SQL View query
Course Contents :

Module One: Overview of Access 2007 and Using SQL View

Access Overview

Queries in Access 2007

View Options

Query Wizard

Queries That Are Useful

Real World Querying Using Select Into and Join

Review Questions


Module 2:  Calculations in SQL View

Performing Basic Arithmetic in Access SQL

Using SQL Functions

Wrapping Up

Review Questions

Computer Science Course 259 Home: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?