Page 79 - Computer Class 07

6 6 6 More On More On More On

Microsoft Access 2016
Microsoft Access 2016Microsoft Access 2016

Write the uses of Microsoft Access in your own words.

________________________________________________________________________________
________________________________________________________________________________

________________________________________________________________________________

________________________________________________________________________________

________________________________________________________________________________

Primary Key

Microsoft Access table has a field or set of fields that uniquely identify each record
stored in the table, it can be set as the primary key. The selection of a primary key is

one of the most critical decisions you will make in the design of a new database.

Primary keys are fields or fields with values that are unique throughout table when
building an access database. Primary keys can be used to refer to entire records, each
record has a different value for the key. A table can only contain just one primary key.

MS Access will either automatically create a primary key field for you when you create
a table, or you can specify you want to use as the primary key.

Function of the Primary Key

The major function of a primary key when creating database in Access is to

implement relationship between tables in a relational database, you can not declare a
foreign key in a table Q to relate with table R unless you have defined the primary key
in table Q. Primary key allows you to create a unique identifier for each row in your

tables. It is important because it helps your link your tables to other tables
(relationships) using primary key as links.

Primary keys also provide a means to specifically and uniquely identify a row of data
(or record) in a table when building Access database.

For example : A Customer ID field in the Customer’s table might also appear in the

Computer-7 79