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.

by BrainBellupdated