Excel & Access for Accounting

by Owen, Glenn

• ISBN13: 9780324068573
• ISBN10: 0324068573
• Edition: CD
• Format: Paperback
• Copyright: 2002-03-22
• Publisher: South-Western College/West

Summary

This text teaches a blend of how businesses use spreadsheets and databases in accounting, and a primer on how one might use these tools to solve real accounting problems. It is written in a step by step format with lots of screen shots so that it is easy to follow.

Table of Contents

Preface	ix
Part 1 Excel for Accounting	1	(114)
Excel Tour	3	(32)
Case: Coast Jewelers, Inc.	4	(1)
Excel Basics	4	(4)
What is Excel?	4	(1)
Starting Excel	5	(1)
The Excel Window	6	(1)
The Help System	7	(1)
Working with Files	8	(2)
Opening Files	9	(1)
Saving Files	10	(1)
Entering Information	10	(6)
Entering Data	10	(2)
Changing Column Width and Row Height	12	(1)
Editing Data	12	(1)
Controlling the Appearance of Data	13	(1)
Entering Formulas and Using Functions	14	(2)
More Extensive Use of Formulas	16	(1)
Entering and Editing Formulas	16	(1)
Manipulating Data and Structuring Worksheets	17	(9)
Using AutoFill	18	(1)
Using Relative and Absolute References	18	(2)
Inserting and Deleting Columns and Rows	20	(1)
Working with Multiple Worksheets	21	(4)
Using Headers and Footers	25	(1)
Printing	26	(4)
Using Page Setup	26	(1)
Previewing the Print Job	27	(1)
Printing a Worksheet	27	(2)
Printing and Viewing Formulas	29	(1)
End Note	30	(1)
Practice
Questions	31	(1)
Assignments	31	(2)
Case Problem: Kelly's Boutique	33	(2)
Financial Statements	35	(14)
Case: Coast Jewelers, Inc.	36	(1)
Creating an Income Statement from a Trial Balance	36	(3)
Creating Statement of Retained Earnings from a Trial Balance	39	(2)
Creating a Balance Sheet from a Trial Balance	41	(3)
End Note	44	(1)
Practice
Questions	45	(1)
Assignments	45	(1)
Case Problem: Kelly's Boutique	46	(3)
Financial Statement Analysis	49	(18)
Case: Coast Jewelers, Inc.	50	(1)
Vertical Analysis	50	(2)
Pie Charts	52	(1)
Horizontal Analysis	53	(3)
Column Charts	56	(2)
Ratio Analysis	58	(5)
End Note	63	(1)
Practice
Questions	64	(1)
Assignments	64	(1)
Case Problem: Kelly's Boutique	65	(2)
Depreciation Calculations	67	(16)
Case: Coast Jewelers, Inc.	68	(1)
Performing Depreciation Calculations	68	(3)
Conducting What-If Analysis with the Depreciation Function	71	(1)
Creating a Depreciation Summary	71	(2)
Calculating Depreciation Using Other Methods	73	(2)
Charting Depreciation Expense	75	(3)
End Note	78	(1)
Practice
Questions	79	(1)
Assignments	79	(1)
Case Problem: Kelly's Boutique	80	(3)
Loan and Bond Amortization	83	(16)
Case: Coast Jewelers, Inc.	84	(1)
Loan Calculations	84	(1)
Loan Amortization Schedule	85	(1)
What-If Analysis and the Payment Function	86	(1)
Names in a Worksheet	87	(2)
Present Value in Bonds	89	(2)
Bond Amortization Schedule	91	(1)
What-If Analysis and Goal Seeking	92	(3)
End Note	95	(1)
Practice
Questions	96	(1)
Assignments	96	(1)
Case Problem: Kelly's Boutique	97	(2)
Cash Flow Budget	99	(16)
Case: Coast Jewelers, Inc.	100	(1)
Sales Budget	100	(1)
AutoFormatting a Schedule	101	(2)
Purchase Budget	103	(2)
Sales and Administrative Expense Budget	105	(1)
Cash Receipts Budget	106	(2)
Cash Disbursements Budget	108	(2)
Summary Cash Budget	110	(2)
End Note	112	(1)
Practice
Questions	113	(1)
Assignments	113	(1)
Case Problem: Kelly's Boutique	114	(1)
Part 2 Access for Accounting	115	(122)
Access Tour	117	(26)
Case: Coast Jewelers, Inc.	118	(1)
Access Basics	118	(4)
What is Access?	118	(1)
Starting Access	119	(1)
The Access Window	119	(2)
The Help System	121	(1)
Tables	122	(6)
Creating the Product Table	122	(1)
Creating the Supplier Table	123	(1)
Creating a Category Table	124	(1)
Entering Data into Tables	125	(1)
Establishing Table Relationships	126	(2)
Printing Tables	128	(1)
Queries	128	(2)
Creating a Query	128	(2)
Printing a Query	130	(1)
Forms	130	(3)
Creating a Form	130	(1)
Using a Form to View, Edit, or Add Information	131	(1)
Printing a Form	132	(1)
Reports	133	(3)
Creating a Report	133	(1)
Editing a Report	134	(2)
Printing a Report	136	(1)
End Note	136	(1)
Practice
Questions	137	(1)
Assignments	137	(2)
Case Problem: Kelly's Boutique	139	(4)
Tables	143	(22)
Case: Coast Jewelers, Inc.	144	(1)
Add, Change, and Delete Records	144	(2)
Add Records	144	(1)
Change Records	145	(1)
Delete Records	145	(1)
Add a Picture with an OLE Field	146	(2)
Add an OLE Field to a Table	146	(1)
Add Pictures to a Table	147	(1)
Change the Structure of a Database	148	(11)
Change a Field Size, Row Height, Column Width, and Data Type	148	(3)
Create Validation Rules	151	(3)
Create Default Values	154	(1)
Create Formats and Input Masks	155	(4)
Referential Integrity	159	(2)
End Note	161	(1)
Practice
Questions	162	(1)
Assignments	162	(1)
Case Problem: Kelly's Boutique	163	(2)
Queries	165	(26)
Case: Coast Jewelers, Inc.	166	(1)
Querying Selected Records	166	(10)
Using Character Data in a Select Query	166	(1)
Using Wildcards in a Select Query	167	(2)
Editing a Select Query	169	(3)
Using Comparison Operators and Sorting in a Select Query	172	(3)
Using Compound Criteria and Limiting Output in a Select Query	175	(1)
Performing Calculations	176	(6)
Displaying the Results of Calculations in a Field	177	(1)
Computing Statistics	178	(4)
Action Queries (Update, Parameter, and Delete)	182	(3)
Update Queries	182	(1)
Parameter Queries	183	(1)
Delete Queries	184	(1)
End Note	185	(1)
Practice
Questions	186	(1)
Assignments	186	(2)
Case Problem: Kelly's Boutique	188	(3)
Forms	191	(26)
Case: Coast Jewelers, Inc.	192	(1)
Labels and Text Box Controls	192	(2)
List and Combo Box Controls	194	(4)
List Box Control	195	(1)
Combo Box Control	196	(2)
Calculated Control	198	(3)
Check Box Control	201	(3)
Special Combo Box Control	204	(4)
Subforms	208	(2)
End Note	210	(1)
Practice
Questions	211	(1)
Assignments	211	(2)
Case Problem: Kelly's Boutique	213	(4)
Reports	217	(20)
Case: Coast Jewelers, Inc.	218	(1)
Use a Query to Create a Report	218	(3)
Use Grouping and Summarizing in a Report	221	(2)
Grouping	221	(2)
Summarizing	223	(3)
Modify an Existing Report	226	(7)
Counting and Summing in Report Sections	227	(2)
Lines, Borders, and Formatting in Report Sections	229	(4)
End Note	233	(1)
Practice
Questions	234	(1)
Assignments	234	(1)
Case Problem: Kelly's Boutique	235	(2)
Index	237