Home > Store > Business & Management > Business Applications

larger cover

Add To My Wish List

Register your product to gain access to bonus material or receive a coupon.

10 Minute Guide to Microsoft Access 2002, Adobe Reader

eBook (Adobe DRM)

  • Sorry, this book is no longer in print.
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
Not for Sale
  • Description
  • Sample Content
  • Updates
  • Copyright 2002
  • Pages: 224
  • Edition: 1st
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-5523-4
  • ISBN-13: 978-0-7686-5523-0

Because most people don't have the luxury of sitting down uninterrupted for hours at a time to learn Excel, this 10-Minute Guide focuses on the most often used features, covering them in lessons designed to take 10 minutes or less to complete. In addition, this guide teaches the user how to use Excel without relying on technical jargon, and by providing straightforward, easy-to-follow explanations and lists of numbered steps that tell the user which keys to press and which options to select.

Table of Contents



Introduction.


1. Whats New in Access 2002.

Understanding Access 2002. Introducing Other Access Objects. Whats New in Access 2002. Introducing Task Panes. Introducing Voice Dictation and Voice Commands.



2. Working in Access.

Planning a Database. Starting Access. Parts of the Access Screen. Exiting Access.



3. Creating a New Database.

Choosing How to Create Your Database. Selecting a Database File Type. Creating a Blank Database. Closing a Database. Creating a Database from a Template. Opening a Database.



4. Creating a Table with the Table Wizard.

Tables Are Essential. Working with the Table Wizard.



5. Creating a Table from Scratch.

Creating Tables Without the Wizard. Creating a Table in Table Design View. Setting the Primary Key. Understanding Data Types and Formats. Creating a Table in the Datasheet View.



6. Editing a Tables Structure.

Editing Fields and Their Properties. Adding, Deleting, and Moving Fields. Deleting a Table.



7. Entering Data into a Table.

Entering a Record. Moving Around in a Table. Hiding a Field. Freezing a Column. Using the Spelling Feature. Closing a Table.



8. Editing Data in a Table.

Changing a Fields Content. Moving and Copying Data. Inserting and Deleting Fields. Inserting New Records. Deleting Records.



9. Formatting Access Tables.

Changing the Look of Your Table. Changing Column Width and Row Height. Changing the Font and Font Size.



10. Getting Help in Microsoft Access.

Help: Whats Available? Using the Ask a Question Box. Using the Office Assistant. Using the Help Window. Getting Help with Screen Elements.



11. Creating Relationships Between Tables.

Understanding Table Relationships. Creating a Relationship Between Tables. Enforcing Referential Integrity. Editing a Relationship. Removing a Relationship.



12. Creating a Simple Form.

Creating Forms. Creating a Form with AutoForm. Creating a Form with the Form Wizard. Creating a Form from Scratch. Entering Data into a Form.



13. Modifying a Form.

Cleaning Up Your Form: An Overview. Moving Field Controls. Moving Controls and Field Labels Independently. Changing Label and Control Sizes. Viewing Headers and Footers. Adding Labels. Formatting Text on a Form. Changing Tab Order.



14. Adding Special Controls to Forms.

Using Special Form Controls. Creating a List Box or a Combo Box. Creating an Option Group. Adding Command Buttons.



15. Searching for Information in Your Database.

Using the Find Feature. Using the Replace Feature.



16. Sorting, Filtering, and Indexing Data.

Finding and Organizing Your Data. Sorting Data. Filtering Data. Indexing Data.



17. Creating a Simple Query.

Understanding Queries. Using the Simple Query Wizard. Using Other Query Wizards. Understanding Access Query Types.



18. Creating Queries from Scratch.

Introducing Query Design View. Adding Fields to a Query. Deleting a Field. Adding Criteria. Using the Total Row in a Query. Viewing Query Results.



19. Creating a Simple Report.

Understanding Reports. Using AutoReport to Create a Report. Creating a Report with the Report Wizard. Viewing and Printing Reports in Print Preview.



20. Customizing a Report.

Entering Report Design View. Working with Controls on Your Report. Placing a Calculation in the Report.



21. Taking Advantage of Database Relationships.

Reviewing Table Relationships. Viewing Related Records in the Datasheet View. Creating Multi-Table Queries. Creating Multi-Table Forms. Creating Multi-Table Reports.



22. Printing Access Objects.

Access Objects and the Printed Page. Printing Reports. Printing Other Database Objects. Using the Print Dialog Box.



Index.

FREE

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.