Microsoft Acces Template
 

A Customer Management MS Access Database Template

 

News: Version 2.0 is shipping now ! With online help,and lots of new improvements

What do you get ?

The product you get is a Customer Management Microsoft Access Database Template with a pdf documentation.

You can start a project with this database and use it as it is or you can modify it to suit your needs. You could also import the desired objects into your project to perform what you need. The code is commented and you can easily follow the data flow. You will save a lot of time plus it’s a great way to learn different techniques regarding Microsoft Access queries, forms, reports and vba programming. You have access to all the source codes. It’s yours to use in your project. Plus you get a 1 year's worth of free upgrades when improvements and/or corrections are made to the software.

It runs

  • clients (with billing address, delivery address, contacts, tasks(with a task summary on the main panel, notes)
  • suppliers
  • products (with minimum and maximum quantity, quantity in stock, value and a sub-window showing the products to be ordered)
  • inventory
  • invoices (with discount field, delivery fees field, two tax fields)
  • orders (with quantity ordered and delivered, a sub-window showing the products to be ordered)
  • mass mailings (to be used with MS Outlook )
  • and much more ...

You will learn:

  • How to use a scheduler in the form of a calendar
  • How to design a security system (With a login and password form)
  • How to use a calendar
  • How to create a rolodex manager for customers or anything you like
  • How to send emails from access (via Outlook)
  • How to create a startup form 
  • How to manage a To Do list
  • How to manage reports and labels
  • How to use a combo-box, a list-box, a switch box
  • and much more ...

Click on an image to enlarge ...

 

Main form

 

Product Form

 

Report Manager Form

 

Invoice Form

 

Task Calendar Form

 

 

It comes in an .mdb format. You have access to all the objects in the database container. You can use them in your own project.

Remember, you can take this database and quickly learn from it, improve your productivity, reduce your work load and be more competitive.

Download the free trial

Buy it now

 

Home
◦ C.R.M.
◦ Schedule management
Services

 
 

Microsoft Access is the most widely used database system in the world. More then 40 million companies use it. When correctly used, Access offers an excellent alternative for the bigger database systems like Oracle, DB2 or SQL Server. When you have a lot of users connected at the same time to a database (50 and more...), Access is not a logical choice but for up to 20 users it's the most economical solution because of the rapid development environment.

The use of Microsoft Access helps reduce development costs and time and you don't need a big technician team to take care of the database. Just make periodic backups like for any other database system.

For some persuasive arguments on why Access is "right sized" for a lot of jobs, read the white paper "Database Evolution: Microsoft Access Within an Organization’s Database Strategy" by Luke Chung, president of FMS, Inc.