Microsoft Office Tutorials and References
In Depth Information
Access Data Types
Access Data Types
Sometimes, you may apply a change that causes a bit of a problem. You could try to
change the data type of a field so that it stores numbers instead of text. In this
situation, you won’t discover the problem until you close the table or switch back to the
Datasheet view, which might be a little later than you expect.
If you’ve made a potentially problematic change and just can’t take the suspense,
you’re better off applying an update immediately, so you can see if there’s a problem
before going any further. To do so, click the Quick Access toolbar’s Save button (it’s
the diskette icon in the Access window’s top-left corner), or just use the keyboard
shortcut Ctrl+S. Access applies your change and then saves the table. If it runs into a
problem, Access tells you about it (and lets you choose how you want to fix it) before
you do anything else with the table.
Access Data Types
Design view is a powerful place for defining a table. Design view lets you tweak all
sorts of details without jumping around the ribbon (as you would if you were
creating a table in Datasheet view).
One of the details is the data type of each field—a setting that tells Access what
type of information you’re planning to store in it. To change the data type, make a
selection in the Data Type column next to the appropriate field (Figure 26-6). Here’s
where you separate the text from numbers (and other data types). The trick is
choosing the best data type from the long list Access provides—you’ll get more help in the
following section.
Figure 26-6:
To choose a data type, click the Data Type
column next to the appropriate field. A drop-down
list box appears, with 12 choices.
Search JabSto ::




Custom Search