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
  

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.


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



Objectives:
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


NASBA: Yes


QAS: Yes


CPA: Suitable for all CPAs


IRS: Enrolled Agents Program Number




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

MasterCPE

Continuing Education for Smart Professionals