Microsoft Office Tutorials and References
In Depth Information
Section 4: Creating a desktop database
4
Creating a desktop
database
In this section:
A desktop database uses tables to hold your data and is stored on your
Creating a blank desktop database
Creating a table in design and layout
views
Working with data parts in layout
view
Creating a table by using application
parts
Adding a primary key
Improving performance by indexing
data
Validating data in a field
Formatting a field
Recording changes to text and rich
text formatting
Creating relationships by using the
Lookup Wizard
Viewing and adding relationships
local computer or network. The data is displayed in rows (horizontal
layout), with each row including a list of column or field names (vertical
layout) like a worksheet. Using database tables differs from using several
worksheets in a workbook. Generally, you will find it more natural and
beneficial to create additional tables than to create more worksheets. Also,
the rules for data consistency in any column are more strictly enforced in a
database, which helps you to improve the quality of the data that you are
recording.
Each field in the table can be of a different data type, depending on the
data to be held. Storing data in the correct field type is important because
you can take advantage of special features in the database—for example,
displaying a date picker when working with date data, or validating that
sensible data is being entered for the chosen field type, or relating the
data in one table to a list of values in another table.
A database normally consists of more than one table, and having the
tables correctly related to one another will save you a lot of subsequent
work. An invaluable tool in Access is the Lookup Wizard, which can
automatically build the required relationships between the tables.
Search JabSto ::




Custom Search