Access 2000 Essentials Intermediate / Edition 1

Other Format (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 90%)
Other sellers (Other Format)
  • All (14) from $1.99   
  • New (3) from $15.0   
  • Used (11) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$15.00
Southern Maryland Books
Seller since Tue Aug 05 05:02:48 EDT 2014

Feedback rating:

(26)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
1999 Spiral-bound New ** WE SHIP DAILY (Mon-Fri) ** Free Tracking Information.

Ships from: Waldorf, MD

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$119.50
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$125.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

More About This Textbook

Overview

The Essentials series is conceived as a "learning system" that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps. For anyone interested in learning Microsoft Office 2000.
Read More Show Less

Product Details

  • ISBN-13: 9781580763011
  • Publisher: Pearson
  • Publication date: 8/17/1999
  • Series: Essentials Series
  • Format: Spiral Bound
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 256
  • Product dimensions: 8.63 (w) x 10.82 (h) x 0.45 (d)

Table of Contents

Introduction xi
Project 1 Making Data Entry Easier and More Accurate 1
Lesson 1 Creating Consistent Data Formats 2
Lesson 2 Creating Conditional Formats for Positive, Negative, and Null Values 5
Lesson 3 Changing the Data Input Structure Using Input Masks 7
Lesson 4 Restricting Entries to Those That Meet Validation Criteria 11
Lesson 5 Requiring Entry of Necessary Information 14
Lesson 6 Preventing Duplicate Entries Using Indexed Fields 15
Lesson 7 Creating a Lookup Column to Allow Selection from a List 17
Summary 21
Checking Concepts and Terms 21
True/False 21
Multiple Choice 22
Screen ID 23
Discussion Questions 24
Skill Drill 24
1. Creating a Consistent Data Format 24
2. Adding an Input Mask to a Text Field 24
3. Adding Validation Rules 25
4. Preventing Duplicate Entries Using the Index Property 25
5. Adding a Lookup Column 25
6. Requiring a Field Entry 26
Challenge 26
1. Placing Default Text in Empty Fields Using Custom Formats 26
2. Creating a Two-Column Lookup Column 27
3. Using Validation Rules to Set a Minimum Value for a Field 27
4. Using Conditional Formats to Emphasize Negative Numbers 28
5. Indexing Multiple Fields 28
Discovery Zone 28
1. Creating Your Own Input Mask 28
2. Creating Your Own Custom Date Format 29
Project 2 Managing Data Using Smaller, Related Tables 31
Lesson 1 Designing Related Tables to Hold Repetitive Data 32
Lesson 2 Defining the Relationship Between the Tables 34
Lesson 3 Creating Queries That Draw Data from Both Tables 39
Lesson 4 Automatically Filling In Data from One of the Joined Tables 44
Lesson 5 Updating Tables by Entering or Deleting Data in the Query 47
Lesson 6 Finding Duplicate Records in an Existing Table 49
Summary 53
Checking Concepts and Terms 53
True/False 53
Multiple Choice 54
Screen ID 55
Discussion Questions 55
Skill Drill 56
1. Enforcing Referential Integrity in Your Library Database 56
2. Finding an Unmatched Record 56
3. Viewing Related Information Using a Subdatasheet 57
4. Creating a Query Based on Two Tables 57
5. Enforcing Referential Integrity for the Sound Byte Music Company 57
6. Creating a Query Based on Two Tables in the Sound Byte Music Company 58
Challenge 59
1. Adding a Table, Relating to the Table, and Creating a Query Based on Both Tables 59
2. Changing a Data Type Using the Lookup Wizard 59
3. Establishing Referential Integrity Among Tables 60
4. Enforcing Referential Integrity and Creating One-to-Many Relationships Among Tables 60
5. Revising Tables and Relationships in a Database 61
Discovery Zone 61
1. Improving an Existing Database 61
2. Adding Information Using Subdatasheets 62
Project 3 Adding Useful Features to Your Forms 63
Lesson 1 Adding Formats in the Form Design View 65
Lesson 2 Selecting Entries from a List 69
Lesson 3 Looking Up Valid Entries from a Table or Query 73
Lesson 4 Using Information from a Query to Fill In Fields Automatically 75
Lesson 5 Entering the Current Date in a Field Automatically 78
Lesson 6 Adding the Current Date and Time to a Form Automatically 80
Lesson 7 Changing the Tab Order 82
Lesson 8 Creating Subforms 84
Lesson 9 Printing the Form for Filing Purposes 88
Summary 92
Checking Concepts and Terms 93
True/False 93
Multiple Choice 93
Screen ID 94
Discussion Questions 95
Skill Drill 95
1. Adding a List Box to a Form 96
2. Adding a Combo Box to a Form 96
3. Changing the Tab Order 97
4. Adding the Date and Time to a Form Footer 97
5. Creating a Form and Subform 97
6. Printing a Copy of a Form 98
Challenge 98
1. Adding Page Numbers to the Page Footer 98
2. Adding a Hyperlink to the Form Footer 99
3. Changing the Look of the Form 99
4. Drawing Data from Three Tables 99
5. Linking Tables in a Form 100
Discovery Zone 100
1. Using Tab Control to Create Form Pages 100
2. Adding an Image to a Form 101
Project 4 Special Purpose Reports and Advanced Report Features 103
Lesson 1 Creating Labels for Mailings 105
Lesson 2 Creating Calculated Fields in a Report 110
Lesson 3 Grouping and Sorting Data in a Report 116
Lesson 4 Keeping Grouped Data Together in Reports 121
Lesson 5 Adding Calculated Fields to Group Headers and Footers 123
Summary 125
Checking Concepts and Terms 126
True/False 126
Multiple Choice 126
Screen ID 128
Discussion Questions 129
Skill Drill 129
1. Creating a Mailing Label Report 129
2. Grouping Data in a Report 129
3. Changing the Sort Order in a Report 130
4. Forcing Logical Page Breaks 130
5. Adding Calculated Fields to a Record 131
6. Adding Calculated Fields to a Group Footer 131
Challenge 132
1. Creating File Folder Labels 132
2. Grouping Data Using the Report Wizard 133
3. Using the Average Function 133
4. Creating a Summary-Only Report 134
5. Formatting a Summary-Only Report 134
Discovery Zone 135
1. Grouping on Multiple Fields 135
2. Adding Subtotals and Grand Totals 136
Project 5 Automating Your Database with Macros 137
Lesson 1 Creating a Macro to Open a Form in the Edit Mode 139
Lesson 2 Creating a Macro to Open a Form in the Add Mode 141
Lesson 3 Creating a Macro to Open a Form in the Read Only Mode 142
Lesson 4 Creating a Macro to Open a Report in Preview View 144
Lesson 5 Creating a Macro to Close a Form 144
Lesson 6 Running a Macro from a Button on a Form 145
Lesson 7 Creating Switchboard Forms 148
Lesson 8 Creating a Macro to Automatically Launch the Main Switchboard Form 152
Summary 154
Checking Concepts and Terms 154
True/False 154
Multiple Choice 155
Screen ID 156
Discussion Questions 157
Skill Drill 157
1. Creating Add Macros for Forms 157
2. Creating Read-Only Macros for a Form 158
3. Creating Macros to Open Reports in Print Preview View 158
4. Creating a Close Macro and Attaching it to Forms 158
5. Creating a Switchboard 159
6. Running Your Switchboard Automatically 160
Challenge 160
1. Editing a Macro 160
2. Deleting a Macro and Its Macro Button on the Switchboard 160
3. Creating a Macro to Run a Query 161
4. Dragging an Object into the Query Design Window 161
5. Copying, Pasting, and Editing a Macro 161
Discovery Zone 162
1. Setting Macro Conditions 162
2. Adding a New Option to the Menu 162
Project 6 Managing Your Databases with Special Action Queries and Database Utilities 165
Lesson 1 Making Backup Copies of Your Data 167
Lesson 2 Saving an Access 2000 Database as an Access 97 Database 171
Lesson 3 Compacting and Repairing Files for Efficient Storage 171
Lesson 4 Using Detect and Repair to Fix Access Problems 173
Lesson 5 Generating a Query That Creates an Archive Table 174
Lesson 6 Modifying the Archive Setup Query to Delete Records from a Table 177
Lesson 7 Creating a Query to Append Records to an Archive Table 178
Lesson 8 Creating a Macro to Run Two Queries 180
Summary 182
Checking Concepts and Terms 182
True/False 182
Multiple-Choice Questions 183
Screen ID 184
Discussion Questions 185
Skill Drill 185
1. Creating a Data File from a Table 185
2. Compacting and Repairing Files 185
3. Saving an Access 2000 Database as an Access 97 Database 186
4. Generating a Query That Creates an Archive Table 186
5. Creating a Query to Delete Records from a Table 186
6. Creating an Append Query 187
Challenge 187
1. Exporting Data to Excel 187
2. Creating a Text File from a Query 188
3. Sending a Database Object to Another Database 188
4. Adding a Password to a Database File 188
5. Encrypting a File for Data Security 189
Discovery Zone 189
1. Reading a Text File into an Access Table 189
2. Creating an MDE File to Protect Your Database Objects from Being Changed 190
Project 7 Using Access on the Web and Linking to Other Documents 191
Lesson 1 Adding Hyperlinks from Forms to Word Documents 193
Lesson 2 Adding Hyperlinks from Forms to Excel Worksheets 200
Lesson 3 Saving Database Objects as Static HTML Pages 203
Lesson 4 Viewing HTML Pages on a Local Drive Using a Browser 206
Lesson 5 Editing HTML Pages in WordPad 208
Summary 212
Checking Concepts and Terms 212
True/False 212
Multiple Choice 212
Screen ID 214
Discussion Questions 215
Skill Drill 215
1. Linking an Access Form to a Word Document 215
2. Saving a Table as an HTML Document 216
3. Viewing the Table Using the Default Browser 216
4. Saving a Query as an HTML Document 217
5. Viewing the Query and Navigating Between Pages Using the Default Browser 217
6. Editing an HTML Document 217
Challenge 218
1. Adding a Hyperlink to a PowerPoint Presentation 218
2. Adding a Hyperlink to Connect to a URL 218
3. Creating a One-page HTML Document from a Report 219
4. Editing a Hypertext Document in Access 219
5. Adding New Lines to an HTML Report 220
Discovery Zone 220
1. Creating a Multiple-page HTML Document 220
2. Uploading HTML Files onto a Web Server 220
Task Guide 223
Glossary 229
Index 231
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)