Murakami Sale
 
 

Recently Viewed clear list


Q&A | August 19, 2014

Richard Kadrey: IMG Powell’s Q&A: Richard Kadrey



Describe your latest book. The Getaway God is the sixth book in the Sandman Slim series. In it, the very unholy nephilim, James Stark, aka Sandman... Continue »
  1. $17.49 Sale Hardcover add to wish list

spacer

On Order

$53.95
New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Personal Computers- Desktop Applications- Databases

Special Edition Using Microsoft Access 2003 with CDROM (Special Edition Using)

by

Special Edition Using Microsoft Access 2003 with CDROM (Special Edition Using) Cover

 

Synopses & Reviews

Publisher Comments:

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003¿s new XML export/import features.

The book¿s organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

Synopsis:

Covering all facets of Microsoft's desktop database development and management tool, this text provides a comprehensive guide to Access 2003.

Synopsis:

Detailed, step-by-step instructions with icons guide readers through all the features of Access. The accompanying CD includes all the book's Access queries, forms, reports, VBA code, projects, data access pages, and XML Web services.

About the Author

Shelley O'Hara is the author of more than 100 books, including several best-sellers. She has also authored business plans, a novel, Web content, marketing publications, short stories, training materials, magazine columns, a newsletter, and software manuals. She has written on topics ranging from Microsoft Windows to the International Air Transport Authority ticketing system, from Microsoft Office to buying a home. In addition to writing, O'Hara teaches training and personal development classes in Indianapolis.

Table of Contents

Introduction.

1. Learning Access Basics.

Database Window. Starting Access. Opening a Sample Database. Using the Menu Bar. Using Toolbars. Using the Objects Bar. Getting Help. Closing a Database. Quitting Access.

2. Creating Databases and Tables.

Creating a Database from a Template. Creating a New Blank Database. Opening an Existing Database. Creating a Table Using a Wizard. Creating a Database Table from Scratch. Displaying a Table in Design View. Adding a New Field. Changing a Field Name. Setting a Field's Data Type. Setting the Field Size for a Text Field. Setting the Field Size for a Number Field. Adding a Field Description. Deleting a Field. Setting the Primary Key. Saving the Data Table.

3. Entering Data.

Opening and Closing a Table in Datasheet View. Entering Data in a Table. Displaying Records. Creating a New Record. Selecting an Entry. Selecting Records and Columns. Freezing and Unfreezing Columns. Hiding and Unhiding Columns. Resizing Columns. Rearranging Columns. Editing a Record. Deleting a Record. Copying an Entry. Copying an Entire Record. Sorting Records in Datasheet View. Finding Data. Replacing Data. Formatting the Datasheet. Changing the Font. Checking Spelling. Previewing and Printing a Table.

4. Editing a Database's Table Structure.

Viewing Field Properties. Using Display Formats. Using an Input Mask. Adding a Field Caption. Entering a Default Value. Requiring an Entry. Indexing a Field. Applying a Smart Tag. Creating a Yes/No Field. Creating a Hyperlink Field. Creating a Memo Field. Creating an Object Field. Adding an Entry to an Object Field.

5. Creating and Using Forms.

Creating a Form Using an AutoForm. Creating a Form Using a Wizard. Saving a Form. Opening a Form. Using a Form to Add a New Record. Using a Form to Display Records. Using a Form to Edit Data. Using a Form to Select Records. Using a Form to Delete a Record. Using a Form to Search for a Record. Filtering Data by Selection. Filtering Data by Form. Viewing a Form in Design View. Selecting a Form Control. Deleting a Field from a Form. Resizing a Form Control. Moving a Form Control. Adding a Field to a Form. Changing the Tab Order. Viewing and Formatting Form Controls. Formatting Forms.

6. Creating Queries.

Creating a Select Query with a Wizard. Building a Query from Scratch. Viewing the Query Design. Entering Criteria to Query for an Exact Match. Entering Criteria to Query for a Range of Matches. Entering Multiple Criteria with the OR Operator. Entering Criteria to Match More Than One Field. Sorting Query Results. Adding a Field to a Query. Removing a Field from a Query. Saving a Query. Running a Query. Creating a New Table with Query Results. Deleting Records with a Query.

7. Creating Reports.

Creating an AutoReport. Creating a Report Using a Wizard. Saving a Report. Opening a Report. Viewing a Report's Design. Selecting a Report Control. Deleting a Field from a Report. Resizing a Report Control. Moving a Report Control. Adding a Field to a Report. Adding Labels to a Report. Adding Headers or Footers to a Report. Drawing on a Report. Adding a Picture to a Report. Sorting and Grouping Data in a Report. Using a Report AutoFormat. Setting Up the Page. Previewing a Report. Printing a Report.

8. Managing Your Database.

Renaming an Object. Deleting an Object. Password-Protecting a Database. Backing Up the Database. Viewing Database Properties. Setting Up Relationships. Editing Relationships. Using Subdatasheets.

Glossary.

Index.

Product Details

ISBN:
9780789729521
Author:
Jennings, Roger
Publisher:
Que
Location:
Indianapolis, Ind.
Subject:
General
Subject:
Database Management - MSAccess
Subject:
Database management
Subject:
Microsoft Access
Subject:
Desktop Applications - MS Access
Subject:
Database Management - General
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Edition Number:
Special ed.
Edition Description:
Trade paper
Series:
Special Edition Using
Series Volume:
71
Publication Date:
September 2003
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
1536
Dimensions:
9 x 7.5 x 2.25 in 2304 gr

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Databases

Special Edition Using Microsoft Access 2003 with CDROM (Special Edition Using) New Trade Paper
0 stars - 0 reviews
$53.95 Backorder
Product details 1536 pages Que - English 9780789729521 Reviews:
"Synopsis" by , Covering all facets of Microsoft's desktop database development and management tool, this text provides a comprehensive guide to Access 2003.
"Synopsis" by , Detailed, step-by-step instructions with icons guide readers through all the features of Access. The accompanying CD includes all the book's Access queries, forms, reports, VBA code, projects, data access pages, and XML Web services.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.