Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones

Home | Textbook Catalog | Order Book | Syllabi

Coming June 15th  
The
2003 Access Guidebook 5th edition
by Maggie Trigg
Virtually Anything and IT-Dynamics
and Phyllis Dobson, CCCOnline
  
all page proofs (password protected)

Sample Table of Contents

Chapters 1-5 page proofs

The Access 2003 Guidebook 
provides the most up-to-date 
coverage of Access 2003

  *Smart tags that allow actions from other software programs to be attached to Access objects and controls.
  *Data object dependency screens that show the data sources for database objects such as forms and reports, also which objects rely on data from a specific table or query.
   *A comprehensive yet understandable coverage of Access operations and relational database fundamentals.
   *95% new screen shots showing updated windows, menus, and operations.


  Instructor Materials
PowerPoint slides; test bank; solutions to all activities, case studies, and exercises; chapter outlines; Web exercises; and informational Web pages. An additional CD is available that contains material formatted for posting to a WebCT online Access course.

 

THE ACCESS GUIDEBOOK,3rd & 4th editions
by Maggie Trigg
Virtually Anything and IT-Dynamics
and Phyllis Dobson
CCCOnline
 

 

Save 12% over most
bookstore prices by ordering
directly from Scott/Jones!

 

Textbook Web Site

Tables of Contents

The Access 2002 Guidebook for Office XP, 4th Edition

Chapter 1—What Is a Database?
1.1
Introducing Data
1.2 Introducing Other Database Objects
1.3 Starting Access 2002
1.4 Recognizing Screen Layout
1.5 Touring Access
1.6 Using the Office Assistant and Access Help
1.7 Ending Access
1.8 Defining a Relational Database
1.9 Designing a Database
Fast Track
Exercises
Case Studies


Chapter 2—Creating a Database
2.1
Introducing Database Files
2.2 Creating Database Files
2.3 Creating a Table
2.4 Setting Field Properties
2.5 Printing the Table Design
2.6 Modifying Table Design
2.7 Using the Datasheet view
2.8 Printing Records
2.9 Closing the Database File and Exiting Access
Fast Track
Exercises
Case Studies


Chapter 3—Using a Table
3.1
Performing Basic Data Maintenance
3.2 Maintaining Data Integrity
3.3 Importing and Linking Data
3.4 Creating Information from Data
3.5 Restructuring Table Design
3.6 Performing Table Housekeeping Operations
3.7 Setting and Removing Simple Relationships
Fast Track
Exercises
Case Studies


Chapter 4—Queries
4.1
Defining a Query
4.2 Creating a Simple Select Query
4.3 Working with Criteria
4.4 Creating Total Queries
4.5 Utilizing Other Query Features
4.6 Creating Queries with Multiple Tables
Fast Track
Exercises
Case Studies


Chapter 5—Forms
5.1
Defining a Form
5.2 Creating a Form Using the Form Wizard
5.3 Working with a Form
5.4 Creating a Form Using AutoForm
5.5 Using Multiple Tables in Forms
5.6 Using a Form for Editing Data
Fast Track
Exercises
Case Studies


Chapter 6—Reports and Labels
6.1
Defining a Report
6.2 Creating a Report Using the report Wizard
6.3 Working with a Report
6.4 Creating a Report Using AutoReport
6.5 Producing Specialty Reports
Fast Track
Exercises
Case Studies


Chapter 7—Database Design and Maintenance
7.1
Designing a Relational Database
7.2 Normalizing Tables
7.3 Using Advanced Field Properties
7.4 Maintaining Referential Integrity
7.5 Maintaining Databases
7.6 Modifying the Access Environment
Fast Track
Exercises
Case Studies


Chapter 8—Advanced Queries and SQL
8.1
Building Parameter Queries
8.2 Creating Action Queries
8.3 Summarizing Data with Crosstab Queries
8.4 Using Expressions in Queries
8.5 Viewing Property Sheets
8.6 Defining SQL
8.7 Retrieving Data with the Select Statement
8.8 Performing Action Queries with SQL
8.9 Using Data Definition Queries
Fast Track
Exercises
Case Studies


