Introduction to Database Management Systems

Appendix C

Database Management with Access

C.1 BASIC TABLE DESIGN

When we start the MS-Access software, the screen shown in Fig. C.1 appears. Using this screen, we can create a new database table, or open an existing one.

Fig. C.1  MS-Access: The first screen

Let us begin with a blank database, as creating it would teach us many simple concepts. Therefore, we shall select the radio button Blank Access Database, and click on OK. MS-Access would prompt us for the desired name and location of the database that we want to create. The result is shown in Fig. C.2.

Fig. C.2 Creating a new database

We can change the database name and location (directory/folder), ...