Access 2007 - sample databases

Posted on 2014-08-29
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
    LVL 9

    Expert Comment

    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 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    There's a lot of templates here:

    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.
    LVL 9

    Accepted Solution

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now