The Advantage Series: Access 2002-Introductory

Be the first to write a review

Overview

The Advantage Series presents the Feature-Method-Practice approach to computer software applications to today's technology and business students. This series implements an efficient and effective learning model,which enhances critical thinking skills and provides students and faculty with complete application coverage.
Read More Show Less
... See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (6) from $1.99   
  • New (1) from $86.32   
  • Used (5) 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
$86.32
Stork Group
Seller since Sat Jan 01 01:01:01 EST 2011

Feedback rating:

(894)

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 and unread! Join our growing list of satisfied customers!

Ships from: Phoenix, MD

Usually ships in 1-2 business days

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

More About This Book

Overview

The Advantage Series presents the Feature-Method-Practice approach to computer software applications to today's technology and business students. This series implements an efficient and effective learning model,which enhances critical thinking skills and provides students and faculty with complete application coverage.
Read More Show Less

Product Details

  • ISBN-13: 9780072470925
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 10/10/2001
  • Series: Advantage Series
  • Edition description: SPIRAL
  • Edition number: 1
  • Pages: 560
  • Product dimensions: 9.00 (w) x 10.70 (h) x 0.96 (d)

Table of Contents

Chapter 1 Working with Access
Case Study
1.1 Getting Started with Access
1.1.1 Loading and Exiting Access 3
1.1.2 Opening a Database File at Startup 4
1.1.3 Touring Access 7
1.1.4 Working in the Database Window 10
1.2 Viewing and Printing Your Data
1.2.1 Moving Around a Datasheet 14
1.2.2 Adjusting Column Widths and Row Heights 18
1.2.3 Previewing and Printing 20
1.3 Manipulating Table Data
1.3.1 Selecting and Editing Data 23
1.3.2 Using the Undo Command 26
1.3.3 Adding Records 27
1.3.4 Deleting Records 30
Chapter 2 Creating a Database
Case Study
2.1 Designing Your First Database
2.1.1 Planning a Database 50
2.1.2 Starting a New Database 51
2.1.3 Employing the Database Wizard 54
2.2 Creating a Simple Table
2.2.1 Creating a Table Using the Table Wizard 60
2.2.2 Creating a Table in Datasheet View 63
2.3 Using the Table Design View
2.3.1 Creating a Table in Design View 65
2.3.2 Assigning a Primary Key 68
2.3.3 Defining and Removing Indexes 70
2.4 Modifying a Table
2.4.1 Inserting and Deleting Fields 72
2.4.2 Renaming and Moving Fields 75
2.4.3 Printing a Table's Design Structure 77
Chapter 3 Organizing and Retrieving Data
Case Study
3.1 Customizing Datasheet View
3.1.1 Formatting a Datasheet 98
3.1.2 Changing the Field Column Order 101
3.1.3 Hiding and Unhiding Columns 103
3.1.4 Freezing and Unfreezing Columns 106
3.2 Sorting, Finding, and Maintaining Data
3.2.1 Sorting Records in a Datasheet 107
3.2.2 Performing a Simple Search 110
3.2.3 Specifying Search Patterns 111
3.2.4 Performing a Find and Replace 113
3.2.5 Spell-Checking a Datasheet 114
3.3 Using Filters
3.3.1 Filtering for Input 116
3.3.2 Filtering by Selection 118
3.3.3 Filtering by Form 120
3.4 Creating a Simple Query
3.4.1 Creating a Query Using the Query Wizard 124
3.4.2 Displaying the Query Window 127
Chapter 4 Presenting and Managing Data
Case Study
4.1 Creating a Simple Form
4.1.1 Creating a Form Using the AutoForm Wizards 147
4.1.2 Creating a Form Using the Form Wizard 151
4.1.3 Navigating Data Using a Form 155
4.1.4 Working with a Form 158
4.2 Creating a Simple Report
4.2.1 Creating a Report Using the AutoReport Wizards 161
4.2.2 Creating a Report Using the Report Wizard 163
4.2.3 Previewing and Printing a Report 167
4.2.4 Publishing a Static Report to the Web 170
4.3 Generating a Mailing Labels Report
4.3.1 Creating a Report Using the Label Wizard 174
4.4 Managing Database Objects
4.4.1 Renaming, Copying, and Deleting Objects 180
4.4.2 Compacting, Repairing, and Converting a Database 183
Chapter 5 Working with Tables
Case Study
5.1 Building a Relational Database
5.1.1 Defining Table Relationships 213
5.1.2 Working with Related Tables 219
5.1.3 Printing the Relationships Window 223
5.1.4 Setting Object and Database Properties 225
5.2 Customizing Fields
5.2.1 Modifying Field Properties 228
5.2.2 Specifying a Field's Display Format 232
5.2.3 Defining a Hyperlink Field 235
5.2.4 Changing a Field's Data Type 239
5.3 Maintaining Your Data's Integrity
5.3.1 Enforcing Required Fields 241
5.3.2 Specifying Default Values 243
5.3.3 Validating Fields and Records 245
5.3.4 Using an Input Mask 247
5.3.5 Defining a Lookup Field 251
5.3.6 Inserting a Lookup Column 255
5.4 Importing and Exporting Data
5.4.1 Importing Access Data into a New Table 257
5.4.2 Importing Structured Data 259
5.4.3 Exporting Structured Data 265
Chapter 6 Creating Select Queries
Case Study
6.1 Using the Query Design View
6.1.1 Creating a Query in Design View 289
6.1.2 Modifying a Query Object 293
6.1.3 Specifying Search Criteria 295
6.2 Creating Multi-Table Queries
6.2.1 Adding and Removing Tables 299
6.2.2 Adding and Removing Fields 301
6.2.3 Specifying Multi-Table Criteria 303
6.2.4 Previewing and Printing the Dynaset 305
6.3 Enhancing a Select Query
6.3.1 Sorting Query Results 306
6.3.2 Applying Filters to the Dynaset 309
6.3.3 Specifying Multiple Criteria in Different Fields 312
6.3.4 Specifying Multiple Criteria in a Single Field 315
6.4 Performing Calculations
6.4.1 Creating a Calculated Field 318
6.4.2 Setting Field Properties 321
6.4.3 Using the Expression Builder 322
6.4.4 Creating Summary Queries 325
Chapter 7 Creating Advanced Queries
Case Study
7.1 Relating Tables and Setting Joins
7.1.1 Creating Table Relationships 353
7.1.2 Understanding and Setting Join Properties 358
7.1.3 Displaying a Query in SQL View Mode 363
7.2 Working with Select Queries
7.2.1 Displaying the Highest or Lowest Values 367
7.2.2 Testing for Null Values and Zero-Length Strings 369
7.2.3 Entering Complex Expressions 371
7.2.4 Presenting Data Using a Custom Sort Order 374
7.2.5 Setting Query Properties 377
7.3 Creating Special-Purpose Queries
7.3.1 Finding Duplicate Records and Values 381
7.3.2 Finding Unmatched Records 384
7.3.3 Creating a Crosstab Query 386
7.3.4 Creating a Parameter Query 389
7.4 Creating Action Queries
7.4.1 Creating an Update Query 393
7.4.2 Creating a Delete Query 397
7.4.3 Creating a Make-Table Query 401
7.4.4 Creating an Append Query 404
Chapter 8 Creating Forms, Reports, and Pages
Case Study
8.1 Using the Form Design View
8.1.1 Viewing and Modifying a Form 429
8.1.2 Understanding Bound and Unbound Controls 434
8.1.3 Inserting, Deleting, Sizing, and Moving Controls 437
8.1.4 Creating a Calculated Control 442
8.1.5 Creating a Main Form and Subform 446
8.2 Customizing a Form
8.2.1 Aligning, Spacing, and Sizing Controls 450
8.2.2 Changing the Tab Order 454
8.2.3 Formatting Controls on a Form 456
8.2.4 Using the AutoFormat Command 458
8.3 Using the Report Design View
8.3.1 Viewing and Modifying a Report 459
8.3.2 Manipulating Controls in a Report 463
8.3.3 Creating a Calculated Control 467
8.4 Customizing a Report
8.4.1 Formatting Controls in a Report 470
8.4.2 Applying Conditional Formatting 474
8.4.3 Sorting and Grouping Data 476
8.4.4 Adjusting Page and Margin Settings 478
8.5 Creating Data Access Pages
8.5.1 Creating a Data Access Page Using a Wizard 480
8.5.2 Creating a Grouped Data Access Page 483
Answers to Self-Check Questions
Glossary
Appendix Preparing to Use Office XP, Volume II
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)