REFLECTION WEEK 13 : DESIGNING MS ACCESS

Assalmualaikum WBT and salam sejahtera,

This week, En. Abd. Razak shows examples of databases that have been built using MS Access. With detailed descriptions of how to make Field catalog database that will be produced by our group will be described. Then, some Table will be generated to separate the raw data for the material with the publisher for details.

Field to be involved in Material Table are:

1.Title
2.Author
3.Additional entries
4.Edition
5.Publisher
6.Publish year
7.ISBN / ISSN
8.Call number
9.Type of material
10.Physical description
11.Subject 1 & 2
12.Note

Field to be involved in Publisher Table are:

1.PubID (code name publishers )
2.PubNAME (full name of the issue)
3.PubPLACE (Place published)

The two tables (materials and publisher) produced will be correlated with Relationship to facilitate data entry, especially for materials with the same issue may be associated with other materials.