Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 35
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 107
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 109
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 111
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 112
Apr
Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 35
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 107
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 109
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 111
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 112
11
Another great way to keep your data in shape is to avoid freeform text inputs wherever posÂsible. If a data entry user has to type a customer name or product name from memory, that’s a sure recipe for inconsistent and error-filled data. Fortunately, in many cases, you can avoid freeform text entry. If there are only a finite number of possible values for a field, you can eliminate this weak link in your data chain by giving users a list of items to choose from. This is called a lookup column. A lookup column won’t ensure error-free data entry (the user can still choose the wrong item in the list), but it does ensure that the field won’t contain typos or inconsistent entries.
Access offers two methods for defining lookup columns: You can take the unique values for a field in an existing table or query, or you can type the list values yourself. The following steps show you how to create a lookup column based on the values in a table or query field:
- Open the table you want to work with in Design view (right-click the table in the Navigation pane and then click Design View).
- Choose Design, Lookup Column. Access starts the Lookup Wizard.
- Make sure the I Want the Lookup Column to Look Up the Values in a Table or Query option is activated and then click Next.
- Click the table that contains the field you want to use for the lookup column. (For a query, click the Query option and then click the query.) Click Next.
- In the Available Fields list, select the field you want to use to populate the lookup colÂumn and then click > to add it to the Selected Fields list (see Figure 1). Click Next.
Figure 1 Use this Lookup Wizard dialog box to choose the field you want to use to populate your lookup column. - If you want the lookup column sorted, use the drop-down list to choose the field you selected, click the Ascending (or Descending) toggle button, and then click Next.
- Click and drag the right edge of the column header to set the width of the lookup colÂumn, and then click Next.
- In the final wizard dialog box, use the text box to edit the field name and then click Finish.
- Save the table.
Figure 2 shows a table where the Company Name field is a lookup column of unique values from the Customers table’s CompanyName field.
It is often the case that the items you want to see in your lookup column won’t exist in any field in a table or query. That’s not a problem because the Lookup Wizard also enables you to type the lookup column values by hand. Here’s how it works:
- Open the table you want to work with in Design view (right-click the table in the Navigation pane and then click Design View).
- Choose Design, Lookup Column. Access starts the Lookup Wizard.
- Click the I Will Type in the Values That I Want option and then click Next.
- For each value you want to display in the lookup column, type the item text and press Tab.
- Click and drag the right edge of the column header to set the width of the lookup column.
- Click Next.
- In the final wizard dialog box, use the text box to edit the field name and then click Finish.
- Save the table.
Technorati Tags: field value, list, access
Popularity: 3% [?]
Recent Comments