5.11 single-table databases

5.11

1
--AutoNumber-- An AutoNumber field creates unique values automatically when Access creates a new record. The AutoNumber field is primarily used for Primary Keys in Access.

--Text-- A Text field can contain values that are text, numeric or a combination of both. A text field can contain a maximum length of 255 characters.

--Memo-- A much larger version of the text field, allowing storage of up to 2 GB of data. A new feature of the Microsoft Access Memo field is that it now supports rich text formatting.

--Number-- The Number field can store numeric values up to 16 bytes of data.

--Date/Time-- The Date/Time field allows storage of date and time information. The date/time field now also includes the Auto Calendar feature.

--Currency-- The Currency data type stores values in a monetary format. This can be used with financial data as 8-byte numbers with precision to four decimal places.

--Yes/No-- Boolean data storage of true/false values.

--OLE Object-- The OLE Object field stores images, documents, graphs etc. from Office and Windows based programs. The maximum data size is 2 GB, although this will slow down a database.

--Hyperlink-- The Hyperlink field type is used to store web addresses. This has a maximum size limit of 1 GB of data.

--Attachment-- The Attachment field type is used to store images, spreadsheet files, documents, charts and other types of supported files to the records in your database. This is a new feature that has been introduced with Microsoft Access 2007.

2) Data validation only controls the format. Not what you type in.


3) It is easier to use it can be restored if damaged or corrupt where as paper can be damaged easily or lost.