Access 2007 - sample databases

Posted on 2014-08-29
Medium Priority
Last Modified: 2014-09-04
My OS is win 7 prof 64 bit and I use Office 2007.  I have agreed to do a database application for my Temple on Access 2007 and rather than reinventing the wheel, I would like to research for some sample database applications where I can use the ideas.  
Since it will be built from ground up, thus I am just starting with the basic data entry of the congregation, and then build on.  I am thinking of a relational module, and also a front end and backend design, where the dataset will be in the front end and the others will be in the backend, so as to facilitate changes and development without having to shut down the app.
  I am also looking for some basic sample forms that are well designed and pleasing to the eye.  I will add all the objects and the code if necessary.
Thank u for your advice.
Question by:jegajothy
  • 2

Expert Comment

ID: 40294004
What ever database you are planning to build will depend on what you need and want it to do.
Will this database track membership?
Inventory of property?
Mailing list?
There are many options but it depends on what functionality you are looking for.
How many users will use it? (1, 10, 100, etc)
Was this going to be accessed through a local network or on the Web?
I would recommend that you start by listing what you would like this application to do.
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 40294316
There's a lot of templates here: http://www.microsofttemplates.org/template/microsoft-access-templates

Perhaps you could modify one of those to suit your needs? Or at least review some to get some ideas of form design and such.

Accepted Solution

macarrillo1 earned 1000 total points
ID: 40301094
For a starting point you might want to look at 'Sales Contact Management' Type of database templates.  While you are not in sales you are managing information about members.

You might even want to google 'Church MS Access Free Templates' for examples of how other Churches manage their membership.

Author Closing Comment

ID: 40303627
Thank u everyone for giving me some starting point and also sample databases.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question