Access Field Properties Category, 10 points

False. Field Properties are part of the Table Design view.







Access Field Properties Category, 20 points
@A required text character or space.
>Forces all characters to uppercase.
<Forces all characters to lowercase.
&An optional text character.







Access Field Properties Category, 30 points

The Default Value property is used to specify a value that is automatically entered in a field when a new record is created.







Access Field Properties Category, 40 points

To format the data value in a field whenever the value is displayed to the user. For example,
00000\-9999;;
will format a five-digit zip code, with the optional four-digit extension preceded by a dash.







Access Field Properties Category, 50 points

The validation rule contains the validity checks that are automatically performed when data is entered, while the validation text is displyed when a validation rule fails.







Access Forms Category, 10 points

An Access Form is an object used primarily to display records onscreen. A Form makes it easier to enter new records or update existing records.







Access Forms Category, 20 points
Label ControlText Box Control
Are typically unbound controls.Is typically bound to a field in the underlying table or query.
Used to display informational text to the user.Used to display a field value to the user.
Value can not be changed by the user while in Form view.Value can be changed by the user while in Form view.
Value can be changed by the user while in Design view.Value can not be changed while in Design view.







Access Forms Category, 30 points

Yes. To do this, you would first create a mutli-table query. Then, select the multi-table query as the underlying table/query within the Form Wizard.







Access Forms Category, 40 points
  1. Select the Text Box control.
  2. Position the mouse pointer over the handle at the top left corner of the text box control. Note that the mouse pointer will change shape, to a blank hand with the index finger pointing at the handle.
  3. Click and drag the handle of the text box control to the appropriate location within the form.
  4. Release the mouse button when you've positioned the text box control correctly.







Access Forms Category, 50 points

A bound control is a control that is tied to a field in the underlying table or query.







Access Views Category, 10 points
  1. Design view
  2. Form view
  3. Datasheet view







Access Views Category, 20 points







Access Views Category, 30 points

False. To move, size or align controls on a form, you must be in form Design view.







Access Views Category, 40 points
  1. Click on Select All found on the Edit menu.
  2. Position the mouse pointer in the upper right corner of the form. Click and drag the selection box to the lower left corner. Release the mouse button.







Access Views Category, 50 points

The tool box, found when in form Design view, is used to add additional controls to the form design.







Access Miscellaneous Category, 10 points
  1. Click the Design button for the appropriate form object.
  2. Select the appropriate text box control within the form.
  3. Select the font size from the Font Size drop down list.
  4. Select Format, Size, To Fit from the menu.
  5. Adjust the width of the control based on the values contained in the corresponding table field.
  6. Click on the Form background to remove the selection of the text box control.







Access Miscellaneous Category, 20 points

Ctrl + Page Down







Access Miscellaneous Category, 30 points

True.







Access Miscellaneous Category, 40 points
  1. Find the record you wish to print.
  2. Click on Edit, Select Record in the menu.
  3. Click on File, Print in the menu.
  4. Click on the Selected Record(s) option button found on the Print dialog box.
  5. Click OK.







Access Miscellaneous Category, 50 points

Yeah!