Organizing Information Database Tables Begin Access Pg. 12 Sort records in a Table Begin Access Pg 13 Find a record in a table Begin Access Pg 14 Edit records from a table Begin Access Pg. 15   Building and Modifying Tables Modify tables using Design View Begin Access Pg. 17 Create a Number Field Begin Access Pg. 17 Create required fields Begin Access Pg. 18 Define text length Begin Access Pg. 20 Create a new table Begin Access Pg. 20 Choose what data you keep Begin Access Pg. 28 Create a List Field   Use multiple data types   Microsoft Access Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics	Formatting Tables Set primary keys Begin Access Pg. 22 AutoNumber Fields Begin Access Pg. 23 Specify Default field values Begin Access Pg. 25 Use the Input Mask Wizard Begin Access Pg. 26 Format a Text field Begin Access Pg. 28 Use Boolean operators (And, Or) Begin Access Pg. 67 Format a Field for Currency Begin Access Pg. 73 Create a Memo Field Begin Access Pg. 75   Building and Modifying Forms Database Forms Begin Access Pg. 33 Create Forms in Layout View Begin Access Pg. 35 Enter records using a form   Add Controls Modify Format Properties (font, style, font size, color, caption, etc.) of controls Form sections: headers and footers Default form view: datasheet Use a Calculated Control on a form   Working with Access Select Objects: Tables, Forms Navigate through records in a table, query, or form Determine appropriate data   Sort Records in a Query Sort records in a Report Specify criteria in a query Combine fields in a query Use an Update Query Enter records using a datasheet Create a calculated field Multitable Select Query	Producing Reports Create a report with the Report Wizard Preview and print a report Move and resize a control Modify Format Properties (font, style, font size, color, caption, etc.) Use report sections (headers, footers, and detail) Use a Calculated Control: Date Use a Calculated Control: Count Use Sorting and Grouping   Using Access Tools Compact and repair a database