Creating Databases and Tables in Microsoft Access 2016: A Step-by-Step Guide, Slides of Database Management Systems (DBMS)

Download Creating Databases and Tables in Microsoft Access 2016: A Step-by-Step Guide and more Slides Database Management Systems (DBMS) in PDF only on Docsity!

1. DATABASE DEFINITION (I)

Database management

software tools

Access 2016 Welcome screen

Create a database (1)

1. Click on the option Blank database…
2. Click the File menu on the menu bar and select New…

Create a database (3)

1. Database window appears
2. The primary element is Tables
3. Close database ▫ Click the File menu on the menu bar and select Close

Create a table (1)

1. Right click on Table 1, then choose Design view.
2. Click the Home menu on the menu bar and select View, then choose Design view.
3. Table design window appears – Table name : Table – Fields not yet defined

Create a table (2)

1. Define fields
2. For each field, give: ▫ Name ▫ Type ▫ Description (optional)

Create a table (2)

Create a table (4)

1. Save the table ▫ Click the File menu on the menu bar and select Save ▫ Enter the name of the table, then click OK
2. Close the table and start entering data in the table ▫ Click the Home menu on the menu bar and select View, then choose Datasheet view

Exercise 1

• Create two databases named:

▫ Cars

▫ Clinic

Exercise 2 (2)

• Create another table named Sold Cars with the following fields:
• Define License as primary key Field name Data type License Short Text Make Short Text Model Short Text Color Short Text Price Short Text Extras Long Text

Exercise 2 (3)

• Create another table named Services with the following fields:
• Define Service Number as primary key
• Close the database Field name Data type Service Number Autonumber Oil Change Yes/No Filters Change Yes/No Revise Brakes Yes/No Other Long Text

Exercise 3 (2)

• Create another table named Doctors with the following fields:
• Do not define a primary key Field name Data type Doctor Code Short Text Doctor Name Short Text Doctor Surname Short Text Doctor Phone Short Text Doctor Specialty Short Text

Exercise 3 (3)

• Create another table named Entries with the following fields:
• Do not define a primary key
• Close the database Field name Data type Entry Number Autonumber Entry Room Number Entry Bed Short Text Entry Date Date/Time