Tables   -   What is a table?   


  Tables

    What is a table?

    Table design

    Field properties

    Inputting data

    Relationships

    Tutorial


 Queries

 Forms

 Reports

 Macros

 Modules
In your database, this really is the source of all your information. A table consists of information placed in row entries with each entry possessing one or several fields.

Fields and Rows
Row entries and fields are the main components within a table. A row entry is representative of one item within the collection of information that you are recording for your databases. Fields are the attributes or characteristics for each of the row entries. Fields are usually user defined so that information that the user may want to track for each item is recorded.


You want to make a database of books within your library. For this collection, each row entry would be one of the books. The fields for each row entry might be Title, Author, Publisher, or any other type of information that a book might have.



A table is vital to your database. Without a table, functions like queries and reports can not be performed.


Access is a copyright of Microsoft, Inc. No infringement of those rights is intended.
Questions or comments -- Contact the author