EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals.
EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals.
EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals
Search
Access 2000 Guidebook / With CD-ROM

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

ISBN13: 978-1576760437

Cover of Access 2000 Guidebook / With CD-ROM 3RD 00 (ISBN 978-1576760437)
ISBN13: 978-1576760437
ISBN10: 157676043X
Cover type:
Edition/Copyright: 3RD 00
Publisher: Scott/Jones Publisher, Inc.
Published: 2000
International: No

USED
Sold Out
FREE Shipping on $25+
  • Ships tomorrow
  • 30-Day Returns
  • Condition: Very Good
Sold Out
More Shipping Options

Access 2000 Guidebook / With CD-ROM - 3RD 00 edition

ISBN13: 978-1576760437

Maggie Trigg and Phyllis Dobson

ISBN13: 978-1576760437
ISBN10: 157676043X
Cover type:
Edition/Copyright: 3RD 00
Publisher: Scott/Jones Publisher, Inc.

Published: 2000
International: No
Summary

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

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


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

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
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 Report
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 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
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 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
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 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
Exercises


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
Exercises


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

Index

List price: $0.00
  • Marketplace
  • From
More Shipping Options