Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

by: Adamski,Joseph J.

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

by: Adamski,Joseph J.

ISBN 13:
9781418839086
ISBN 10:
1418839086
Edition: 1st
Format: Paperback
Copyright: 03/30/2005
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Access 2003. A great case-based introduction to Access, this text covers everything from queries and forms to creating custom reports and integrating Access with the Web and with other programs. Perfect for any introductory course or used in conjunction with our other Microsoft Office application books. Includes expanded appendix on Relational Databases.

Preface

Office

(2)

Read This Before You Begin

(1)

Using Common Features of Microsoft Office 2003

Preparing Promotional Materials

(1)

Exploring Microsoft Office 2003

(1)

Integrating Office Programs

(1)

Starting Office Programs

(4)

Switching Between Open Programs and Files

(1)

Exploring Common Window Elements

(1)

Using the Window Sizing Buttons

(2)

Using Menus and Toolbars

(3)

Viewing Personalized Menus and Toolbars

(3)

Using Task Panes

(2)

Opening and Closing Task Panes

(1)

Navigating Among Task Panes

(1)

Using the Research Task Pane

(2)

Working with Files

(5)

Creating a File

(1)

Saving a File

(2)

Closing a File

(1)

Opening a File

(1)

Getting Help

(6)

Using ScreenTips

(1)

Using the Type a Question for Help Box

(2)

Using the Help Task Pane

(2)

Using Microsoft Office Online

(2)

Printing a File

(1)

Exiting Programs

(1)

Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(1)

SAM Assessment and Training

(1)

Quick Check Answers

Access

Read This Before You Begin

(1)

Introduction to Microsoft Access 2003

(32)

Viewing and Working with a Table Containing Employer Data

(1)

Session 1.1

(1)

Introduction to Database Concepts

(3)

Organizing Data

(1)

Databases and Relationships

(1)

Relational Database Management Systems

(1)

Opening an Existing Database

(3)

Exploring the Access and Database Windows

(1)

Opening an Access Table

(2)

Navigating an Access Datasheet

(1)

Printing a Datasheet

(1)

Saving a Database

(1)

Session 1.1 Quick Check

(1)

Session 1.2

(1)

Working with Queries

(5)

Opening an Existing Query

(1)

Creating, Sorting, and Navigating a Query

(3)

Creating and Navigating a Form

(2)

Creating, Previewing, and Navigating a Report

(4)

Printing Specific Pages of a Report

(1)

Managing a Database

(4)

Backing up and Restoring a Database

(1)

Compacting and Repairing a Database

(1)

Compacting a Database Automatically

(1)

Converting an Access 2000 Database

(1)

Session 1.2 Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(1)

Case Problems

(3)

Internet Assignments

(1)

SAM Assessment and Training

(1)

Lab Assignments

(1)

Quick Check Answers

(1)

Creating and Maintaining a Database

(46)

Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table

(1)

Session 2.1

(1)

Guidelines for Designing Databases

(2)

Guidelines for Setting Field Properties

(3)

Naming Fields and Objects

(1)

Assigning Field Data Types

(1)

Setting Field Sizes

(1)

Setting Field Captions

(1)

Creating a New Database

(1)

Creating a Table

(11)

Defining Fields

(7)

Specifying the Primary Key

(2)

Saving the Table Structure

(1)

Session 2.1 Quick Check

(1)

Session 2.2

(1)

Adding Records to a Table

(3)

Modifying the Structure of an Access Table

(9)

Deleting a Field

(1)

Moving a Field

(1)

Adding a Field

(1)

Changing Field Properties

(1)

Updating Field Property Changes

(4)

Obtaining Data from Another Access Database

(3)

Copying Records from Another Access Database

(2)

Importing a Table from Another Access Database

(1)

Updating a Database

(3)

Deleting Records

(1)

Changing Records

(2)

Session 2.2 Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(2)

Case Problems

(5)

Internet Assignments

(1)

SAM Assessment and Training

(1)

Quick Check Answers

(1)

Querying a Database

(48)

Retrieving Information About Employers and Their Positions

(1)

Session 3.1

(1)

Introduction to Queries

(1)

Query Window

(2)

Creating and Running a Query

(3)

Updating Data Using a Query

(1)

Defining Table Relationships

(6)

One-to-Many Relationships

(1)

Referential Integrity

(1)

Defining a Relationship Between Two Tables

(4)

Creating a Multi-table Query

(2)

Sorting Data in a Query

(5)

Using a Toolbar Button to Sort Data

(1)

Sorting Multiple Fields in Design View

(4)

Filtering Data

100

(2)

Session 3.1 Quick Check

102

(1)

Session 3.2

102

(1)

Defining Record Selection Criteria for Queries

102

(5)

Specifying an Exact Match

103

(2)

Changing a Datasheet's Appearance

105

(1)

Using a Comparison Operator to Match a Range of Values

106

(1)

Defining Multiple Selection Criteria for Queries

