The first part of creating any database program is the tables. The tables are very important because they hold the data. All of the other components (reports, forms and queries) are all luxury items in a database program; the tables are a necessity. This is why they need to be set up first.
In each table, there are columns or fields. The columns keep the data in a categorized way. For instance, a text column named “First Names" collects first names while a number column called “Phone Numbers" holds all of the phone numbers. This keeps the data consistent and organized, which makes it easier to reference or search later in the application. A useful tip for creating your own database or spreadsheet: Never put two different types of data in the same column. It takes away from the integrity of your data and makes it as useful as keeping the data in a bucket full of water.
The rows in the table are also referred to as records. This is where the individual and specific pieces of information are sorted. For example, while the column is named “First Name", the information in the rows will have values like “Jim, Jane, or Robert". This is how the forms will store the values as well.
Before getting in and setting up the tables, you will need to remember some other pieces of information first. For one, database objects are classified as tables, forms, queries, reports or modules. Another thing to know is that data is case sensitive; this means that John and john are not the same. This is a very useful piece of information to remember to avoid storing redundant data.