CART

(0) items

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition,9781418839079

New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

by
Edition:
1st
ISBN13:

9781418839079

ISBN10:
1418839078
Format:
Paperback
Pub. Date:
3/29/2005
Publisher(s):
Cengage Learning
List Price: $68.95

Rent Textbook

(Recommended)
 
Term
Due
Price
$4.99

Buy Used Textbook

In Stock Usually Ships in 24 Hours.
U9781418839079
$1.00

eTextbook

We're Sorry
Not Available

New Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $0.01
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 1st edition with a publication date of 3/29/2005.
What is included with this book?
  • The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Related Products


  • New Perspectives on Microsoft Access 2010, Brief
    New Perspectives on Microsoft Access 2010, Brief
  • New Perspectives on Microsoft Access 2013, Brief
    New Perspectives on Microsoft Access 2013, Brief
  • New Perspectives on Microsoft Office Access 2007, Brief
    New Perspectives on Microsoft Office Access 2007, Brief
  • New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition
    New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition
  • New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition, 1st Edition
    New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition, 1st Edition
  • New Perspectives on Microsoft® Office Access 2010, Brief, 1st Edition
    New Perspectives on Microsoft® Office Access 2010, Brief, 1st Edition
  • Review Pack for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2010, Comprehensive
    Review Pack for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2010, Comprehensive
  • WebTutor on Angel Instant Access Code for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition
    WebTutor on Angel Instant Access Code for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition
  • WebTutor on Blackboard Instant Access Code for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition
    WebTutor on Blackboard Instant Access Code for Adamski/Finnegan's New Perspectives on Microsoft Office Access 2007, Brief, Premium Video Edition




Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Access 2003. A great case-based, problem-solving approach to learning Access, this text covers the basics such as creating queries, forms, and reports. Perfect for any introductory course or used in conjunction with our other Microsoft Office application books.

Table of Contents

