+ Post New Thread
Results 1 to 5 of 5
Office Software Thread, Access Guru in Technical; I am teaching myself something new and that is Access, I can do the basics but I want to create ...
  1. #1

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,230
    Thank Post
    13
    Thanked 230 Times in 219 Posts
    Rep Power
    68

    Access Guru

    I am teaching myself something new and that is Access, I can do the basics but I want to create a complex database. I have penned it all on paper and know what I want to achieve so slowly working on it.

    Now to cut to the chase is there anyone who knows access well on here, if so let me know if you would be able to help out when I get stuck.

    It is comprising on address data, incident data and assets as such to keep it in IT terms but its a personal project for home.

    Eventually I want to create a user login page with privileges etc and look to move it to SQL but that is later.

    For the time been I just want to create it in access and play so I can learn.

    I also have a reporting section using queries which I can do. Just need to work on my designs for them and I am no good at that.

    So any help would be appreciated.

  2. #2
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    You say you are looking to move it to SQL eventually - will this still be using an Access front end?

    I used to write a lot of systems in Access but eventually outgrew it and now do everything using VB / ASP for the front end. The Access skills are still invaluable in terms of database structure, but looking back I would have been much better not wasting time getting to grips with the quirks of Access forms and reports.

    Before you get started it might be worth thinking about learning a scripting language instead for the front end.

  3. #3

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,230
    Thank Post
    13
    Thanked 230 Times in 219 Posts
    Rep Power
    68
    Hi Limbo,

    At the moment I would prefer to keep it all within access, I am not a keen scripter so do not want to have to learn something else unless I really have to.

  4. #4
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    Happy to help where I can, but it has been a while since I created a front end in Access.

  5. #5

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,157
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    Not sure what you're asking for - do you just want help making the reports look right? (You've said you can do the queries for the reports but you want help with the design???)

    If so, some samples of what you're trying to achieve would be useful (just a mock up in Word or something)

SHARE:
+ Post New Thread

Similar Threads

  1. LCD TV guru advice needed!
    By muppet in forum General Chat
    Replies: 7
    Last Post: 5th November 2009, 01:41 PM
  2. *nix Guru Required
    By ICTNUT in forum *nix
    Replies: 12
    Last Post: 26th February 2008, 12:07 AM
  3. Calling all CMIS guru's
    By SpecialAgent in forum Educational IT Jobs
    Replies: 2
    Last Post: 14th November 2007, 12:33 PM
  4. Exchange Guru's help needed urgently
    By tosca925 in forum Windows
    Replies: 3
    Last Post: 6th September 2007, 10:37 AM
  5. DNS Guru's advice requested.
    By SpuffMonkey in forum Windows
    Replies: 2
    Last Post: 4th August 2007, 06:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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