CPE Online Course Detail

Using SQL View in Microsoft Access 2007

Price :   $19.95
CPE Credits :   2.0
Course Code :   S009-0224
Category :   Computer Software

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.

Delivery Method: Online Self Study

Level: Overview

Prerequisites: None

Advanced Preparation: None

Policies: Click here

Author: Jay R. Carlson

Category: Computer Software

Field of Study: NA

Passing Score: 70%

Publication Date: 01/13/2009

For More Detail: Click here

Module 1: Overview of Access 2007 and Using SQL View
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 2: Calculations in SQL View
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

For More Objectives: Click here


QAS: Yes

CPA: Suitable for all CPAs

IRS: Enrolled Agents Program Number

© 2016 MasterCPE LLC
7683 SE 27th St., #216
Mercer Island, WA 98040


Continuing Education for Smart Professionals