10 Minute Guide to Microsoft Access 2002

Joe Habraken is a computer technology professional and best-selling author with more than fifteen years of experience in the information technology field as a network administrator, consultant, and educator. His recent publications include Microsoft Office XP 8-in-1, The Absolute Beginner's Guide to Networking (Second Edition), and Practical Cisco Routers. Joe currently serves as the Director of UNEit, an IT training center for computer industry professionals at the University of New England in Portland, ME.

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.