Machine derived contents note: Introduction: Using this Guide. Data, Databases and Information. Database Management Systems. Uses of Databases. Relational Databases. Queries, Forms and Reports. Some Conventions.- Getting Started: Starting Up Access 97. The Access Window. Opening a Database. Viewing a Table. Modifying a Record. Saving a Database. View Options. Selecting and Modifying Toolbars. Using Access 97 Help. Creating a Database: Designing Tables. Derived Data. Primary Keys. Types of Data. Indexes. Access Database Wizards. The Table Design Toolbar. Creating Tables. Adding Fields. More Data Types. Choosing Field Options. Setting Up Relationships. Entering Data into a Table. Sorting Table Data. Re-arranging Table Columns. Find and Replace. Checking Spelling of Text Fields. Filtering Rows. Printing Tables. Closing Exercises.- Retrieving Information: Queries. Using the Query Wizard. Creating a Simple Query. Specifying Criteria and Using.- Expressions: The Query Design Toolbar. Adding Calculations to Queries. Adding a Filter. Queries Based on More than One Table.- Using Forms: Why Forms are Useful. Basic Forms Ideas. Types of Access Forms. Designing a Form. Creating a Form with the Form Wizard and AutoForm. Form Design Toolbar. Creating a Form using Design View. Adding Graphics to Forms. Printing a Form.- Reporting: When to Use Reports. Some Example Reports. Using the Report Wizard. Report Design Toolbar. Creating a Report Using Design View. Sequence and Group Information in Reports. Using Graphics in Reports
