CART

(0) items

Building Accounting Systems Using Access 2002,9780324189919
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Building Accounting Systems Using Access 2002

by
Edition:
2nd
ISBN13:

9780324189919

ISBN10:
0324189915
Format:
Paperback
Pub. Date:
7/25/2002
Publisher(s):
South-Western College Pub
List Price: $132.33

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780324189919
$119.10

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

More New and Used
from Private Sellers
Starting at $1.00
See Prices

Questions About This Book?

What version or edition is this?
This is the 2nd edition with a publication date of 7/25/2002.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.

Related Products


  • Building Accounting Systems Using Access 2000: Using Access 2000
    Building Accounting Systems Using Access 2000: Using Access 2000
  • Building Accounting Systems Using Access 2003 (Book with CD-ROM)
    Building Accounting Systems Using Access 2003 (Book with CD-ROM)
  • Building Accounting Systems Using Access 2007
    Building Accounting Systems Using Access 2007
  • Building Accounting Systems Using Access 2007, 7th Edition
    Building Accounting Systems Using Access 2007, 7th Edition
  • Building Accounting Systems Using Access 2010
    Building Accounting Systems Using Access 2010
  • Building Accounting Systems Using Microsoft Access 2013
    Building Accounting Systems Using Microsoft Access 2013




Table of Contents

