Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Which access template (2003)

    I've attached a single entry from an Excel file I've been keeping for many years - it obviously should be an Access database. Since I have absolutely no time to create the elaborate database I need in Access, I'm hoping someone out there can tell me which, if any, of the downloadable Access database templates might be suitable for this purpose - I understand I'll have to tweek it to fit my needs, but a base would save me days.

    Thanks in advance

    Aunt Linda

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Which access template (2003)

    It looks to me like the only Microsoft template that is likely to be even close is the Asset Tracking database that is part of the Access installation, or can be downloaded from the MS website. But it looks like overkill to me - what you appear to need is a Property table and a Buildings table (you could split that into temporary and permanent - but you could also simply put a flag to indicate the type of building) and some forms to display the information. You may have some fields in the Building table that only apply to one building type or the other, so you might want to have two separate forms just to prevent nonsense information being entered. If you want to get more sophisticated and track the architectural firm that designed each building, or the contractor that built or manufactured each building you could add tables for tracking companies and contacts.

    As a general observation, I usually find that starting with a template has some drawbacks - you often have lots of stuff you don't need, and you don't have an understanding of how it was constructed initially. That often leads to inefficient or even bad designs in the long run - and it requires you to do a fair bit of studying to figure out how the template was designed initially. There are some specific problems that have to be solved over and over again, and in those cases they can save you a fair bit of work, but in general I start from scratch - just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>.

    PS: It took be a bit to find, but <!profile=SteveH>SteveH<!/profile> came up with this link Database Models some time ago in response to a similar question.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which access template (2003)

    I think your opinion is absolutely correct - I was just hoping for a miracle - however, I haven't had to time really check out the link you sent - maybe I'll find that miracle in there somewhere!

    You're advice is duly noted and will be heeded - thanks alot. Have a good one . . .

    Aunt LInda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •