CourseSmart - 9781423905882 - New Perspectives on Microsoft Office Access 2007, Introductory, 1st Edition

Create Account | Sign In | Cart

Cart (0) | Help

Tell a Friend! Share on Facebook

Share on Twitter

New Perspectives on Microsoft Office Access 2007, Introductory, 1st Edition

READ SAMPLE CHAPTERS

Getting Started with Microsoft Office 2007: Preparing a Meeting Agenda

Study Smarter

Get instant access anytime, anywhere, from any computer
Take notes within your eTextbook
Search your book & take notes
Highlight relevant sections
eTextbooks cost up to 50% less!

New Perspectives on Microsoft Office Access 2007, Introductory, 1st Edition

by Adamski; Finnegan

Publisher: South-Western, Cengage Learning

Publishing Date: 2007/08/14

Print ISBN-10: 1-4239-0588-1

Print ISBN-13: 978-1-4239-0588-2

eText ISBN-10: 0-324-79351-0

eText ISBN-13: 978-0-324-79351-2

Course: Microsoft Suite

Pages: 536

eTextbook $38.99

(180 day subscription)

Compare Online & Downloadable

Table of Contents | Description

Instructor Resources | Student Resources

ABOUT THIS TITLE - TABLE OF CONTENTS

Preface, v

Getting Started with Microsoft Office 2007: Preparing a Meeting Agenda, OFF1

Exploring Microsoft Office 2007, OFF2

Integrating Office Programs, OFF3

Starting Office Programs, OFF3

Switching Between Open Programs and Files, OFF5

Exploring Common Window Elements, OFF6

Resizing the Program Window and Workspace, OFF6

Getting Information from the Status Bar, OFF7

Switching Views, OFF8

Zooming the Workspace, OFF8

Using the Ribbon, OFF10

Clicking Button Icons, OFF10

Using Galleries and Live Preview, OFF12

Opening Dialog Boxes and Task Panes, OFF13

Using Contextual Tools, OFF15

Displaying Contextual Tabs, OFF15

Accessing the Mini Toolbar, OFF15

Opening Shortcut Menus, OFF17

Working with Files, OFF18

Saving a File, OFF18

Closing a File, OFF21

Opening a File, OFF21

Getting Help, OFF23

Viewing ScreenTips, OFF23

Using the Help Window, OFF23

Printing a File, OFF27

Exiting Programs, OFF28

Quick Check, OFF29

Tutorial Summary, OFF29

Key Terms, OFF29

Review Assignments, OFF30

SAM Assessment and Training, OFF31

Quick Check Answers, OFF31

Reality Check, OFF32

Access Level I Tutorials, AC1

Tutorial 1. Creating a Database: Creating a Database to Contain Customer, Contract, and Invoice Data, AC1

Session 1.1, AC2

Introduction to Database Concepts, AC2

Creating a Database, AC5

Creating a Table in Datasheet View, AC8

Session 1.1 Quick Check, AC19

Session 1.2, AC19

Copying Records from Another Access Database, AC19

Navigating a Datasheet, AC22

Creating a Simple Query, AC23

Creating a Simple Form, AC27

Creating a Simple Report, AC29

Viewing Objects in the Navigation Pane, AC32

Managing a Database, AC33

Session 1.2 Quick Check, AC36

Tutorial Summary, AC36

Key Terms, AC36

Review Assignments, AC37

Case Problems, AC38

Internet Assignments, AC43

SAM Assessment and Training, AC43

Quick Check Answers, AC43

Tutorial 2. Building a Database and Defining Table Relationships: Creating the Invoice and Customer Tables, AC45

Session 2.1, AC46

Guidelines for Designing Databases, AC46

Guidelines for Setting Field Properties, AC48

Viewing and Modifying Field Data Types and Formatting, AC50

Creating a Table in Design View, AC54

Modifying the Structure of an Access Table, AC62

Session 2.1 Quick Check, AC66

Session 2.2, AC66

Adding Records to a New Table, AC66

Importing Data from an Excel Worksheet, AC68

Creating a Table by Importing an Existing Table Structure, AC71

Adding Data to a Table by Importing a Text File, AC79

Defining Table Relationships, AC81

