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

a i s class 27 outline
SMART_READER_LITE
LIVE PREVIEW

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


slide-1
SLIDE 1

December 11, 2000

  • Dr. Peter R Gillett

1

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

slide-2
SLIDE 2

December 11, 2000

  • Dr. Peter R Gillett

2

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

slide-3
SLIDE 3

December 11, 2000

  • Dr. Peter R Gillett

3

Chapter 8 Quiz

?

slide-4
SLIDE 4

December 11, 2000

  • Dr. Peter R Gillett

4

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

slide-5
SLIDE 5

December 11, 2000

  • Dr. Peter R Gillett

5

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

slide-6
SLIDE 6

December 11, 2000

  • Dr. Peter R Gillett

6

Chapter 9 Quiz

?

slide-7
SLIDE 7

D r . Peter R Gillett 7

I J o

b O rd e r C

  • st

ing Process Costing

I Hy b

ri d /O p er a ti o n C

  • st

in g

I Activity-Based Costing I Form/Subform without using Wizards I Triple primary key I Nested Queries

slide-8
SLIDE 8

D r . Peter R Gillett 8

  • Chapters 8 & 9

Chapter 8:

F D

iscussion Questions 1 - 5

Chapter 9:

Discussion Questions 1, 2 & 5

slide-9
SLIDE 9

December 11, 2000

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

slide-10
SLIDE 10

December 11, 2000

  • Dr. Peter R Gillett

10

Finally . . .

I Class next Wednesday is scheduled to be

held in Lab 005 in the Levin Building