| Comments : |
CPE, online, self-study, self study, CPA, CPAs, continuing professional education, continuing education, accounting, accountants, business, commerce, Access, design view, SQL view, queries, database, aggregate functions, operators for computation |
| 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
|
View Cart
