Inserting, renaming, and deleting columns; inserting lookup and hyperlink columns

Using comparison operators, And and Or conditions, the Between...And operator, and wildcard characters

Setting top values in a query; creating a calculated field, a function query, and a parameter query

Creating a make-table query, an update query, an append query, and a delete query

Using the Crosstab Query Wizard, the Find Duplicates Query Wizard, and the Find Unmatched Query Wizard

Changing database properties, linking data to an Access table, importing data, setting a database password, compacting a database

Using, deleting, and moving controls; selecting adjacent and non-adjacent controls; sizing a control automatically and by dragging

Displaying the ruler and the field list; enabling Snap to Grid; adding fields, labels, images, rectangles, and lines; moving part of a paired control; aligning and spacing controls; using the toolbox; editing an unbound control

Using forms in Design view; creating a combo box, a list box, and an option group; setting the tab order automatically and manually; adding a header and footer to a form

Using reports in Design view; creating a calculated control; grouping data in a report; creating a group header and a running summary; inserting the date, the time, and a page break; changing report margins; using the Label Wizard

Changing the font name, size, and style; using the Format Painter, AutoFormat, and the Spelling Checker; selecting objects with the toolbar; setting AutoCorrect options; adding and deleting AutoCorrect entries