24 DecQuick Access Course – Creating a Customer Contact Database in 8 Simple Steps

Creating relational databases was once a great pain, but Microsoft Access makes creating simple databases a breeze. More complicated database is created most likely require an Access class, but a simple customer contact log database can be set up in minutes. Microsoft has more ready-made databases for common tasks such as customer data, inventory control, time and billing, costs, etc., which you can build up without ever having an Access course.

In this article, are weconsider how to build a database so that you create and maintain a record of your customer that the traces of that is invoked when talking with whom she will hold what they ordered, and every other kind of information that you need to improve can contribute, your sales and customer relations.

Once you learn how to create this simple database in Access, you must have the ability to easily set up one of the template databases, Microsoft offers its Wizard template showcase.

1. Open Accessand click on "File" icon

2. Select the "Templates on my computer" and click on "Databases" and click on the tab "Contact Management" database template.

3. Appears after clicking the "contact management" template file New Database dialog box where you name your new database file. Choose your folder, rename your file, and click Create.

4. Click "Next" on the first frame of the wizard appears. The secondScreen shows the three tables that will be included in your contacts database: contact information, call information and contact types. Take some time to get to the individual title of the table on the right side, and scroll through the list of fields on the left side to become familiar with the available data fields.

5. For this exercise, we will all these tables, three in our contact database. Click "Next" to move along in order along the third step.

6. The third part of theWizard displays a list of predefined styles, which will look like the elements of the database to determine. Click through to each individual to become familiar with the different styles. Choose your favorites and click Next.

7. The fourth part of the wizard, you can customize the look of your reports. Choose your favorites and click Next.

8. On the fifth and final frame, you give your database a name like "Contacts". For this exercise, leave the "Yes, I would likeinclude a picture of "disabled. And click" Finish. "

You have just a Microsoft Access database! In a few moments, a panel will open allowing you to enter your contact information for easy management and information retrieval of your valuable customer information.

Computer Notebook HP windows 7 quick books online

  • Share/Bookmark

Leave a Reply