Description

This book presents the newest version of Microsoft Access, the world's leading database program, in an easy-to-follow visual format, with full-color screen shots and step-by-step instructions. It breaks Access instructions down into two-page lessons illustrated with high-resolution graphics. Access "X" is part of the new release of Microsoft Office, which holds ninety percent of the market for Windows-based productivity suites. Microsoft Office is the world standard in productivity software, with more than 120 million users worldwide.show more

Table of contents

Chapter 1: GETTING STARTED. Introduction to Access. Start Access. Parts of a Database. Plan a Database. Create a Database Using the Database Wizard. Create a Blank Database. Open a Database. Using the Database Wizard. Rename a Database Object. Delete a Database Object. Minimize a Window. Display or Hide a Toolbar. Search for a Database. Back Up a Database. Getting Help. Chapter 2: CREATE TABLES. Create a Table in the Database View. Create a Table Using the Table Wizard. Open a Table. Change a Column Width. Rename a Field. Rearrange Fields. Add a Field. Delete a Field. Change the Appearance of a Table. Chapter 3: EDIT TABLES. Move Through Data. Select Data. Edit Data. Zoom Into a Cell. Display a Subdatasheet. Check Spelling. Move or Copy Data. Add a Record. Delete a Record. Change the Font of Data. Hide a Field. Freeze a Field. Chapter 4: DESIGN TABLES. Change the View of a Table. Add a Field. Delete a Field. Rearrange Fields. Display Field Properties. Add a Field Description. Change a Data Type. Select a Format. Change the Field Size. Change the Number of Decimal Places. Add a Caption. Set a Default Value. Data Entry Required. Add a Validation Rule. Create an Input Mask. Create a Field to Store Pictures. Create a Lookup Column. Create a Yes/No Field. Create a Hyperlink Field. Using Smart Tags. Chapter 5: ESTABLISH RELATIONSHIPS. View Object Dependencies. Set the Primary Key. Create Relationships Between Tables. Enforce Referential Integrity. Chapter 6: CREATE FORMS. Create a Form Using an AutoForm. Create a Form Using the Form Wizard. Open a Form. Move Through Records. Edit Data. Add a Record. Delete a Record. Chapter 7: DESIGN FORMS. Change the View of a Form. Move or Resize a Control. Delete a Control. Change the Size of a Form. Add a Field. Add a Label. Change Label Text. Bold, Italicize or Underline Data. Change the Font of Data. Change the Size of Data. Change the Color of a Control. Change the Alignment of Data. Undo Changes. Add a Picture. Apply Conditional Formatting. Apply an AutoFormat. Chapter 8: FIND DATA. Sort Records. Find Data. Replace Data. Filter by Selection. Filter by Input. Filter by Exclusion. Filter by Form. Chapter 9: CREATE QUERIES. Create a Query in the Design View. Create Query Using the Simple Query Wizard. Change the View of a Query. Open a Query. Rearrange Fields. Add Fields. Delete a Field. Hide a Field. Sort Query Results. Using Criteria to Find Record. Using Multiple Criteria to Find Records. Examples of Criteria. Display Highest or Lowest Values. Perform Calculations. Using Parameters. Summarize Data. Find Unmatched Records. Chapter 10: USING THE PIVOTTABLE AND PIVOTCHART VIEWS. Using the PivotTable View. Using the PivotChart View. Chapter 11: CREATE REPORTS. Create a Report Using the Report Wizard. Create a Report Using an AutoReport. Open a Report. Move Through Pages. Change the View of a Report. Zoom In or Out. Apply an AutoFormat. Add a Picture. Chapter 12: PRINT INFORMATION. Preview Before Printing. Change Page Setup. Print Information. Create Mailing Labels. Chapter 13: CREATE DATA ACCESS PAGE. Create a Data Access Page. Change the View of a Data Acces Page. Open a Data Access Page. Add a Title. Move Through records. Apply a Theme. Rename a Data Access Page. Delete a Data Access Page.show more

About Ruth Maran

Ruth Maran (Mississauga, Ontario, Canada) has over 10,000,000 books in print and translated into 26 languages. She is part of the award--winning maranGraphics family. Her end--user and programming books alike are best sellers and have appeared on the Publishers Weekly best seller list. Some of her best selling titles include Teach Yourself VISUALLY Windows XP, Master VISUALLY Windows XP, and Windows XP Simplified, all of which are on Bookscan's Top 50 Computer list.show more