A database table is similar in look as spreadsheet, in that data is stored in rows and columns. The main difference between storing your data in a spreadsheet and storing it in a database is in how the data is organized.
Each row in a table is referred to as a record. Records are where the individual pieces of information are stored. Each record consists of one or more fields. Fields correspond to the columns in the table. Fields must be designated as a certain data type, whether it's text, date or time, number, or some other type.
Figure 1:
1. A record
2. A field
3. A field value
Now, I’m going to describe, how to create access table. Steps are given below
Step 1: First open Microsoft Access and give database name. Table is created under database.
Step 2: Select “Table Design” option from “Create” menu as given image
Figure 2:
Step 3: After selecting “Table Design” option where you set column name, data type etc., my table structure display as below image
Figure 3:
Note: Design your table with a primary key. Here I have set “Emp ID” column as primary key.
You can set property of column according your required into “Field Properties” as below image.
Figure 4:
After design table structured, save it with a unique name. Here I have given my table name is “Emp_Details” see in figure 3.
Step 4: Now open your table and fill some record as below image. Created table are visible in left hand side of your access sheet.
Figure 5:
Leave Comment