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 ...
19th January 2011, 10:37 PM #1
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.
20th January 2011, 08:27 AM #2
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.
20th January 2011, 10:46 AM #3
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.
20th January 2011, 03:28 PM #4
Happy to help where I can, but it has been a while since I created a front end in Access.
20th January 2011, 03:56 PM #5
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)
By muppet in forum General Chat
Last Post: 5th November 2009, 01:41 PM
Last Post: 26th February 2008, 12:07 AM
By SpecialAgent in forum Educational IT Jobs
Last Post: 14th November 2007, 12:33 PM
By tosca925 in forum Windows
Last Post: 6th September 2007, 10:37 AM
By SpuffMonkey in forum Windows
Last Post: 4th August 2007, 06:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)