Essentials: Microsoft Access 2003 / Edition 4

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (11) from $1.99   
  • New (2) from $56.63   
  • Used (9) 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
$56.63
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

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
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)
$105.00
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

Overview

Backed with over 20 years of writing, teaching and professional experience with electronic spreadsheets, the authors have perfected the format and presentation of Microsoft applications material to suit every type of learning style. Comprehensive information for users at various levels of experience, hands-on exercises and a flexible binding make this a must-have series for applications essentials.

Areas covered include taking a tour of Access, building a database, manipulating table data, modifying tables and creating relationships, querying a database, customizing input forms, creating custom reports and integrating access with other applications and the Internet.

For training professionals.

Read More Show Less

Product Details

  • ISBN-13: 9780131435759
  • Publisher: Prentice Hall
  • Publication date: 2/24/2004
  • Series: Essentials Series for Office 2003 Series
  • Edition description: New Edition
  • Edition number: 4
  • Pages: 448
  • Product dimensions: 8.46 (w) x 11.00 (h) x 0.58 (d)

Table of Contents

Project 1 Taking a Tour of Access 2003 1
Lesson 1 Opening a Database and Identifying Parts of the Access Window 4
Lesson 2 Using the Database Window 10
Lesson 3 Opening and Navigating Tables 13
Lesson 4 Viewing Forms and Reports 20
Lesson 5 Glimpsing the Power of Queries 25
Lesson 6 Printing Access Data 28
Lesson 7 Getting Help 30
Lesson 8 Compacting and Repairing a Database 36
Lesson 9 Closing a Database and Exiting Access 36
Project 2 Building a Database 49
Lesson 1 Creating a New Blank Database 51
Lesson 2 Creating a Database Table Using Design View 53
Lesson 3 Creating an AutoForm 60
Lesson 4 Adding Records to a Table 62
Lesson 5 Creating an AutoReport 64
Lesson 6 Creating a Table Using the Table Wizard 66
Lesson 7 Creating Tables from Other Sources 70
Lesson 8 Creating a New Database Using a Wizard 73
Project 3 Maintaining a Database 91
Lesson 1 Modifying Table Field Properties 93
Lesson 2 Formatting and Modifying Table Layout 96
Lesson 3 Locating, Deleting, and Editing Records 100
Lesson 4 Using Find and Replace to Update Records 105
Lesson 5 Sorting Records and Setting a Sort Order 108
Lesson 6 Filtering Records by Selection 112
Lesson 7 Filtering Records by Form 115
Lesson 8 Previewing and Printing Table Data 117
Project 4 Modifying Tables and Establishing Relationships 133
Lesson 1 Editing, Adding, and Deleting Table Fields 136
Lesson 2 Assigning Primary Keys 139
Lesson 3 Formatting Data Using Input Masks 141
Lesson 4 Setting Validation Rules 147
Lesson 5 Setting Default Values 151
Lesson 6 Adding Lookup Fields to Tables 152
Lesson 7 Creating and Modifying Relationships 156
Lesson 8 Analyzing a Database and Printing Relationships 161
Project 5 Querying a Database 177
Lesson 1 Creating, Saving, and Running Select Queries 180
Lesson 2 Designing a Query Using Multiple Tables 185
Lesson 3 Setting Query Criteria 188
Lesson 4 Defining a Query Sort Order 196
Lesson 5 Creating and Formatting a Calculated Field 199
Lesson 6 Using Functions in Query Expressions 203
Lesson 7 Creating a Crosstab Query 208
Lesson 8 Creating Unmatched and Duplicates Queries 213
Project 6 Customizing Input Forms 227
Lesson 1 Creating Forms Using Wizards 229
Lesson 2 Modifying Form Controls 232
Lesson 3 Adding Unbound Controls to Forms 240
Lesson 4 Formatting Form Sections 246
Lesson 5 Setting Form Properties 249
Lesson 6 Setting a Form Tab Order 251
Lesson 7 Adding a Subform to a Form 253
Lesson 8 Creating a Form with a Subform Using a Wizard 260
Project 7 Creating Custom Reports 277
Lesson 1 Creating a Report Using a Wizard 279
Lesson 2 Modifying Reports 284
Lesson 3 Creating Report Using Report Design View 288
Lesson 4 Adding Report Sorting and Grouping Levels 292
Lesson 5 Adding Graphics to Reports and Applying AutoFormats 294
Lesson 6 Adding a Calculated Control to a Report 297
Lesson 7 Creating Controls to Calculate Totals 301
Project 8 Integrating Access with Other Applications and the Internet 319
Lesson 1 Converting Access 2003 Databases to Other Access Formats 321
Lesson 2 Linking an Excel Worksheet to an Access Database 324
Lesson 3 Merging Access Data with Word Documents 327
Lesson 4 Exporting Access Data to Excel 333
Lesson 5 Creating a Data Access Page 335
Lesson 6 Viewing Access Data on the Web 340
Integrating Projects 353
File Guide 361
Task Guide 367
Glossary 387
Index 391
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)