Hello and welcome to CertForums.co.uk, here we host free active certification forums with links to the best free resources for Microsoft's MCSA MCSE MCDBA Cisco's CCNA CCDA and CCNP, and CompTIA's A+ Network+ i-NET+ and Security+ certifications in the UK. If you wish to post or use other advanced features you will need to register first. Registration is absolutely free and takes only a few minutes to complete so sign up today!
If you have any problems with the registration
process or your account login, please contact support
I'm the general IT Manager for a smallish finance company. One part of the business currently have their own database which is maintained very occasionally by one of the directors brothers!
He will be retiring this/next year so they are looking for someone to maintain the current one or create a new one. I would love to build the DB myself but would like to know if anyone can recommend some books for me. The DB is currently built in access which I have some experience with but not enough to confidently build a DB or maintain one.
Heh, I suppose this is where it gets tricky then. The current DB is built using Access 2003. I use open office but have a spare 2003 licence at the office.
What other options are available . . and which of the many access books would you recommend. I guess the route i could go down is maintain the access db and migrate it to something better at a later date.
Hi there,
I am always attracted to anything to do with MS Access as it is the application that I started out on. I see that you are UK based so there will be a tech. near you. A while ago I took a series of MS Office based courses offered by Learn Direct. The version that deals with Access is a three part course. At the time these were subsidized by the UK Govt. and I paid a nominal fee of £2 for each course but they may be more expensive now.
As for the courses they were excellent as they demonstrated enough technique to get you started whilst explaining the main concepts behind relational databases, the logical table structure, referential integrity, normalized forms and the rest.
As for Access itself, it is a good tool for smaller databases but has a file size limitation of 2GB (at least it did the last time that I looked). In practice I found that after much over 1GB things start to slow up. If your company is running Server 2003 I believe that SQL Server comes as a part of the bundle. There are tools to migrate an existing DB from Access to SQL Server. As you mention OpenOffice you may be working with UNIX so open source MySQL may be the better choice; it is very like SQL Server from the developer’s point of view.
One final comment; you interact with referential databases using Structured Query Language (SQL). Many DB management systems offer a tool to build queried using a GUI and called query by example. These are a great aid to productivity, but do not become dependant upon them as they will not always be appropriate or even available. When you start out making queries always check the SQL pane to see what you have done using QBE and try to understand it. SQL is simple enough once DB theory is understood and you will soon pick it up.
cheers folks. I have ordered the O'rielly database design and programming book today(cost nothing thanks to a few left over gift vouchers). I will go for the Microsoft Press books when i'm sure when the users versions of office will be updated.
I'm just wondering now how best to go about sorting it all out! Do I continue and use Access to maintain their current database and make the changes the guys want, or do i just use it to maintain and work out how to use another DB.
I also have another project coming up for a fairly simple sales figure database which will be used mostly for reporting rather than being user friendly. Not sure if anyone has any ideas on what would be a good route for me to go down for both? (Sorry for asking so many questions!)
Last edited by Metalstar : 27-May-2008 at 09:14 PM.
25-May-2008, 04:17 PM
Linear Mode
Similar Threads