Objective
The objective of this assignment is to give the students some hands-on experience to wok in Microsoft-Access (A DBMS software).
Assignment:
You have to develop a Phone Book in Microsoft Access. Below are the details:
§ Create a table named PhoneBook with the following fields:
Name
Father Name
City
HomePhone
WorkPhone
MobilePhone
Description
§ Then create a form to enter, search and delete all this data.
Screen-shots:
This button is to find record, and this button is to delete the displayed record.
When find button is clicked, this dialog box appears automatically:
Steps to make this Assignment:
§ Create a blank database
§ Then Create a table in design view
§ Then Create a form by using Wizard
§ Then to add Find and delete buttons on the form, right-click on created form and select “Design View”. Now in the design view of form, right-click and select Toolbox and from there add the Command buttons onto the form.
o Before adding Command on the form, make sure that the Control Wizard is pressed.
After adding a Command, a wizard will give you option that what action you want to perform when this button is pressed.
Additional Help:
Here is the link of a good tutorial that will help you in learning how to create tables, forms etc in MS-Access.
http://www.teacherclick.com/access2003/index.htm
Note:
Ø Add at least 5 records in this phone book by using the form.
Ø The background picture and text color of the form does not carry any marks, so you can use the background and text color of your own choice.