Chapter 9—Custom Forms
9.1
Planning, Designing, and Starting a Form
9.2 Working with Unbound Controls
9.3 Working with Bound Controls
9.4 Changing Control and Form Attributes
9.5 Adding Special Controls
9.6 Adding Finishing Touches
9.7 Creating Complex Forms
9.8 Saving a Form as a Report
Fast Track
Exercises
Case Studies


Chapter 10—Custom Reports
10.1
Getting Started with a Custom Report
10.2 Viewing the Report Design
10.3 Working with Report Fields
10.4 Adding Other Report Controls
10.5 Using a Report
10.6 Creating a Report with a Subreport
Fast Track
Exercises
Case Studies


Chapter 11—Macros
11.1
Introducing Events and Macros
11.2 Creating a Macro
11.3 Enhancing Macros
11.4 Running and Debugging Macros
11.5 Creating Conditional Macros
11.6 Using Special Macros
11.7 Running Macros from Command Buttons
11.8 A Sample Application: Automating Forms with Macros
Fast Track
Exercises
Case Studies


Chapter 12—Building a Database Application
12.1
Developing an Application
12.2 Developing an Interface
12.3 Creating and Using Switchboards
12.4 Developing an Interface without a Switchboard 12.5 Creating a Custom Menu Bar
12.5 Creating a Custom Menu Bar
12.6 Creating a Custom Toolbar
12.7 Creating a Custom Shortcut Menu
12.8 Controlling Startup Functions
Fast Track
Exercises
Case Studies


Chapter 13—Using Access with Other Applications
13.1
Sharing Data Among Application
13.2 Integrating Access and Word
13.3 Integrating Access and Excel
13.4 Working with OLE Objects
13.5 Importing and Exporting Data and Objects
Fast Track
Exercises
Case Studies


Chapter 14—Connecting with Access
14.1
Introducing Data Access Pages
14.2 Using the Data Access Page
14.3 Creating a Data Access Page for Editing Data
14.4 Editing the Data Access Page
14.5 Adding Data Analysis Objects to a Page
14.6 Creating a Data Access Page from Existing Objects
14.7 Working with Hyperlinks
14.8 Importing HTML Tables and Lists
Fast Track
Exercises
Case Studies


Chapter 15—Introduction to Visual Basic Modules
15.1
Introducing Modules and Procedures
15.2 Looking at Event Procedures
15.3 Introducing the Visual Basic Editor
15.4 Writing an Event Procedure
15.5 Introducing Control Structures
15.6 Using Other Tools: Variables, Functions, and Recordsets
15.7 Using Queries in Procedures
15.8 Getting Assistance: Help and Debugging
Fast Track
Exercises
Case Studies


Appendix A—Windows XP Essentials
Appendix B—Answers to Selected Exercises
Appendix C—Access Functions
Appendix D—MOUS Competencies
Appendix E—Glossary
Index

Coming June 15th
The Access 2003 Guidebook for Office XP 
5th edition

Chapter 1 What Is a Database?
1.1 Introducing Data
1.2 Introducing Other Database Objects
1.3 Starting Access
1.4 Recognizing Screen Layout
1.5 Touring Access
1.6 Using the Office Assistant and Access Help

1.7 Ending Access
1.8 Defining a Relational Database
1.9 Designing a Database
Fast Track
Exercises

Chapter 2 Creating a Database
2.1 Introducing Database Files
2.2 Creating Database Files
2.3 Creating a Table
2.4 Setting Field Properties
2.5 Printing the Table Design
2.6 Modifying Table Design
2.7 Using the Datasheet view
2.8 Printing Records
2.9 Closing the Database File and Exiting Access
Fast Track
Exercises

Chapter 3 Using a Table
3.1 Performing Basic Data Maintenance
3.2 Maintaining Data Integrity
3.3 Importing and Linking Data
3.4 Creating Information from Data
3.5 Restructuring Table Design
3.6 Performing Table Housekeeping Operations
3.7 Setting and Removing Simple Relationships
Fast Track
Exercise

