How to incorporate Contact Management into an Access database?

Posted on
6,023 Points
Last Modified:
Experience Level: Intermediate
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.

this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management.

Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments, ... and many extra bsiness tables.

This example is elaborate as I spent hundreds of hours building and refining it over the years. Don't let its complexity scare you off from Access! Even seasoned Access developers would need to spend a lot of time to understand it all. The good news is that you can also just use it! Be sure to swap out the back-end for the one without the sample data once you are comfortable ... and if importing tables into your back-end, get them from the "blank" back-end that is included as you probably do want some of the records, like for types.

While I categorized this as "intermediate", if you are a beginner, don't be shy about getting this valuable tool! One of the best ways to learn Access is to use it ... and everyone knows people they keep contact information for.

have an awesome day,

Video Steps

1. download the contact template


2. open your working database, or skip the rest of the steps and just open the contact template if you want to use it stand-alone

3. from Ribbon --> External Data tab

4. click Access icon in the Import group

5. from the dialog box that pops up, choose --> import (default)

6. click the Browse button to choose the (contact) database file

7. click OK to see a list of objects

8. choose queries, forms, reports, and modules that you want to import

9. OK to bring them all in

10. tables are in the back-end database -- so import these into your back-end, not your front-end

   if your database is not yet split into a front-end and back-end, of course, put them where you are developing

11. Alt-F11 to go to the VBE (Visual Basic Editor)

12. Debug, Compile from the menu

13. fix what is wrong and/or import things you forgot

14. Save

15. Hook into your existing tables by adding CID where it needs to go.


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month