Chapter 12: Keeping Your Information Accurate


Page 270

To specify data type settings

 
  1. Display the table in Design view.

  2. Click in the Data Type cell of the field you want to change, click the down arrow,and then click the data type you want.

274

To set a field s size property

 
  1. Display the table in Design view.

  2. Click in the field you want to change, and then in the Field Properties area, clickin the Field Size box, click the down arrow, and change the setting to what you want.

276

To create a custom input mask

 
  1. Display the table in Design view.

  2. Select the field for which you want to set an input mask, and in the Field Properties area, click Input Mask .

  3. Click the button to start the Input Mask Wizard . (Click Yes if you are promptedto first save the table or install this feature.)

  4. Select an input mask from the options, or enter your own input mask in the Try It box, and then click Next .

  5. Specify whether you want to store the symbols with the data, and then click Finish .

  6. Press [ENTER] to accept the mask.

281

To set a field validation rule

 
  1. Display the table in Design view.

  2. Select the field you want to add a rule to, and in the Field Properties area, click the Validation Rule box,

  3. Click the button at the right end of the Validation Rule box to open the Expression Builder, or type an expression and press [ENTER].

  4. In the Validation Text box, type a description of the rule.

  5. Click in the Caption box, and indicate the type of entry that can be made in the field, for example, Phone Number .

  6. Save and close the table.

284

To use a Lookup List to restrict data

 
  1. Display the table in Design view.

  2. Click the Data Type cell for the field in which you want to use a Lookup List, click the down arrow, and then click Lookup Wizard .

  3. Select the option to either look up the values in a table or query, or to type in the values that you want, and click Next .

  4. Follow the wizard s instructions (which will be determined by your choice in step 3), and then click Finish .

290

To create and run an update query

 
  1. Create a query that displays the information you want and then open the queryin Design view.

  2. On the Query menu, click Update Query .

  3. In the Update To row of the field you want to update, type the text you want, or create an expression.

  4. Click the Run button, click Yes when Access warns you that you are about to update records, and save and close the query.

294

To create and run a delete query

 
  1. Create a query that displays the information you want and then open the queryin Design view.

  2. On the Query menu, click Delete Query .

  3. Type the text you want in the Criteria row under the appropriate field.

  4. Click the Run button to run the delete query and click Yes when Access warnsyou that you are about to delete records.

  5. Save and close the query.




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net