Office Specialist Beg Word Expert Word Beg Excel Expert Excel PowerPoint Outlook Access Vista  

Organizing Information Database Tables Database Forms Enter records using a form Edit records from a table Find a record in a table Sort records in a Table 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   Building and Modifying Tables Create tables Set primary keys Modify field properties Specify Default field values Create required fields Use multiple data types Modify tables using Design View Use the Input Mask Wizard Microsoft Access Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics	Building and Modifying Forms Create a form with the Form Wizard 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	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