Chapter 4 Highlights & Objectives in Accounting Info Systems by Dr. Peter R. Gillett, Study notes of Accounting

Download Chapter 4 Highlights & Objectives in Accounting Info Systems by Dr. Peter R. Gillett and more Study notes Accounting in PDF only on Docsity! 33:010:458 Accounting Information Systems Dr. Peter R. Gillett Associate Professor Department of Accounting, Business Ethics and Information Systems Rutgers Business School–Newark and New Brunswick October 22, 2008 Dr. Peter R. Gillett 2 Accounting Information Systems A.I.S. Class 15: Outline Learning Objectives for Chapter 4 Quiz for Chapter 4 Chapter 4 Highlights Group Work for Chapter 4 October 22, 2008 Dr. Peter R. Gillett 5 Accounting Information Systems Chapter 4 Quiz ? October 22, 2008 Dr. Peter R. Gillett 6 Accounting Information Systems ACCESS Objects Tables Queries Forms Reports Pages Macros Modules October 22, 2008 Dr. Peter R. Gillett 7 Accounting Information Systems ACCESS Data Types Text Memo Number Date/Time Currency AutoNumber Yes/No OLE Object Hyperlink Lookup Wizard October 22, 2008 Dr. Peter R. Gillett 10 Accounting Information Systems Chapter 4 Highlights Comparison Operators * <, <=, >, >=, =, <>, Between, In, Like Wildcards * ?, *, # Logical Operators Performing calculations with Queries Grouping and summarizing data * Aggregate functions Outer joins Parameter Queries October 22, 2008 Dr. Peter R. Gillett 11 Accounting Information Systems Group Work for Chapter 4 Practice Exercises 1, 3 Problems 1, 2, 4 Identify by name and job title all Sales employees whose total sales amount to less than $250,000