107

(5)

The And Logical Operator

108

(1)

Using Multiple Undo and Redo

109

(2)

The Or Logical Operator

111

(1)

Performing Calculations

112

(9)

Creating a Calculated Field

113

(4)

Using Aggregate Functions

117

(2)

Using Record Group Calculations

119

(2)

Session 3.2 Quick Check

121

(1)

Tutorial Summary

121

(1)

Key Terms

121

(1)

Review Assignments

122

(1)

Case Problems

123

(4)

Internet Assignments

127

(1)

SAM Assessment and Training

128

(1)

Quick Check Answers

128

(1)

Creating Forms and Reports

129

(42)

Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report

129

(1)

Session 4.1

130

(1)

Creating a Form Using the Form Wizard

130

(3)

Changing a Form's AutoFormat

133

(2)

Finding Data Using a Form

135

(3)

Previewing and Printing Selected Form Records

138

(1)

Maintaining Table Data Using a Form

139

(2)

Session 4.1 Quick Check

141

(1)

Session 4.2

142

(1)

Creating a Form with a Main Form and a Subform

142

(5)

Modifying a Form in Design View

145

(2)

Creating a Report Using the Report Wizard

147

(11)

Checking Errors in a Report

155

(3)

Inserting a Picture in a Report

158

(2)

Session 4.2 Quick Check

160

(1)

Tutorial Summary

161

(1)

Key Terms

161

(1)

Review Assignments

161

(2)

Case Problems

163

(5)

Internet Assignments

168

(1)

SAM Assessment and Training

168

(1)

Quick Check Answers

168

(2)

Access

Read This Before You Begin

170

(1)

Enhancing a Table's Design and Creating Advanced Queries

171

(50)

Making the Jobs Database Easier to Use

171

(1)

Session 5.1

172

(1)

Creating a Lookup Wizard Field

172

(6)

Displaying Related Records in a Subdatasheet

178

(1)

Using the Input Mask Wizard

179

(4)

Identifying Object Dependencies

183

(2)

Defining Data Validation Rules

185

(3)

Defining Field Validation Rules

185

(1)

Defining Table Validation Rules

186

(2)

Session 5.1 Quick Check

188

(1)

Session 5.2

188

(1)

Using a Pattern Match in a Query

188

(3)

Using a List-of-Values Match in a Query

191

(1)

Using the Not Operator in a Query

192

(1)

Using Both the And and Or Operators in the Same Query

193

(1)

Creating a Parameter Query

194

(4)

Session 5.2 Quick Check

198

(1)

Session 5.3

198

(1)

Creating a Crosstab Query

198

(5)

Creating a Find Duplicates Query

203

(1)

Creating a Find Unmatched Query

204

(2)

Creating a Top Values Query

206

(3)

Session 5.3 Quick Check

209

(1)

Tutorial Summary

209

(1)

Key Terms

210

(1)

Review Assignments

210

(2)

Case Problems

212

(7)

Internet Assignments

219

(1)

SAM Assessment and Training

219

(1)

Quick Check Answers

220

(1)

Creating Custom Forms

221

(66)

Creating a Multi-page Form

221

(1)

Session 6.1

222

(1)

Planning a Custom Form

222

(3)

Designing a Custom Form

222

(1)

Removing the Lookup Feature

223

(2)

Printing Database Relationships and Using the Documenter

225

(3)

Creating a Custom Form

228

(5)

The Form Window in Design View

228

(4)

Adding Fields to a Form

232

(1)

Selecting and Moving Controls

233

(2)

Changing a Label's Caption

235

(2)

Session 6.1 Quick Check

237

(1)

Session 6.2

238

(1)

Resizing Controls

238

(2)

Using Form Headers and Form Footers

240

(5)

Adding a Label to a Form

241

(2)

Adding a Picture to a Form

243

(2)

Changing the Background Color of a Form Control

245

(1)

Creating a Multi-page Form Using Tab Controls

246

(5)

Changing a Control to Another Control Type

251

(1)

Adding Combo Boxes to a Form

252

(3)

Session 6.2 Quick Check

255

(1)

Session 6.3

256

(1)

Adding a Subform to a Form

256

(3)

Displaying a Subform's Calculated Control in the Main Form

259

(5)

Adding a Calculated Control to a Subform's Form Footer Section

260

(1)

Adding a Calculated Control to a Main Form

261

(3)

Changing the Tab Order in a Form

264

(2)

Using a Filter with a Form

266

(9)

Using Simple Filters

267

(1)

Using Filter By Form

268

(3)

Saving a Filter as a Query

271

(1)

Applying a Filter Saved as a Query

272

(1)

Applying an Advanced Filter in a Form

273

(2)

Session 6.3 Quick Check

275

(1)

Tutorial Summary

275

(1)

Key Terms

276

(1)

Review Assignments

276

(2)

Case Problems

278

(7)

Internet Assignments

285

