Microsoft Office Tutorials and References
In Depth Information
Understanding Database Terms
Understanding Database Terms
There are lots of terms associated
with databases and just the terms alone scare
some people away from working with Access.
But it’s not as bad as it sounds. There’s just a few
basic database terms you should become familiar
with before you begin creating and working in an
Access database such as the one you see in Figure
18-1. Let’s take a quick look:
Fields. Fields are categories of information.
In the address book example, the last name
and fax number are examples of fields.
Tables. A table is a matrix, similar in
appearance to a spreadsheet, that's used to
store database information. All databases
require at least one table whereas many
databases require several tables, linked
together; such as one to store a client's
address and telephone numbers and
another one to track all the phone calls made to
the client.
Forms. A form is used for easy data entry.
Forms usually display one record at a time.
Primary Key Field. A primary key field is
where Access stores unique, one-of-a-kind
data. Every database table should have a
primary key field.
Queries. A query is a subset of data that
meets certain criteria. An example might be
a query of all clients named Smith who live
in the city of Chicago.
Figure 18-1
A sample database.
Reports. A report summarizes data in a
format suitable for printing. A mailing label is
an example of a report.
Database. A database is a collection of
information that is similar in nature. A
telephone book, a list of your videos, and an
inventory list are all examples of a database.
Objects. The general term for all the tables,
queries, forms, and reports that you create
for your database.
Records. A record is all the information
about one item. For example, in an address
book, the entire sheet of information about
Diane Koers is the record.
Search JabSto ::

Custom Search