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

A.I.S. Class 27: 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 REMINDERS Dr. Peter R Gillett December 11, 2000 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 December 11, 2000 2

Chapter 8 Quiz ? Dr. Peter R Gillett December 11, 2000 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. 422) I Grouping data in reports (p. 427) using Group On Dr. Peter R Gillett December 11, 2000 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 December 11, 2000 5

Chapter 9 Quiz ? Dr. Peter R Gillett December 11, 2000 6

I J o b O rd e r C ost ing Process Costing I Hy b ri d /O p er a ti o n C ost in g I Activity-Based Costing I Form/Subform without using Wizards I Triple primary key I Nested Queries D r . Peter R Gillett 7

- Chapters 8 & 9 Chapter 8: F D iscussion Questions 1 - 5 Chapter 9: Discussion Questions 1, 2 & 5 D r . Peter R Gillett 8

REMINDERS I Group Projects should be turned in outside my office before class begins on Wednesday, December 13 I You are advised to make copies of project materials you want to retain before final submission I Do not access the databases again after they are “turned in” - we shall be using the date/time stamp to ensure they are completed on time! I Extra Credit Assignments are due outside Professor Gillett’s office before class begins on Wednesday, December 13 I Group Evaluations are due in class on Wednesday, December 13 December 11, 2000

Finally . . . I Class next Wednesday is scheduled to be held in Lab 005 in the Levin Building Dr. Peter R Gillett December 11, 2000 10