Chapter 4 Queries
4.1 Defining a Query
4.2 Creating a Simple Select Query
4.3 Working with Criteria
4.4 Creating Total Queries
4.5 Utilizing Other Query Features
4.6 Creating Queries with Multiple Tables
Fast Track
Exercises

Chapter 5 Forms
5.1 Defining a Form
5.2 Creating a Form Using the Form Wizard
5.3 Working with a Form
5.4 Creating a Form Using AutoForm
5.5 Using Multiple Tables in Forms
5.6 Using a Form for Editing Data
Fast Track
Exercises

Chapter 6 Reports and Labels
6.1 Defining a Report
6.2 Creating a Report Using the Report Wizard
6.3 Working with a Report
6.4 Creating a Report Using AutoReport
6.5 Producing Specialty Reports
Fast Track
Exercises

Chapter 7 Database Design and Maintenance
7.1 Designing a Relational Database
7.2 Normalizing Tables
7.3 Using Advanced Field Properties
7.4 Maintaining Referential Integrity
7.5 Maintaining Databases
7.6 Modifying the Access Environment
Fast Track
Exercises

Chapter 8 Advanced Queries and SQL
8.1 Building Parameter Queries
8.2 Creating Action Queries
8.3 Summarizing Data with Crosstab Queries
8.4 Using Expressions in Queries
8.5 Viewing Property Sheets
8.6 Defining SQL
8.7 Retrieving Data with the Select Statement
Fast Track
Exercises

Chapter 9 Custom Forms
9.1 Planning, Designing, and Starting a Form
9.2 Working with Unbound Controls
9.3 Working with Bound Controls
9.4 Changing Control and Form Attributes
9.5 Adding Special Controls
9.6 Adding Finishing Touches
9.7 Creating Complex Forms
9.8 Saving a Form as a Report
Fast Track
Exercises

Chapter 10 Custom Reports
10.1 Getting Started with a Custom Report
10.2 Viewing the Report Design
10.3 Working with Report Fields
10.4 Adding Other Report Controls
10.5 Using a Re port
10.6 Creating a Report with a SubReport
Fast Track
Exercises

Chapter 11 Macros
11.1 Introducing Events and Macros
11.2 Creating a Macro
11.3 Enhancing Macros
11.4 Running and Debugging Macros
11.5 Creating Conditional Macros
11.6 Using Special Macros
11.7 Running Macros from Command Buttons
11.8 A Sample Application: Automating Forms with Macros
Exercises

Chapter 12 Building a Database Application
12.1 Developing an Application
12.2 Developing an Interface 
12.3 Creating and Using Switchboards 
12.4 Developing an Interface without a Switchboard
12.5 Creating a Custom Menu Bar 
12.6 Creating a Custom Toolbar 
12.7 Creating a Custom Shortcut Menu
12.8 Controlling Startup Functions 

Fast Track
Exercises

Chapter 13 Using Access with Other Applications
13.1 Sharing Data Among Applications
13.2 Integrating Access and Word
13.3 Integrating Access and Excel
13.4 Working with OLE Objects
13.5 Importing and Exporting Data and Objects
Fast Track
Exercises

Chapter 14 Connecting with Access
14.1 Introducing Data Access Pages
14.2 Using the Data Access Page
14.3 Creating a Data Access Page for Editing Data
14.4 Editing the Data Access Page
14.5 Adding Data Analysis Objects to a Page
14.6 Creating a Data Access Page from Existing Objects
14.7 Working with Hyperlinks
14.8 Importing HTML Tables and Lists 

Fast Track
Exercises

Appendix A Answers to Selected Exercises 
Appendix B Access Functions
Appendix C Glossary
Index


The Access 2002 Guidebook for Office XP, 5th Edition
ISBN 1-57676-141-X


The Access 2000 Guidebook, 3rd Edition
ISBN 1-57676-043-X (650 pages)


Home | Textbook Catalog | Order Book | Syllabi
 

Scott/Jones Inc., El Granada CA
Website maintenance & updating by
Jane Scott/Jones.
Updated
May 11, 2004