Page 28 - ModularV1.1 _c8_flipbook
P. 28
SETTING A PRIMARY KEY
A primary key is a field in a table that uniquely identifies each
records in the table. The primary key field does not accept
duplicate or null values. A table can have only one primary key.
Follow these steps to set a primary key in a table:
Step 1 Open the table in the Design view.
Step 2 Right-click on the row header of the field on which you
want to apply primary key. A context menu appears.
Step 3 Select the Primary Key option. A key icon will appear in Setting a primary key
front of the field name.
Recap
MS Access 2010 is an easy-to-use Relational Database Management System developed
by Microsoft.
The data types are used to declare the type of the fields in the database.
There are two types of views in MS Access: Datasheet view and Design view.
Exercise
ü
A. Tick ( ) the correct option.
1. Which of the following is not a relational database?
a. MySQL b. MS Access c. MS Excel
2. Which option is present on the left side of the Access window that displays the names of the
objects used in the database such as Table, Query and Form?
a. Navigation pane b. Work Area c. Ribbon
3. Which of the following data types is used to store a large amount of text or a combination of text
and numbers?
a. Text b. Memo c. Number
4. In which of the following views, the records are not visible?
a. Datasheet b. Template c. Design
5. Which of the following data types are used to store currency values?
a. Money b. Currency c. Memo
B. Write ‘T’ for true and ‘F’ for false.
1. The Field Properties Pane is used to set the properties of the fields
defined in the table. ............................
2. Navigation Pane is present on right side of MS Access window. ............................
26 Modular (Ver. 1.1)-VIII

