A.I.S. Class 22: Outline I Learning Objectives for Chapter 8 I - PowerPoint PPT Presentation

A.I.S. Class 22: Outline I Learning Objectives for Chapter 8 I Chapter 8 Quiz I New ACCESS Features Chapter 8 I Learning Objectives for Chapter 9 I Chapter 9 Quiz I New Features Chapter 9 I Group Work for Chapters 8 & 9 I CLASROOM PRESENTATION 5 Dr. Peter R Gillett November 21, 2005 1

Learning Objectives for Chapter 8 I In this chapter you will learn how to use Access to design tables, queries, forms, and reports that can help you to: N Create and maintain employee records N Create and maintain records of time worked N Calculate gross and net pay N Prepare payroll registers N Prepare employee earnings reports N Print payroll check information N Calculate payroll expense and accruals N Calculate payroll tax expense and accruals Dr. Peter R Gillett November 21, 2005 2

Chapter 8 Quiz ? Dr. Peter R Gillett November 21, 2005 3

New ACCESS Features I Forms and Reports without using Wizards I Reports with no details printed I FICA: Int([GrossPay] * 0.07 * 100) / 100 (p. 402) I Grouping data in reports (p. 408) using Group On Dr. Peter R Gillett November 21, 2005 4

Learning Objectives for Chapter 9 I In this chapter you will learn how to use Access to design tables, queries, forms, and reports that can help you to: N Track materials cost N Track labor cost N Allocate manufacturing overhead cost N Create a bill of materials N Accumulate costs in a job order cost system N Summarize and report job costs Dr. Peter R Gillett November 21, 2005 5

Chapter 9 Quiz ? Dr. Peter R Gillett November 21, 2005 6

New Features I Job Order Costing I Process Costing I Hybrid/Operation Costing I Activity-Based Costing I Form/Subform without using Wizards I Triple primary key I Nested Queries Dr. Peter R Gillett November 21, 2005 7

Group Work - Chapters 8 & 9 I Chapter 8: � Discussion Questions 1 - 5 I Chapter 9: � Discussion Questions 1, 2 & 5 Dr. Peter R Gillett November 21, 2005 8

College Computing I We will tackle REPORTING in two stages I Stage 6 of the Group Project requires you to produce COMPLETE reports for just three cycles: � Service Acquisition � Sales � Production Dr. Peter R Gillett November 21, 2005 9

CLASSROOM PRESENTATION I Group Project Stage 5 Dr. Peter R Gillett November 21, 2005 10