Preface iii
Office
1(2)
Read This Before You Begin
2(1)
Using Common Features of Microsoft Office 2003
3
Preparing Promotional Materials
3(1)
Exploring Microsoft Office 2003
4(1)
Integrating Office Programs
5(1)
Starting Office Programs
5(4)
Switching Between Open Programs and Files
8(1)
Exploring Common Window Elements
9(1)
Using the Window Sizing Buttons
9(2)
Using Menus and Toolbars
11(3)
Viewing Personalized Menus and Toolbars
11(3)
Using Task Panes
14(2)
Opening and Closing Task Panes
14(1)
Navigating Among Task Panes
15(1)
Using the Research Task Pane
16(2)
Working with Files
18(5)
Creating a File
19(1)
Saving a File
19(2)
Closing a File
21(1)
Opening a File
22(1)
Getting Help
23(6)
Using ScreenTips
23(1)
Using the Type a Question for Help Box
23(2)
Using the Help Task Pane
25(2)
Using Microsoft Office Online
27(2)
Printing a File
29(1)
Exiting Programs
30(1)
Quick Check
31(1)
Tutorial Summary
31(1)
Key Terms
31(1)
Review Assignments
31(1)
SAM Assessment and Training
32(1)
Quick Check Answers
32
Access
1(1)
Read This Before You Begin
2(1)
Introduction to Microsoft Access 2003
3(32)
Viewing and Working with a Table Containing Employer Data
3(1)
Session 1.1
4(1)
Introduction to Database Concepts
4(3)
Organizing Data
4(1)
Databases and Relationships
5(1)
Relational Database Management Systems
6(1)
Opening an Existing Database
7(3)
Exploring the Access and Database Windows
9(1)
Opening an Access Table
10(2)
Navigating an Access Datasheet
11(1)
Printing a Datasheet
12(1)
Saving a Database
12(1)
Session 1.1 Quick Check
13(1)
Session 1.2
13(1)
Working with Queries
13(5)
Opening an Existing Query
14(1)
Creating, Sorting, and Navigating a Query
15(3)
Creating and Navigating a Form
18(2)
Creating, Previewing, and Navigating a Report
20(4)
Printing Specific Pages of a Report
23(1)
Managing a Database
24(4)
Backing up and Restoring a Database
24(1)
Compacting and Repairing a Database
25(1)
Compacting a Database Automatically
26(1)
Converting an Access 2000 Database
27(1)
Session 1.2 Quick Check
28(1)
Tutorial Summary
29(1)
Key Terms
29(1)
Review Assignments
29(1)
Case Problems
30(3)
Internet Assignments
33(1)
SAM Assessment and Training
33(1)
Lab Assignments
34(1)
Quick Check Answers
34(1)
Creating and Maintaining a Database
35(46)
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table
35(1)
Session 2.1
36(1)
Guidelines for Designing Databases
36(2)
Guidelines for Setting Field Properties
38(3)
Naming Fields and Objects
38(1)
Assigning Field Data Types
38(1)
Setting Field Sizes
39(1)
Setting Field Captions
40(1)
Creating a New Database
41(1)
Creating a Table
42(11)
Defining Fields
43(7)
Specifying the Primary Key
50(2)
Saving the Table Structure
52(1)
Session 2.1 Quick Check
53(1)
Session 2.2
53(1)
Adding Records to a Table
53(3)
Modifying the Structure of an Access Table
56(9)
Deleting a Field
57(1)
Moving a Field
58(1)
Adding a Field
59(1)
Changing Field Properties
60(1)
Updating Field Property Changes
61(4)
Obtaining Data from Another Access Database
65(3)
Copying Records from Another Access Database
65(2)
Importing a Table from Another Access Database
67(1)
Updating a Database
68(3)
Deleting Records
68(1)
Changing Records
69(2)
Session 2.2 Quick Check
71(1)
Tutorial Summary
71(1)
Key Terms
72(1)
Review Assignments
72(2)
Case Problems
74(5)
Internet Assignments
79(1)
SAM Assessment and Training
80(1)
Quick Check Answers
80(1)
Querying a Database
81(48)
Retrieving Information About Employers and Their Positions
81(1)
Session 3.1
82(1)
Introduction to Queries
82(1)
Query Window
82(2)
Creating and Running a Query
84(3)
Updating Data Using a Query
87(1)
Defining Table Relationships
87(6)
One-to-Many Relationships
88(1)
Referential Integrity
89(1)
Defining a Relationship Between Two Tables
89(4)
Creating a Multi-table Query
93(2)
Sorting Data in a Query
95(5)
Using a Toolbar Button to Sort Data
95(1)
Sorting Multiple Fields in Design View
96(4)
Filtering Data
100(2)
Session 3.1 Quick Check
102(1)
Session 3.2
102(1)
Defining Record Selection Criteria for Queries
102(5)
Specifying an Exact Match
103(2)
Changing a Datasheet's Appearance
105(1)
Using a Comparison Operator to Match a Range of Values
106(1)
Defining Multiple Selection Criteria for Queries
107(5)
The And Logical Operator
108(1)
Using Multiple Undo and Redo
109(2)
The Or Logical Operator
111(1)
Performing Calculations
112(9)
Creating a Calculated Field
113(4)
Using Aggregate Functions
117(2)
Using Record Group Calculations
119(2)
Session 3.2 Quick Check
121(1)
Tutorial Summary
121(1)
Key Terms
121(1)
Review Assignments
122(1)
Case Problems
123(4)
Internet Assignments
127(1)
SAM Assessment and Training
128(1)
Quick Check Answers
128(1)
Creating Forms and Reports
129
Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report
129(1)
Session 4.1
130(1)
Creating a Form Using the Form Wizard
130(3)
Changing a Form's AutoFormat
133(2)
Finding Data Using a Form
135(3)
Previewing and Printing Selected Form Records
138(1)
Maintaining Table Data Using a Form
139(2)
Session 4.1 Quick Check
141(1)
Session 4.2
142(1)
Creating a Form with a Main Form and a Subform
142(5)
Modifying a Form in Design View
145(2)
Creating a Report Using the Report Wizard
147(11)
Checking Errors in a Report
155(3)
Inserting a Picture in a Report
158(2)
Session 4.2 Quick Check
160(1)
Tutorial Summary
161(1)
Key Terms
161(1)
Review Assignments
161(2)
Case Problems
163(5)
Internet Assignments
168(1)
SAM Assessment and Training
168(1)
Quick Check Answers
168
Glossary/Index 1(6)
Task Reference 7


Please wait while the item is added to your cart...