Working with Tables
Microsoft Access allows the user to create relational databases that have tables of data. In MS Access, each table field has its own property, which is called data type. Text data type stores text or a combination of text and numbers. Number data type stores numeric/decimal information. Time data type stores data type information like date of birth. Memo data type is used for descriptive fields. Time data type stores data type information like date of birth, date of joining, etc. OLE object is used to embed an object created in another application. Hyperlink stores a link to a web page, e-mail whose values are chosen from the values in another table, query or list of values.
A table in MS Access is a database object that allows the user to store the data in tabular form. A table can be created in MS Access in three ways: Create a table in Design View, Create a table by using the Table Wizard and Create a table by entering data into a datasheet. After creating the table, the user can perform the following operations: insertion of data in the table, deletion of data from the table, modification of an existing data in the table, insertion of new fields in the table etc.
Primary key is used to uniquely identify records in a table. To create a primary key, select the field to be used as a primary key and select the primary key button in the Table Design toolbar. Select the field to be used as a primary key and select the Primary Key option from the Edit menu.