How to Create a Relational Database Address Book
Microsoft Office Access is used to create many different forms of databases. These may be relational or even object-oriented databases. You can create databases for anything from inventory management to something as simple as a list of your favorite CDs.
You can also create a relational database to use as a computerized address book. And, thankfully, you do not have to be a computer expert to create this database. You can use the Access wizard to help with each step.
Instructions
-
-
1
Start Access on your computer and allow it to completely load. Select "New" located on your toolbar.
-
2
Select "On My Computer" underneath Template in your New File task pane. Select "Relational Database" on the Database tab. Select "OK."
-
-
3
Enter a name for your database in the File New Database dialog box and select "Create."
-
4
Select "Tables" from the Objects tool box. Select "Create tables with wizard." Choose ""Contacts"" under sample tables in the Tables Wizard. Select "First Name" and click on the arrow pointing to the empty list box. Do the same with each type of data you want to store in your address book. Once you have selected all of the data types (for example, last name, phone number), select "Finish." Your table has been created.
-
5
Select "Forms" from the Objects tool box. Select "Create forms with wizard." You need to add all of the same data types you did for your table in step 4. Just click on the data type you want, then click the arrow pointing to the list box. Once you have added all of the data types for your form, select "Finish." Your form has been created.
-
1