Working with Windows
1(50)
An Overview of Windows
1(5)
Starting Windows
2(1)
Logging On to Windows
3(1)
What's on the Desktop
3(2)
Using the Mouse
5(1)
Becoming More Familiar with Windows
6(6)
Anatomy of a Window
6(2)
Manipulating Windows
8(2)
Getting Help
10(2)
The Start Menu
12(4)
Opening the Start Menu
12(1)
The Programs Menu Item
13(1)
The Documents Menu Item
14(1)
The Settings Menu Item
14(1)
The Search Menu Item
15(1)
The Help Menu Item
15(1)
The Run Menu Item
15(1)
The Shut Down Menu Item
16(1)
Working with Programs and Data
16(10)
Launching Applications Directly
17(4)
Launching an Application from a File
21(2)
Switching between Applications
23(3)
Sharing Data Among Applications
26(1)
Using Windows Explorer
27(11)
Opening Drives, Files, and Folders
29(1)
Formatting a Floppy Disk
29(1)
Creating Folders
30(2)
Copying, Moving, Naming, and Deleting Files
32(3)
Setting File and Folder Properties
35(1)
Launching a Program from Explorer
36(1)
Exiting Explorer
37(1)
Customizing Windows
38(7)
Creating and Using Shortcuts
38(3)
Placing Shortcuts on the Start Menu
41(1)
Removing Start Menu Items
41(1)
Clearing the Start Menu Documents Window
42(2)
Customizing the Taskbar
44(1)
Restarting Windows
45(2)
Exiting Windows
47(1)
Summary
47(4)
Introduction to Microsoft Access
51(60)
Introduction
52(4)
What Is Access?
52(1)
What Is a Relational Database?
52(1)
Starting Access
53(1)
Finding Help
54(1)
Printing Help
55(1)
Exiting Access
56(1)
Examining the Access Environment
56(9)
Access Work Surface
56(3)
Access Objects
59(6)
Working with Databases and Tables
65(11)
Opening a Database
65(3)
Looking at Your Data through Different Windows
68(1)
Opening a Table
69(2)
Moving Around a Table
71(1)
Searching for a Value in a Column
72(1)
Changing a Table's Display Characteristics
72(2)
Sorting Table Rows
74(1)
Printing a Table
75(1)
Querying a Database
76(15)
Using a Query
78(1)
Creating a One-Table Query
79(3)
Saving a Query
82(1)
Sorting the Results
83(1)
Using More Complex Selection Criteria
83(3)
Creating Selection Criteria Using the OR Operator
86(3)
Including Expressions in a Query
89(2)
Printing Dynasets
91(1)
Printing Query Definitions
91(1)
Creating Action Queries
91(5)
Make-Table Query
92(1)
Update Query
93(2)
Delete Query
95(1)
Append Query
96(1)
Using Forms
96(7)
Viewing a Table through a Form
97(1)
Viewing a Query through a Form
98(1)
Creating a Form Quickly
98(1)
Saving a Form
99(1)
Editing Data with a Form
100(1)
Querying a Database with a Form
101(1)
Printing a Form
102(1)
Designing Reports
103(4)
Previewing a Report
103(1)
Creating a Report Quickly
104(2)
Saving a Report
106(1)
Summary
107(4)
Databases and Accounting Systems
111(54)
Introduction
112(1)
Database Accounting Systems
112(9)
Events-Based Theories of Accounting
113(1)
Double-Entry Bookkeeping vs. Database Accounting
113(5)
Advantages of Database Accounting Systems
118(2)
Disadvantages of Database Accounting Systems
120(1)
Business Activity Classifications
121(5)
Service Firms
121(1)
Merchandising Firms
122(2)
Manufacturing Firms
124(2)
Transaction Cycles
126(4)
Revenue Cycle
127(1)
Purchase Cycle
128(1)
Payroll Cycle
129(1)
Production Cycle
129(1)
Accounting Information Systems and Database Systems
130(1)
Database Management Systems
131(4)
Pre-DBMS Data Acquisition and Reporting
132(1)
Functions of a Database Management System
133(1)
Advantages of Database Management Systems
134(1)
Disadvantages of Database Management Systems
135(1)
Relational Database Management Systems
135(19)
Database Objects
136(2)
Primary and Foreign Key Attributes
138(1)
Schema of a Relation
139(1)
Data Dictionary
139(1)
The Coffee Merchant Tables
140(3)
Normalization
143(8)
Fundamental Relational Database Operations
151(3)
Introduction to Database Design
154(5)
Creating User Views and Tables
155(2)
Developing Entity-Relationship Models
157(2)
Summary
159(6)
Tables and Queries
165(56)
Access Objects
166(5)
Tables
166(1)
Queries
166(1)
Forms
166(2)
Reports
168(1)
Pages
168(2)
Macros and Modules
170(1)
Separating Tables from Other Objects
171(1)
Working with Tables
171(19)
Defining a Table's Structure
173(2)
Populating a Table
175(2)
Adding a Column to a Table
177(2)
Deleting or Renaming a Table Column
179(1)
Moving a Table Column
179(1)
Establishing Referential Integrity
180(4)
Editing and Removing Intertable Relationships
184(1)
Setting Field Properties
185(5)
Creating and Using Queries
190(26)
Retrieving Selected Rows from a Table
193(3)
Working with a Dynaset
196(3)
Saving a Query and Printing Dynasets
199(1)
Dealing with Many-to-Many Relationships
199(1)
Producing Queries Involving Multiple Tables
200(5)
Performing Calculations with Queries
205(3)
Grouping and Summarizing Data
208(3)
Using an Outer Join in a Query
211(1)
Designing and Using a Parameter Query
212(4)
Summary
216(5)
Access Forms and Reports
221(50)
Creating and Using Forms
222(22)
Putting Forms to Work
222(2)
Viewing Form Types
224(2)
Building a Simple Form
226(3)
Using a Form
229(6)
Creating a Multitable Form and Subform
235(1)
Creating a Form Containing a Subform
236(2)
Modifying a Subform's Column Widths and Labels
238(2)
Altering a Subform's Column Widths
240(1)
Rearranging Form Fields
241(1)
Printing a Form
242(2)
Building and Printing Reports
244(22)
Using Reports
244(1)
Using Report Wizards
244(1)
Examining a Report's Structure
245(1)
Creating a Tabular-Style Report with a Report Wizard
245(3)
Modifying a Report Field's Data Alignment
248(1)
Deleting Controls and Report Sections
249(2)
Saving and Printing a Report
251(1)
Producing a Grouped Data Report
251(3)
Building Reports with Queries and Expressions
254(2)
Creating the Report's First Draft
256(2)
Rearranging and Deleting Report Fields
258(2)
Modifying Existing Labels
260(1)
Creating Calculated Fields
261(3)
Aligning and Sizing Fields
264(2)
Summary
266(5)
Revenue Cycle
271(64)
Introduction
271(1)
Pipefitters Supply Company Revenue Cycle Information
272(1)
Customer Information
273(15)
The Customer Table
274(7)
The Customer Information Form
281(3)
Maintaining Customer Records
284(2)
Useful Variations on the Customer Information Form
286(2)
Inventory Information
288(10)
The Inventory Table
289(4)
The Inventory Form
293(5)
Sales Orders
298(2)
The Sales Order Table
300(14)
The Sales Order-Inventory Table
301(4)
The Sales Order Entry Form
305(9)
Recording Sales
314(1)
The Sales Table
314(10)
The Sales-Inventory Table
315(1)
The Sales Entry Form
316(3)
The Invoice Report
319(5)
Recording Cash Received from Customers
324(5)
The Cash Receipts Table
324(3)
The Cash Receipts Entry Form
327(1)
Cash Receipts Reports
328(1)
Other Revenue Cycle Components
329(2)
Customer Statements
329(2)
Sales Analysis
331(1)
Sales and Accounts Receivable on the Financial Statements
331(1)
Summary
331(4)
Purchase Cycle
335(54)
Introduction
335(2)
Electric Controls Company Purchase Cycle Information
337(1)
Vendor Information
338(7)
The Vendor Table
339(3)
The Vendor Information Form
342(2)
Maintaining Vendor Records
344(1)
Materials Inventory
345(9)
The Materials Inventory Table
345(2)
The Category Table
347(2)
The Materials Inventory Form
349(5)
Purchase Orders
354(15)
The Purchase Order Table
354(2)
The Purchase Order-Materials Inventory Table
356(2)
The Purchase Order Entry Form
358(5)
Printing Purchase Orders
363(6)
Recording Materials Inventory Receipts
369(7)
The Inventory Receipt Table
370(2)
An Inventory Receipt Form
372(2)
Inventory Receipt Reports
374(2)
Cash Disbursements
376(8)
The Cash Disbursements Table
376(2)
The Cash Disbursements-Inventory Receipts Table
378(2)
Printing Checks
380(4)
Purchase Cycle Information on the Financial Statements
384(1)
Purchases and Accounts Payable on the Financial Statements
384(1)
Summary
385(4)
Payroll Cycle
389(48)
Introduction
389(1)
Greenwood Lumber Company Payroll Cycle Information
390(1)
Employee Information
391(16)
The Employee Table
391(6)
The Department Table
397(1)
The Employee Information Entry Form
398(4)
Maintaining Employee Records
402(2)
Employee Information Reports
404(3)
Recording Time Worked
407(9)
The Time Worked Table
408(3)
The Time Worked Entry Form
411(3)
Time Reports
414(2)
Calculating Payroll
416(16)
Payroll Calculation Queries
417(8)
The Payroll Register
425(4)
The Employee Earnings Report
429(2)
Printing Payroll Checks
431(1)
Payroll Cycle Information on the Financial Statements
432(2)
Payroll Expense, Accruals, and Payables
433(1)
Payroll Tax Expense, Accruals, and Payables
434(1)
Summary
434(3)
Production Cycle
437(38)
Introduction
438(1)
Cost Accumulation Approaches
438(4)
Job Order Cost Accumulation
439(1)
Process Cost Accumulation
439(1)
Hybrid Cost Accumulation
440(1)
Implications for Production Cycle Accounting Systems
441(1)
Cost Training vs. Cost Allocation
442(2)
Manufacturing Overhead Allocation
442(1)
Activity-Based Costing
442(2)
Implications for Production Cycle Accounting Systems
444(1)
Electric Controls Company Purchase Cycle Information
444(2)
Tracing and Allocating Manufacturing Costs
446(17)
The Job Table
446(2)
The Direct Materials Inventory Table
448(2)
The Job-Direct Materials Inventory Table
450(2)
The Bill of Materials Form
452(4)
The Time Worked Table
456(7)
Allocating, Manufacturing Overhead
463(1)
Reporting Job Costs
463(9)
Direct Materials Cost
464(1)
Direct Labor Cost
465(1)
Manufacturing Overhead Cost
465(1)
Job Cost Allocation
466(1)
The Job Cost Report
467(3)
Production Cycle Relationships
470(2)
Summary
472(3)
Automating Database Procedures
475(50)
Macros and Visual Basic for Applications (VBA)
475(5)
Automating Database Applications
476(1)
States, Events, and Event Properties
476(4)
Automating Forms with Command Buttons
480(14)
Creating a Command Button
480(2)
Creating a Macro and Attaching It to a Command Button
482(2)
Creating Other Form Navigation Buttons with VBA
484(4)
Printing a Macro, Macro Group, or VBA Code
488(1)
Access Events
489(1)
Improving Navigation Buttons
490(4)
Implementing Database Manipulation Buttons
494(9)
Creating the Save Record and New Record Buttons
494(4)
Modifying VBA Code
498(2)
Creating the Delete Record and Cancel Changes Buttons
500(3)
Automating Internal Control Features
503(11)
Validating User Input
504(6)
Enforcing Business Rules
510(4)
Using a Switchboard Form
514(6)
Adding an Exit Button to the Switchboard Form
516(1)
Adding a Label to the Switchboard Form
517(1)
Modifying a Form's Properties
517(1)
Making a Switchboard Form Open Automatically
518(2)
Summary
520(5)
Index 525


Please wait while the item is added to your cart...