Planning and Designing Databases Determine appropriate data inputs/outputs for your database Create table structure Establish table relationships
	Working with Access Use the Microsoft Office Assistant Select an object using the Objects Bar Print database objects (tables, forms, reports, and queries) Navigate through records in a table, query, or form Create a database (using a wizard or in-design view)
	Building and Modifying Tables Create tables by using the Table Wizard Set primary keys Modify field properties Use multiple data types Modify tables using Design View Use the Lookup Wizard Use the Input Mask Wizard
	Building and Modifying Forms Create a form with the Form Wizard Use the Control Toolbox to add controls Modify Format Properties (font, style, font size, color, caption, etc.) of controls Use form sections (headers, footers, and detail) Use a Calculated Control on a form
	Viewing and Organizing Information Use the Office Clipboard Switch between object views Enter records using a datasheet Enter records using a form Delete records from a table Find a record Sort records Apply and remove filters (filter by form and filter by selection) Specify criteria in a query Display related records in a subdatasheet Create a calculated field Create and modify a multitable select query
	Defining Relationships Establish relationships Enforce referential integrity
	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 the Control Toolbox to add controls Use report sections (headers, footers, and detail) Use a Calculated Control in a report
	Integrating with Other Applications Import data to a new table Save a table, query, or form as a Web page Add Hyperlinks
	Using Access Tools Print database relationships Back-up and restore a database Compact and repair a database