98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Access articles
Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
Mon 25th June 2007
In this Quick Access Course, we're going to review how to build a database so that you can create and maintain a record of your customer contacts that will keep track of who called when, who they spoke with, what they ordered, and any other type of information that can help you to improve your sales and customer relationships.
Once you've learned how to create this simple database in this Quick Access Course, you'll be able to easily set up any of the template databases that Microsoft offers in its template wizard showcase.
1. Open Access and click the "new file" icon
2. Choose the "templates on my computer" and click the "databases" tab and click the "contact management" database template.
3. After clicking the "contact management" template, a File New Database dialogue box will appear, allowing you to name and file your new database. Choose your folder, name your file, and click "create."
4. Click "next" on the first frame of the wizard that appears. The second screen shows the three tables that will be included in your contacts database: contact information, call information, and contact types. Take a few moments to click each the table title on the right, and scroll through the list of fields on the left to familiarize yourself with the available data fields.
5. For this exercise, we will be including all of these three tables in our contact database. Click "next" to move along to move along to the third step.
6. The third frame of the wizard displays a list of predefined styles that determine what the elements of the database will look like. Click through each one to familiarize yourself with the various styles. Choose your favourite, and click "next."
7. The fourth frame of the wizard allows you to customize the look of your reports. Choose your favourite and click "next."
8. On the fifth and final frame, you will give your database a name such as "Contacts." For this exercise, leave the "Yes, I'd like to include a picture" box cleared. And click "finish."
You've just created a Microsoft Access database! In a few moments, a switchboard will open allowing you to input your contact information for simple management and information retrieval of your valuable customer information.
Author is a freelance copywriter. For more information on an access course, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-199-access-course.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsThe Royal Society
Senior Public Engagement Officer Daniella Afeltra Stress Management, Resilience - Working from Home Gregory was enthusiastic, knowledgeable and really open. All marks are a fab trainer and created a safe space for the group to chat and share. Royal College of Physicians
Administrator Kimberley Waghorne Excel Advanced I was recommended STL from a colleague who was also very impressed with the course. I would definitely recommend STL to anyone looking for Excel training and will come back for future courses. Kingston University
Digital Marketing Manager Zoe Browne SharePoint End User Introduction Meeting the needs of the individuals as we all use it differently and we are all at different stages |
PUBLICATION GUIDELINES