Microsoft Access
Create Menu
Table Tab
Tables are the foundation of an Access database. You can store data in Access using table. A table is a set of columns and rows. Each column is called a field and combination of fields are called record. This tab provides three options, i.e. Table, Design Table and SharePoints List or Table Template
* Table: To create table in existing database file, click on Create--> Table
To add fields to a table:
1: Click the Add New Field column label.
2: Select required data type from list box.
3: Click Rename in the Fields & Columns group.
4: Type the field name.
5: Press Enter. Access creates the field.
6: Type the next field name until you have created all of the fields in your table.
7: Press Enter without entering a field name to end your entries.
8: After you create a table, you must name and save it.
* Table Design :Table Design can make some things easier to do than other creation mode.
1: Click the Table Design Button
2: Enter the Fields and Properties
*Sharepoint List: SharePoint Site Wizard helps you to move the data from all your tables at the same time and to maintain their relationships.
Create a Lookup Column
If a field can contain a finite list of values, you can create a Lookup Column and can select the value from a list.
1: Open or Create Database Table, put field name that contains lookup contains.
2: Click the Lookup Column button in the Fields & Columns group. The Lookup Wizard appears.
3: Click the radio button next to I will type the values I want.
5: Type the number of Columns you want in the Number Of Columns field.
6:Type the values you want under the column heading.
7: Click Next. The Lookup Wizard moves to the next page.
8: Type the column label you want.
9: Click Finish. Access creates a lookup column based on your list.
What is Primary Key?
A primary key is a unique value for each row of data. It cannot contain null values. It is a field or combination of fields that uniquely identify each record in a table.
Primary Key Example:
Suppose a table, there are three fields: Stu_ID, Stu_Name and Locality. Out of these three fields, one field or a set of more than one fields can be a primary key.
Field Stu_Name alone cannot be a primary key as more than one students can have same name.
Field Locality alone cannot be a primary key as more than one students can have same locality.
Field Stu_Id alone is a primary key as each student has a unique id that can identify the student record in the table.
What is Foreign key?
Foreign key is a value in a table which points to a key in another table. The term Foreign Key refers to a field that in a table that stores values from a Primary Key field in another table, to relate the two records to each other.
0 Comments