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.
Sams Teach Yourself Access 2000 in 10 Minutes is a tutorial, organized into lessons starting with the basics and progressing to more advanced features. Straightforward, practical examples provide quick results. The book includes coverage of queries, form design, table relationships, team collaboration, and the Internet.
Introduction.
What Is Microsoft Access 2000? What Is the Sams Teach Yourself in 10 Minutes Series? Conventions Used in This Book.
What Are Databases Good For? How Access Stores Your Data. Reports. Queries. How the Parts Fit Together. Access Wizards Make Databases Easy.
Planning Is Important! Determining the Tables You'll Need. What Forms Will You Use? What Reports Will You Want to Produce?
Starting Access. Parts of the Screen. Exiting Access.
Help: What's Available? Asking Office Assistant. Using the Microsoft Access Help Window. Reading a Help Topic. Finding and Fixing Errors in the Program. Other Help Features.
Choosing the Right Way to Create Your Database. Creating a Blank Database. Creating a Database with Database Wizard.
Saving a Database. Closing a Database. Opening a Database. Changing the Drive or Folder. Finding a Database File.
Why Create a Table? Creating a Table Using the Table Wizard. Now What?
Editing Fields and Their Properties. Adding Fields. Deleting Fields. Hiding a Field. Deleting a Table.
Why Create Relationships? Creating a Relationship Between Tables. What is Referential Integrity? Editing a Relationship. Removing a Relationship. Now What?
Entering a Record. Some Data-Entry Tricks. Moving Around in a Table. Printing a Table. Closing a Table.
Changing a Cell's Content. Selecting Records. Inserting New Records. Deleting Records. Moving and Copying Data.
Why Format a Table? Changing Column Width and Row Height. Changing the Font.
Why Create Forms? Creating a Form with AutoForm. Creating a Form with Form Wizard. Creating a Form from Scratch. Entering Data in a Form.
Cleaning Up Your Form: An Overview. Moving Controls. Moving Controls and Their Labels Independently. Resizing Controls. Viewing Headers and Footers. Adding Labels. Formatting Controls. Changing Tab Order.
Why Use Special Data-Entry Controls? What Kinds of Controls? Creating a List Box or Combo Box. Creating an Option Group. Adding Command Buttons. Inserting ActiveX Controls.
Why Add Graphics to Forms? Importing Clip Art. Importing a Graphic. Resizing a Graphic. Creating a New Picture.
Using the Find Feature. Using the Replace Feature. Other Ways to Find Data.
Finding and Organizing Your Data. Sorting Data. Filtering Data. Creating Indexes.
What Can a Query Do? Creating a Query Using the Simple Query Wizard. Printing Query Results. Other Query Wizards.
Working with Query Design View. Adding Fields to a Query. Deleting a Field. Adding Criteria. Viewing Query Results.
Sorting a Field in a Query, Showing or Hiding a Field. Adding a Calculated Field.
Why Create 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.
What Good Are Related Tables? Viewing Related Data in Datasheet View. Creating Multitable Queries. Creating Multitable Forms. Creating Multitable Reports.
The Chart Advantage. Creating a Chart. Using Print Preview. Saving a Chart Report.
Some Internet Basics. Saving as a Web Page. Inserting Hyperlinks Into an Access Object. Creating Data Access Pages.
Why Share Data? Setting Up Exclusive Use. Assigning Passwords to Database Files. User-Level Security (Network Only). Team Collaboration. Creating an .mde File. Encrypting a Database. Data Protection on Forms.
Why Import and Export Data? Importing Data from Other Programs. Exporting Data to Other Programs.
Backing Up Your Database File. Repairing Damaged Database Files.