In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
View data types by using commands on the Datasheet tab The data type set for each table field provides the first level of control over what you can and cannot enter into a field.
In some cases, a data type setting prevents you from entering any information at all.
If someone tries to enter text in that field, Access displays an error message and will not let that user save the changed record, a step that helps protect your figures.
Show me how to view data types Access now provides two ways to view the data types for a table field.
When you design a database table, you select a data type for each of the fields in that table, a process that helps ensure more accurate data entry.
For example, suppose you specify the Number data type for a field because you need to calculate sales figures.
The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.
Text fields accept either text or numeric characters, including delimited lists of items.
You can use the commands on the Datasheet tab, or you can open the table in Design view.
The following sets of steps explain how to use both techniques.
You use this type of field when you want to display data from a file created in another program.