Ship-Ship-Hooray! Free Shipping on $25+ Details >
Access 2000 Guidebook / With CD-ROM

Access 2000 Guidebook / With CD-ROM - 3rd edition

Access 2000 Guidebook / With CD-ROM - 3rd edition

ISBN13: 9781576760437

ISBN10: 157676043X

Access 2000 Guidebook / With CD-ROM by Maggie Trigg and Phyllis Dobson - ISBN 9781576760437
Edition: 3RD 00
Copyright: 2000
Publisher: Scott/Jones Publisher, Inc.
International: No
Access 2000 Guidebook / With CD-ROM by Maggie Trigg and Phyllis Dobson - ISBN 9781576760437

ISBN13: 9781576760437

ISBN10: 157676043X

Edition: 3RD 00

Other Editions of Access 2000 Guidebook / With CD-ROM

shop us with confidence


Each chapter concludes with a Summary and Review Exercises that test comprehension of concepts as well as mechanics.

What we've changed:

Chapter 7: Database Design and Maintenance (All new)
Chapter 11: Macros (more)
Chapter 12: Building a Database Application (more)
Chapter 14: Connecting with Access (Coverage of new internet features of Access 2000)
Chapter 15: Introduction to Visual Basic Modules (more)
Completely updated instructor materials -- visit the website for more information

Pedogogical Changes:

''TRY IT YOURSELF'' exercises have been renumbered for better coordination with text to make it easier to locate answers and discuss exercises in class.
''Dialog Balloon Side Bars'' have been added containing cautionary material which used to be contained in the text.
Hints have been added to challenging exercises and projects.
FAST TRACK index on the inside covers has been changed to make it easier to find items.
More examples have been added

Table of Contents

Table of Contents

Chapter 1: What is a Database?

1.1 Introducing Data
1.2 Introducing other Database Objects
1.3 Starting Access 2000
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

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

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

Chapter 4: Queries

4.1 Defining a Query
4.2 Creating Simple Select Queries
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

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

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

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

Chapter 8: Advanced Queries

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 and SQL
Fast Track

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

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

Chapter 11: Macros

11.1 Introducing Events and Macros
11.2 Creating a Macro
11.3 Enhancing a Macro
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

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

Chapter 13: Using Access with Other Applications

13.1 Sharing Data Amongst 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

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 an Existing Web Page
14.7 Saving Single Objects in HTML Format
14.8 Working with Hyperlinks
14.9 Linking to Other Access Objects with Hyperlinks
14.10 Linking to Other Office Documents with Hyperlinks
14.11 Importing HTML Tables and Lists
Fast Track

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 Getting Assistance: Help and Debugging
Fast Track

Chapter 16: Projects

16.1 Introducing Mrs. Sugarbaker's Cookies
16.2 Planning the Database
16.3 Creating the Tables
16.4 Controlling Data Entry
16.5 Defining Relationships
16.6 Making Data Entry Forms
16.7 Using Joined Tables and Queries in Forms
16.8 Adding Command Buttons, Tabs, Macros, and Modules to Forms
16.9 Printing Reports
16.10 Creating a Web Site
16.11 Creating a Startup Switchboard Form
16.12 Expanding the Database: Challenge Projects

Appendix A: Windows 98 Essentials
Appendix B: Answers to Selected Exercises
Appendix C: Access Functions


Other Editions of Access 2000 Guidebook / With CD-ROM

Access 2002 Guidebook for Office XP / With CD-ROM by Maggie Trigg and Phyllis Dobson - ISBN 9781576760918