Large updates become much easier to perform when you understand some of the basic principles of database design.An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.
Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
If you format the field to show a list, you can select either Yes or No, True or False, or On or Off from the list, again depending on the format applied to the field.
You cannot enter values in the list or change the values in the list directly from a form or table.
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 can enter large amounts of text and numeric data in this type of field.
Also, if the database designer sets the field to support rich text formatting, you can apply the types of formatting that you normally find in word processing programs, such as Office Word 2007.