(1)

SAM Assessment and Training

285

(1)

Quick Check Answers

285

(2)

Creating Custom Reports

287

(82)

Creating a Potential Income Report

287

(1)

Session 7.1

288

(1)

Customizing an Existing Report

288

(6)

Report Window in Design View

289

(2)

Resizing and Moving Controls

291

(3)

Hiding Duplicate Values in a Report

294

(1)

Calculating Grand Totals

295

(3)

Session 7.1 Quick Check

298

(1)

Session 7.2

298

(1)

Designing a Custom Report

298

(2)

Reviewing and Modifying Queries for a Custom Report

300

(3)

Assigning a Conditional Value to a Calculated Field

303

(2)

Creating a Custom Report

305

(2)

Sorting and Grouping Data in a Report

307

(2)

Adding Fields to a Report

309

(2)

Working with Controls

311

(3)

Session 7.2 Quick Check

314

(1)

Session 7.3

315

(1)

Adding a Subreport Using Control Wizards

315

(1)

Modifying a Subreport

316

(4)

Adding Lines to a Report

320

(2)

Calculating Group Totals

322

(3)

Defining Conditional Formatting Rules

325

(3)

Using Domain Aggregate Functions

328

(4)

Session 7.3 Quick Check

332

(1)

Session 7.4

332

(1)

Adding the Date to a Report

332

(2)

Adding Page Numbers to a Report

334

(2)

Adding a Title to a Report

336

(6)

Adding a Summary Subreport

342

(3)

Creating Mailing Labels

345

(7)

Session 7.4 Quick Check

352

(1)

Tutorial Summary

352

(1)

Key Terms

352

(1)

Review Assignments

352

(2)

Case Problems

354

(12)

Internet Assignments

366

(1)

SAM Assessment and Training

366

(1)

Quick Check Answers

366

(3)

Integrating Access with the Web and with Other Programs

369

Creating Web-Enabled and Integrated Information for the Jobs Database

369

(1)

Session 8.1

370

(1)

Using the Web

370

(1)

Exporting an Access Query to an HTML Document

370

(3)

Viewing an HTML Document Using Internet Explorer

373

(2)

Creating a Data Access Page for an Access Table

375

(3)

Updating Data in a Data Access Page Using Internet Explorer

378

(2)

Using a Data Access Page to Sort and Filter Records

380

(1)

Creating a Custom Data Access Page

381

(11)

Creating a Blank Data Access Page in Design View

381

(1)

Adding Fields to a Data Access Page

382

(4)

Deleting, Moving, and Resizing Controls in a Data Access Page

386

(1)

Resizing a Section and Applying a Special Effect

387

(2)

Selecting a Theme

389

(1)

Saving and Viewing a Data Access Page

390

(2)

Session 8.1 Quick Check

392

(1)

Session 8.2

392

(1)

Creating and Using a PivotTable in a Data Access Page

392

(12)

Adding a PivotTable to a Data Access Page

394

(1)

Adding Fields to a PivotTable

395

(3)

Using a PivotTable in Page View

398

(3)

Adding a Total Field to a PivotTable

401

(3)

Creating and Using a PivotChart in a Data Access Page

404

(10)

Session 8.2 Quick Check

414

(1)

Session 8.3

414

(1)

Using XML

414

(6)

Importing an XML File as an Access Table

414

(3)

Exporting an Access Table as an XML File

417

(3)

Exporting an Access Query as an Excel Worksheet

420

(3)

Saving the Worksheet and Exiting Excel

422

(1)

Creating Hyperlinks to Other Office XP Documents

423

(5)

Creating a Hyperlink Field in a Table

423

(1)

Entering Hyperlink Field Values

424

(3)

Using a Hyperlink

427

(1)

Session 8.3 Quick Check

428

(1)

Tutorial Summary

428

(1)

Key Terms

428

(1)

Review Assignments

429

(1)

Case Problems

430

(9)

Internet Assignments

439

(1)

SAM Assessment and Training

439

(1)

Quick Check Answers

439

Appendix Relational Databases and Database Design

(1)

Tables

(1)

Keys

(2)

Relationships

(4)

One-to-One

(1)

One-to-Many

(1)

Many-to-Many

(1)

Entity Subtype

(1)

Entity-Relationship Diagrams

(2)

Integrity Constraints

(1)

Dependencies and Determinants

(3)

Anomalies

(1)

Normalization

(6)

First Normal Form

(2)

Second Normal Form

(2)

Third Normal Form

(2)

Natural, Artificial, and Surrogate Keys

(4)

Microsoft Access Naming Conventions

(3)

Summary

(1)

Key Terms

(1)

Review Questions

Glossary/Index

(17)

Task Reference

(5)

Microsoft Office Specialist Certification Grid

Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

9781418839086

1418839086

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

New Perspectives on Microsoft Office Access 2003 : CourseCard Edition, Introductory

9781418839086

1418839086

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products