MS Access

Working with Tables and Fields

Tables are by far the most important part of any database. Tables are where a database stores all of its information. All the other database objects queries, forms, reports, pages, and macros are merely tools to analyze, manipulate, and display the information stored in a table. Any of these other database objects are optional but without tables, a database wouldn't be a database.

If you are interested in creating your own databases, this may be one of the most important tutorial. Why? Because, at their heart, the most useful and efficient databases use well-structured tables to store their information.

This tutorial explains just about everything you will ever need to know about tables and fields: how to link two or more related tables, how to create indexes for faster performance, and how to create a primary key field, which uniquely identifies each record in a table. This tutorial also explains how to change all the properties and settings for your tables' fields, such as how they are formatted and what kind of information they can store.