Select : Microsoft Access 2000

By (author) 

List price: US$45.33

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


The Select Office 2000 series is written from the ground up to reflect the MS Certification objectives. The class-tested, project-based, highly visual approach makes it easy to clearly see and understand what you are doing as you work through each more

Product details

  • Paperback | 304 pages
  • 213.36 x 271.78 x 12.7mm | 612.35g
  • Pearson Education Limited
  • Prentice-Hall
  • Harlow, United Kingdom
  • English
  • 0130651192
  • 9780130651198

Table of contents

Introducing Access 2000. Defining Database Terminology. Identifying Access Database Objects. Designing a Database. Launching Microsoft Access and Creating a New Database. Identifying Microsoft Access Screen Elements. Closing Your Database File and Exiting Microsoft Access. Project 1 Creating Access Tables. Opening an Access Database. Creating Tables. Naming Fields and Determining Data Types. Creating a Table Using Table Design View. Creating a Table Using the Table Wizard. Creating a Table by Importing Data from Excel. Adding Records to the Department Table. Creating an AutoForm to Display Records in the Employees Table. Project 2 Establishing Relationships and Modifying Tables. Adding a Lookup Field to the Time Cards Table. Creating and Modifying Relationships. Using the Relationships Window. Printing Relationships. Improving Data Accuracy Using Input Masks and Validation Rules. Adding a Lookup Field to a Table in Design View. Adding Records to the Time Cards Table Using Lookup Lists. Project 3 Manipulating Table Data. Navigating Among Table Records Using Datasheet View. Testing Validation Rules by Adding Records. Searching for Records. Updating Records in a Table. Updating Multiple Records in a Table Using Replace. Sorting Records. Filtering Records. Creating a Data Access Page. Viewing a Data Access Page on the Web. Project 4 Creating Queries. Creating Select Queries. Adding Fields to a Select Query. Creating a Query Displaying Data from Multiple Tables. Adding a Calculated Field to the Query. Defining the Sort Order for a Query. Specifying Query Conditions. Creating an AutoForm Based upon a Query. Project 5 Creating and Modifying Forms. Creating Forms. Creating a New Form Using Design View. Modifying a Form's Controls. Using ControlTips to Improve Data Accuracy. Adding Unbound Controls to a Form. Adding an Image to the Form Using an Unbound Control. Maintaining Table Data Using a Form. Project 6 Creating and Modifying Reports. Creating Reports. Creating a Report Using the Report Wizard. Viewing a Report in the Print Preview Window. Modifying the Report Design for Printing. Creating a Report Using Report Design View. Adding Sorting and Grouping Levels to the Report for Previewing and Printing. Adding a Calculated Control to the Report. Access 2000 Function Reference Guide. more