Author : | Jay R Carlson, MCSE, MCDBA, A+ Certified |
Status : | Production |
CPE Credits : | 3.0 |
IRS Credits : | 0 |
Price : | $26.95 |
Passing Score : | 70% |
NASBA Technical: | No |
Primary Subject-Field Of Study: | Computer Science - Computer Science 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 : |
MS Access 2007 View SQL for a query Tech on the Net
|
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 : | NASBA Registry - 259 |
Keywords : | Computer Science, Using, SQL, View, Microsoft, Access, 2007, cpe, cpa, online course |
Learning Objectives : |
Module One
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
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 |