Session 2.2 Quick Check, AC87

Tutorial Summary, AC87

Key Terms, AC87

Review Assignments, AC88

Case Problems, AC89

Internet Assignments, AC97

SAM Assessment and Training, AC98

Quick Check Answers, AC98

Tutorial 3. Maintaining and Querying a Database: Updating and Retrieving Information About Customers, Contracts, and Invoices, AC99

Session 3.1, AC100

Updating a Database, AC100

Introduction to Queries, AC104

Query Window, AC105

Creating and Running a Query, AC107

Updating Data Using a Query, AC109

Creating a Multitable Query, AC110

Sorting Data in a Query, AC112

Filtering Data, AC116

Session 3.1 Quick Check, AC118

Session 3.2, AC119

Defining Record Selection Criteria for Queries, AC119

Defining Multiple Selection Criteria for Queries, AC128

Creating a Calculated Field, AC133

Using Aggregate Functions, AC137

Working with the Navigation Pane, AC142

Session 3.2 Quick Check, AC144

Tutorial Summary, AC144

Key Terms, AC144

Review Assignments, AC145

Case Problems, AC146

Internet Assignments, AC151

SAM Assessment and Training, AC151

Quick Check Answers, AC152

Tutorial 4. Creating Forms and Reports: Creating a Customer Data Form, a Customer Contracts Form, and a Customers and Contracts Report, AC153

Session 4.1, AC154

Creating a Form Using the Form Wizard, AC154

Modifying a Form's Design in Layout View, AC157

Navigating a Form, AC165

Finding Data Using a Form, AC165

Maintaining Table Data Using a Form, AC168

Previewing and Printing Selected Form Records, AC170

Session 4.1 Quick Check, AC172

Session 4.2, AC172

Creating a Form with a Main Form and a Subform, AC172

Creating a Report Using the Report Wizard, AC176

Modifying a Report's Design in Layout View, AC181

Using Conditional Formatting in a Report, AC185

Session 4.2 Quick Check, AC189

Tutorial Summary, AC189

Key Terms, AC189

Review Assignments, AC190

Case Problems, AC191

Internet Assignments, AC197

SAM Assessment and Training, AC197

Quick Check Answers, AC198

Reality Check, AC199

Access Level II Tutorials, AC201

Tutorial 5. Creating Advanced Queries and Enhancing Table Design: Making the Panorama Database Easier to Use, AC201

Session 5.1, AC202

Reviewing the Panorama Database, AC202

Using a Pattern Match in a Query, AC204

Using a List-of-Values Match in a Query, AC207

Using the Not Operator in a Query, AC208

Using an AutoFilter to Filter Data, AC209

Assigning a Conditional Value to a Calculated Field, AC211

Creating a Parameter Query, AC215

Session 5.1 Quick Check, AC219

Session 5.2, AC219

Creating a Crosstab Query, AC219

Creating a Find Duplicates Query, AC226

Creating a Find Unmatched Query, AC227

Creating a Top Values Query, AC229

Session 5.2 Quick Check, AC231

Session 5.3, AC231

Creating a Lookup Field, AC231

Using the Input Mask Wizard, AC235

Identifying Object Dependencies, AC239

Defining Data Validation Rules, AC241

Working with Memo Fields, AC244

Designating a Trusted Folder, AC246

Session 5.3 Quick Check, AC248

Tutorial Summary, AC249

Key Terms, AC249

Review Assignments, AC250

Case Problems, AC251

Internet Assignments, AC260

SAM Assessment and Training, AC261

Quick Check Answers, AC261

Tutorial 6. Using Form Tools and Creating Custom Forms: Creating Forms for Belmont Landscapes, AC263

Session 6.1, AC264

Designing Forms, AC264

Printing Database Relationships and Using the Documenter, AC267

Creating Forms Using Form Tools, AC269

Session 6.1 Quick Check, AC280

Session 6.2, AC280

Planning and Designing a Custom Form, AC280

Creating a Custom Form in Design View, AC281

Selecting, Moving, and Aligning Controls, AC285

Resizing and Deleting Controls, AC288

Adding a Combo Box to a Form, AC291

Using Form Headers and Form Footers, AC296

