SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Register your product to gain access to bonus material or receive a coupon.
Adobe® Digital Editions software.
This eBook requires the freeBefore downloading this DRM-encrypted PDF, be sure to:
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.
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.
Planning a Database. Starting Access. Parts of the Access Screen. Exiting Access.
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.
Tables Are Essential. Working with the Table Wizard.
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.
Editing Fields and Their Properties. Adding, Deleting, and Moving Fields. Deleting a Table.
Entering a Record. Moving Around in a Table. Hiding a Field. Freezing a Column. Using the Spelling Feature. Closing a Table.
Changing a Fields Content. Moving and Copying Data. Inserting and Deleting Fields. Inserting New Records. Deleting Records.
Changing the Look of Your Table. Changing Column Width and Row Height. Changing the Font and Font Size.
Help: Whats Available? Using the Ask a Question Box. Using the Office Assistant. Using the Help Window. Getting Help with Screen Elements.
Understanding Table Relationships. Creating a Relationship Between Tables. Enforcing Referential Integrity. Editing a Relationship. Removing a Relationship.
Creating Forms. Creating a Form with AutoForm. Creating a Form with the Form Wizard. Creating a Form from Scratch. Entering Data into 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.
Using Special Form Controls. Creating a List Box or a Combo Box. Creating an Option Group. Adding Command Buttons.
Using the Find Feature. Using the Replace Feature.
Finding and Organizing Your Data. Sorting Data. Filtering Data. Indexing Data.
Understanding Queries. Using the Simple Query Wizard. Using Other Query Wizards. Understanding Access Query Types.
Introducing Query Design View. Adding Fields to a Query. Deleting a Field. Adding Criteria. Using the Total Row in a Query. Viewing Query Results.
Understanding Reports. Using AutoReport to Create a Report. Creating a Report with the Report Wizard. Viewing and Printing Reports in Print Preview.
Entering Report Design View. Working with Controls on Your Report. Placing a Calculation in the Report.
Reviewing Table Relationships. Viewing Related Records in the Datasheet View. Creating Multi-Table Queries. Creating Multi-Table Forms. Creating Multi-Table Reports.
Access Objects and the Printed Page. Printing Reports. Printing Other Database Objects. Using the Print Dialog Box.