To set the data type for a field
With the table in Design view, click the Data Type cell next to the desired field.
Click the Data Type arrow, and then in the list, click the data type you want.
To view the properties of a field
To set the Field Size property for text, number, and autonumber fields
To use the Input Mask wizard
With the table in Design view, select a field, and then click Input Mask in the Field Properties area.
Click the ellipsis button to the right of the cell to start the Input Mask wizard. (Click Yes if Access prompts you to install this feature.)
Select an available mask in the Input Mask list, and then click Next.
In the Input Mask and Placeholder character boxes, make any changes you want, and then click Next.
Choose whether to store the data with the symbols, and then click Finish.
To set a field validation rule
To test the validation rules in a table
To select an entire field
To set a table validation rule
To create a lookup list with the Lookup wizard
Set the data type of a field to Lookup Wizard.
Select the options you want, and then click Next.
Continue selecting the options you want, clicking Next when you are done with each page. When you are done filling out the wizard, click Finish.
On the Quick Access Toolbar, click the Save button.
To restrict what can be entered in a lookup list
In Design view, in the Field Properties area, click the Lookup tab.
Change Limit To List to Yes.
Change Allow Value List Edits to No.
Save the table.
To create a multi-column lookup list
Add a new field, name it, and then set the data type to Lookup Wizard.
Select the values option you want, and then click Next.
Type the number of columns you want, and then enter the data you want in each column.
Click Next, and then click Finish.
Save your changes.
To prevent a column from being displayed in a multi-column lookup list
To filter selections in a multi-column lookup list
To create a select query
You must first create a select query. On the Create tab, in the Other group, click the Query Design button.
In the New Query dialog box, with Simple Query Wizard selected, click OK.
In the Tables/Queries list, click the option you want. Then in the Available Fields list, double-click the fields you want to move to the Selected Fields list.
In the Simple Query Wizard dialog box, click Finish to create the select query.
To create an update query
First, create a select query that selects the records you want to update.
Open the select query in Design view. Then on the Design contextual tab, in the Query Type group, click the Update button.
In the design grid, type the expression for your update.
To create an action query
First, create a select query that selects the records you want to manipulate.
Open the select query in Design view. Then on the Design contextual tab, in the Query Type group, click the Make Table, Append, Update, or Delete button.
Provide the information requested for the specified query type.
To create a delete query
First, create a select query that selects the records you want to delete.
Open the select query in Design view. Then on the Design contextual tab, in the Query Type group, click the Delete button to convert this select query to a delete query.
In the design grid, set the delete criteria.
To back up a database
Click the Microsoft Office Button, point to Manage, and then click Back Up Database.
In the Save As dialog box, navigate to the folder in which you want to store the backup, and then click Save.
To compact a database
To analyze the performance of a database
On the Database Tools tab, in the Analyze group, click the Analyze Performance button.
In the Performance Analyzer dialog box, on the All Object Types tab, click Select All, and then click OK.
Click each result in the Analysis Results box to display more information about that result in the Analysis Notes area.
To document a database