Session 6.2 Quick Check, AC298

Session 6.3, AC299

Adding a Combo Box to Find Records, AC299

Adding a Subform to a Form, AC302

Displaying a Subform's Calculated Controls in the Main Form, AC306

Changing the Tab Order in a Form, AC313

Improving a Form's Appearance, AC315

Session 6.3 Quick Check, AC320

Tutorial Summary, AC321

Key Terms, AC321

Review Assignments, AC322

Case Problems, AC324

Internet Assignments, AC331

SAM Assessment and Training, AC331

Quick Check Answers, AC331

Tutorial 7. Creating Custom Reports: Creating Reports with Information About Contracts and Invoices, AC333

Session 7.1, AC334

Customizing Existing Reports, AC334

Session 7.1 Quick Check, AC349

Session 7.2, AC349

Designing a Custom Report, AC349

Creating a Query for a Custom Report, AC351

Creating a Custom Report, AC352

Sorting and Grouping Data in a Report, AC355

Working with Controls in Design View, AC359

Adding Lines to a Report, AC362

Hiding Duplicate Values in a Report, AC363

Session 7.2 Quick Check, AC365

Session 7.3, AC365

Adding the Date to a Report, AC365

Adding Page Numbers to a Report, AC368

Adding a Title to a Report, AC370

Creating Mailing Labels, AC373

Session 7.3 Quick Check, AC377

Tutorial Summary, AC377

Key Terms, AC377

Review Assignments, AC378

Case Problems, AC379

Internet Assignments, AC386

SAM Assessment and Training, AC386

Quick Check Answers, AC387

Tutorial 8. Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Panorama Database, AC389

Session 8.1, AC390

Using the Web, AC390

Exporting an Access Query to an HTML Document, AC390

Viewing an HTML Document Using Internet Explorer, AC393

Importing a CSV File as an Access Table, AC395

Using XML, AC400

Session 8.1 Quick Check, AC408

Session 8.2, AC409

Creating a Multi-page Form Using a Tab Control, AC409

Integrating Access with Other Programs, AC413

Embedding a Chart in a Form, AC414

Creating and Using a PivotTable, AC420

Creating a PivotChart, AC426

Linking Data from an Excel Worksheet, AC429

Session 8.2 Quick Check, AC432

Tutorial Summary, AC432

Key Terms, AC432

Review Assignments, AC433

Case Problems, AC434

Internet Assignments, AC438

SAM Assessment and Training, AC438

Quick Check Answers, AC438

Reality Check, AC440

Appendix: A Relational Databases and Database Design, ACA1

Tables, ACA2

Keys, ACA3

Relationships, ACA5

One-to-Many Relationships, ACA5

Many-to-Many Relationship, ACA6

One-to-One Relationship, ACA7

Entity Subtype, ACA8

Entity-Relationship Diagrams, ACA10

Intrgrity Constraints, ACA11

Dependencies and Determinants, ACA12

Anomalies, ACA14

Normalization, ACA15

First Normal Form, ACA15

Second Normal Form, ACA16

Third Normal Form, ACA18

Natural, Artificial, and Surrogate Keys, ACA19

Microsoft Access Naming Conventions, ACA23

Appendix Summary, ACA27

Key Terms, ACA27

Review Assignments, ACA28

Glossary/Index, REF1

Task Reference, REF12

STUDY TOOLS		PRICE	ACTION

OTHER FORMATS		PRICE	ACTION

NEW TO THIS EDITION

RELATED eTEXTBOOKS - eTEXTBOOKS		PRICE	ACTION

RELATED eTEXTBOOKS - YOU MIGHT ALSO BE INTERESTED IN		PRICE	ACTION

ABOUT THIS TITLE - DESCRIPTION

In the New Perspective Series, this title takes a case-based, problem-solving approach to teaching Microsoft Access 2007 skills.

ABOUT THIS TITLE - PREVIOUS EDITIONS		PRICE	ACTION

INSTRUCTOR RESOURCES		ACTION

CourseSmart for Instructors | CourseSmart for Students | Redemption Code

901 Mariners Island Blvd, Suite 545, San Mateo, CA 94404

Please use the Print button in the CourseSmart Reader header.