Rent 9780324189919 | Building Accounting Systems Using Access 2002

Table of Contents

Working with Windows

(50)

An Overview of Windows

(5)

Starting Windows

... MORE

(1)

Logging On to Windows

(1)

What's on the Desktop

(2)

Using the Mouse

(1)

Becoming More Familiar with Windows

(6)

Anatomy of a Window

(2)

Manipulating Windows

(2)

Getting Help

(2)

The Start Menu

(4)

Opening the Start Menu

(1)

The Programs Menu Item

(1)

The Documents Menu Item

(1)

The Settings Menu Item

(1)

The Search Menu Item

(1)

The Help Menu Item

(1)

The Run Menu Item

(1)

The Shut Down Menu Item

(1)

Working with Programs and Data

(10)

Launching Applications Directly

(4)

Launching an Application from a File

(2)

Switching between Applications

(3)

Sharing Data Among Applications

(1)

Using Windows Explorer

(11)

Opening Drives, Files, and Folders

(1)

Formatting a Floppy Disk

(1)

Creating Folders

(2)

Copying, Moving, Naming, and Deleting Files

(3)

Setting File and Folder Properties

(1)

Launching a Program from Explorer

(1)

Exiting Explorer

(1)

Customizing Windows

(7)

Creating and Using Shortcuts

(3)

Placing Shortcuts on the Start Menu

(1)

Removing Start Menu Items

(1)

Clearing the Start Menu Documents Window

(2)

Customizing the Taskbar

(1)

Restarting Windows

(2)

Exiting Windows

(1)

Summary

(4)

Introduction to Microsoft Access

(60)

Introduction

(4)

What Is Access?

(1)

What Is a Relational Database?

(1)

Starting Access

(1)

Finding Help

(1)

Printing Help

(1)

Exiting Access

(1)

Examining the Access Environment

(9)

Access Work Surface

(3)

Access Objects

(6)

Working with Databases and Tables

(11)

Opening a Database

(3)

Looking at Your Data through Different Windows

(1)

Opening a Table

(2)

Moving Around a Table

(1)

Searching for a Value in a Column

(1)

Changing a Table's Display Characteristics

(2)

Sorting Table Rows

(1)

Printing a Table

(1)

Querying a Database

(15)

Using a Query

(1)

Creating a One-Table Query

(3)

Saving a Query

(1)

Sorting the Results

(1)

Using More Complex Selection Criteria

(3)

Creating Selection Criteria Using the OR Operator

(3)

Including Expressions in a Query

(2)

Printing Dynasets

(1)

Printing Query Definitions

(1)

Creating Action Queries

(5)

Make-Table Query

(1)

Update Query

(2)

Delete Query

(1)

Append Query

(1)

Using Forms

(7)

Viewing a Table through a Form

(1)

Viewing a Query through a Form

(1)

Creating a Form Quickly

(1)

Saving a Form

(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

RENT TEXTBOOKS

Building Accounting Systems Using Access 2002

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products