Rent 9780619206727 | New Perspectives on Microsoft Office Access 2003: Comprehensive

Summary Table of Contents

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.

Preface

File Management

(2)

Read This Before You Begin

(1)

... MORE

Managing Your Files

Creating and Working with Files and Folders in Windows XP

(1)

Organizing Files and Folders

(3)

Understanding the Need for Organizing Files and Folders

(1)

Developing Strategies for Organizing Files and Folders

(1)

Planning Your Organization

(1)

Exploring Files and Folders

(5)

Using Windows Explorer

(1)

Navigating to Your Data Files

(2)

Working with Folders and Files

(6)

Creating Folders

(2)

Moving and Copying Files and Folders

(2)

Naming and Renaming Files

(1)

Deleting Files and Folders

(1)

Working with Compressed Files

(2)

Quick Check

(1)

Tutorial Summary

(1)

Key Terms

(1)

Review Assignments

(1)

Case Problems

(2)

SAM Assessment and Training

(1)

Lab Assignments

(1)

Quick Check Answers

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 Screen Tips

(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 Level I Tutorials

(168)

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

(3)

Adding Records to a Table

(1)

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

(40)

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

(1)

Access Level II Tutorials

169

(272)

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 From 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

(72)

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 Pivot Table in a Data Access Page

392

(12)

Adding a Pivot Table to a Data Access Page

394

(1)

Adding Fields to a Pivot Table

395

(3)

Using a Pivot Table in Page View

398

(3)

Adding a Total Field to a Pivot Table

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

(2)

Access Level III Tutorials

441

Read This Before You Begin

442

(1)

Using Action Queries and Defining Table Relationships

443

(46)

Enhancing User Interaction with the Overseas Database

443

(1)

Session 9.1

444

(1)

Action Queries

444

(13)

Creating a Make-Table Query

444

(4)

Creating an Append Query

448

(3)

Creating a Delete Query

451

(2)

Creating an Update Query

453

(4)

Session 9.1 Quick Check

457

(1)

Session 9.2

457

(1)

Relationships Between Database Tables

457

(4)

Many-to-Many Relationships

458

(2)

One-to-One Relationships

460

(1)

Defining M:N and 1:1 Relationships Between Tables

461

(3)

Using Indexes for Table Fields

464

(2)

Viewing Existing Indexes

466

(3)

Creating an Index

468

(1)

Joining Tables

469

(9)

Inner and Outer Joins

469

(3)

Self-Joins

472

(3)

Creating a Self-Join

475

(3)

Session 9.2 Quick Check

478

(1)

Tutorial Summary

479

(1)

Key Terms

479

(1)

Review Assignments

479

(2)

Case Problems

481

(6)

Internet Assignments

487

(1)

SAM Assessment and Training

487

(1)

Quick Check Answers

488

(1)

Automating Tasks with Macros

489

(64)

Creating a User Interface for the Overseas Database

489

(1)

Session 10.1

490

(1)

Implementing a Graphical User Interface

490

(2)

Switchboards

490

(2)

Dialog Boxes

492

(1)

Introduction to Macros

492

(1)

Running a Macro

493

(2)

Adding Actions to a Macro

495

(3)

Single Stepping a Macro

498

(1)

Creating a Macro

499

(5)

Adding Actions by Dragging

500

(4)

Session 10.1 Quick Check

504

(1)

Session 10.2

504

(1)

Using a Command Button with an Attached Macro

504

(3)

Events

505

(2)

Macro Groups

507

(2)

Adding a Macro to a Macro Group

509

(2)

Adding a Command Button to a Form

511

(1)

Attaching a Macro to a Command Button

512

(1)

Creating the Queries Dialog Box Form

513

(2)

Adding a List Box to a Form

515

(2)

Using SQL

517

(4)

Viewing an SQL Statement for a Query

518

(2)

Using an SQL Statement for a List Box

520

(1)

Adding Command Buttons to a Form

521

(4)

Modifying Form Properties

525

(1)

Testing the Queries DialogBox Form

526

(1)

Session 10.2 Quick Check

527

(1)

Session 10.3

527

(1)

Reviewing the Overseas Database Switchboard Requirements

527

(1)

Creating the Macro Group for the Switchboard

528

(4)

Creating a Switchboard

532

(8)

Adding Command Buttons to a Switchboard Page

534

(2)

Moving Command Buttons in a Switchboard Page

536

(1)

Adding Command Buttons to a Second Switchboard Page

537

(1)

Viewing and Testing a Switchboard

538

(2)

Modifying a Switchboard

540

(2)

Session 10.3 Quick Check

542

(1)

Tutorial Summary

543

(1)

Key Terms

543

(1)

Review Assignments

543

(2)

Case Problems

545

(6)

Internet Assignments

551

(1)

SAM Assessment and Training

551

(1)

Quick Check Answers

551

(2)

Using and Writing Visual Basic for Applications Code

553

(46)

Creating VBA Code for the Overseas Database User Interface

553

(1)

Session 11.1

554

(1)

Introduction to Visual Basic for Applications

554

(4)

Events

554

(2)

Procedures

556

(1)

Modules

556

(2)

Using Help and the Sample Northwind Database

558

(1)

Using an Existing Procedure

558

(6)

Displaying an Event Procedure

559

(3)

Modifying an Event Procedure

562

(2)

Creating Functions in a Standard Module

564

(4)

Creating a Function

565

(2)

Saving a Module

567

(1)

Testing a Procedure in the Immediate Window

568

(1)

Session 11.1 Quick Check

569

(1)

Session 11.2

570

(1)

Creating an Event Procedure

570

(5)

Designing an Event Procedure

571

(1)

Adding an Event Procedure

572

(2)

Compiling Modules

574

(1)

Testing an Event Procedure

574

(1)

Adding a Second Procedure to a Class Module

575

(6)

Designing the Field Validation Procedure

575

(3)

Adding a Second Event Procedure

578

(3)

Session 11.2 Quick Check

581

(1)

Session 11.3

581

(1)

Changing the Case of a Field Value

581

(2)

Hiding and Changing Display Color

583

(3)

Creating the Procedures for the QueriesDialogBox Form

586

(5)

Coding the Load Event Procedure for the QueriesDialogBox Form

586

(2)

Coding the PreviewQuery and DisplayQuery Procedures for the QuereisDialogBox Form

588

(3)

Session 11.3 Quick Check

591

(1)

Tutorial Summary

591

(1)

Key Terms

591

(1)

Review Assignments

592

(1)

Case Problems

593

(4)

Internet Assignments

597

(1)

SAM Assessment and Training

597

(1)

Quick Check Answers

598

(1)

Managing and Securing a Database

599

Managing and Securing the Overseas Database

599

(1)

Session 12.1

600

(1)

Analyzing Database Performance with the Performance Analyzer

600

(3)

Linking Tables and Using the Linked Table Manager

603

(4)

Creating a Replica of a Database

607

(3)

Synchronizing the Replica and the Design Master

610

(3)

Session 12.1 Quick Check

613

(1)

Session 12.2

613

(1)

Using the Database Splitter

613

(4)

Setting the Database Startup Options

617

(2)

Securing an Access Database

619

(5)

Encrypting a Database

620

(1)

Setting and Unsetting a Database Password

621

(3)

Establishing User-Level Security

624

(8)

Using the User-Level Security Wizard

625

(6)

Testing User-Level Security

631

(1)

Saving a database as an MDE File

632

(1)

Session 12.2 Quick Check

632

(1)

Tutorial Summary

633

(1)

Key Terms

633

(1)

Review Assignments

633

(1)

Case Problems

634

(4)

Internet Assignments

638

(1)

SAM Assessment and Training

638

(1)

Quick Check Answers

638

Additional Case 1 Enhancing an Investment Club Database

(6)

Additional Case 2 Tracking Parking Permits and Violations

(6)

Additional Case 3 Internship Program for Pontiac College

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

RENT TEXTBOOKS

New Perspectives on Microsoft Office Access 2003: Comprehensive

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products