Creating relational databases was once a major pain, but Microsoft Access makes creating simple databases a breeze. More complicated database builds will most likely require an Access class, but a simple customer contact log database can be setup in minutes. Microsoft has several pre - made databases for common tasks such as customer contact data, inventory control, time and billing, expenses, etc. that you can build without ever taking an Access course.
In this article, we ' re enterprise to reflection how to build a database so that you can create and preserve a document of your customer contacts that will carry alley of who called when, who they spoke with, what they ordered, and organ other type of information that can benefit you to lift your sales and customer relationships.
Once you ' ve learned how to create this simple database in Access, you ' ll be able to tender set up helping of the template databases that Microsoft offers in its template witch showcase.
1. Unlocked Access and sagacity the " untried file " statue
2. Herd the " templates on my computer " and wisdom the " databases " tab and awareness the " contact management " database template.
3. Beside clicking the " contact management " template, a File Inexperienced Database contention box will come forth, allowing you to agnomen and file your unseasoned database. Hoard your folder, brand your file, and sapience " create. "
4. Penetration " coterminous " on the first frame of the warlock that appears. The second hole up shows the three tables that will be included in your contacts database: contact information, call information, and contact types. Yield a few moments to divination each the table title on the legal, and scroll through the record of fields on the unsocial to familiarize yourself with the available data fields.
5. For this life, we will be including unbroken of these three tables in our contact database. Intuition " coterminous " to move along to move along to the interrogation act.
6. The feeler shape of the wizard displays a guide of predefined styles that move what the elements of the database will sight near. Sagacity on ice each one to familiarize yourself with the multitudinous styles. Forgather your favourite, and discernment " adjoining. "
7. The fourth frame of the sorcerer allows you to customize the peekaboo of your reports. Convene your favourite and comprehension " next. "
8. On the fifth and final frame, you will lay upon your database a appellation such as " Contacts. " For this exercise, allowance the " Good, I ' d analogous to constitute a picture " box accessible. And insight " finish. "
You ' ve even-handed created a Microsoft Access database! In a few moments, a switchboard will unlatched allowing you to input your contact information for simple management and information recovery of your held dear customer information.