Exercise 4:




You have been asked to create a database for a college that is to track all of the departments in the college. You are to create the table mentioned without the benefit of the Table Wizard. The database should be entitled, “College Department,” and it should be stored in the Exploring Access folder.


a. Click the tables button in the Database window and double click the option to create a new table in Design view. To enter a few fields, click in the Field Name column and type the name of the field. Move to the Data Type column and choose the field type. The fields in your table should match those in Figure 2.1.


b. The Department is the primary key, which requires that the field begin with the letter D followed by 4 digits to indicate the store unit number.


c. Required fields include department name, faculty size, percent of faculty with PhDs, current number of students majoring in department, annual budget, phone, address, web address.


d. Set appropriate field sizes.


e. Enter in data for following departments:


Department Name: Department of Mathematics

Faculty Size: 45

Percent of PhD Faculty: 77%

Number of Students: 200

Annual Budget: 500,000 Francs

Phone Number: 00 250 520220

Email Address: mth-dean@nur.ac.rw

Website: http://www.nur.ac.rw/mth


Department Name: Department of Physics

Faculty Size: 22

Percent of PhD Faculty: 78%

Number of Students: 40

Annual Budget: 200,000 Francs

Phone Number: 00 250 530330

Email Address: fts-dean@nur.ac.rw

Website: http://www.nur.ac.rw/technol3.htm#phys


Department Name: Department of Engineering

Faculty Size: 20%

Percent of PhD Faculty: 95%

Number of Students: 50

Annual Budget: 300,000 Francs

Phone Number: 00 250 510112

Email Address: eng-dean@nur.ac.rw

Website: http://www.nur.ac.rw/eng.htm

Switch to design view. Enter in fields. Enter in faculty size, percent of PhD faculty, number of students, annual budget, and phone number as numbers. Leave Department name, and email address as text. Enter website as hyperlink.

***Enter Department Name as primary key by right clicking to the left of Department name and clicking Primary Key.


Switch to datasheet view. Enter Data as described above.

***Save by Clicking Disk and then Print clicking the Print Icon (picture of a printer).

Back to Solutions Page