Build a Clickable Customer List Database in Access

In this Microsoft Access tutorial, you will learn how to build a customer list for your database. This will be a continuous form listing all of your customers. You will learn how to double-click on one of them to open up that specific customer's record. This template includes an 18 minute video tutorial and a full editable template.

Videos

•  0. Introduction (3:00) - Free
•  1. Build the Database (18:49) - Paid

Topics Covered

• Continuous Forms
• Form Header & Footer
• Allow Edits, Deletions, Additions
• Open a Form and Find Specific Records
• On Dbl Click Event
• DoCmd.OpenForm

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable version of the template which will let you see it work in action. Sample database available for 64-bit version of Access only.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit versions of Access.

Links

If you would like to learn more about Microsoft Access, check out these additional resources:

• Additional Microsoft Access Templates
• Free Access Beginner Level 1 Course - over 4 hours!
• Access Beginner 2 Course for $1
• Relational Combo Boxes TechHelp Video

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. 

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #templates, relational combo boxes