I have a potential job that I want to apply for and I need a rudimentary knowledge of Microsoft Access. Anyone know where i can Download it so I can familiarize myself with it?
It's apart of the Microsoft Office package so I would imagine you'd have to buy it... http://www.openoffice.org/product/base.html This is a similar program that's free. I use Open Office on my computer instead of Microsoft Office because it's just as good but the cost is right (FREE!)
I don't know where to get it, but once you do, remember this piece of advice. SAVE YOUR WORK. Access will not prompt you to save your work when you are done and go to close it, it will just close and you are f***ed. Take it from someone who knows.
You may be able to download a 30 day trial from Microsoft. But do you know what version they (the new job) use? Diifference may not be huge but there will be some. OpenOffice is good too but again it does some things differently too though it can open and save to MS formats for the spread sheet and word processor, not sure about the database. Try MS's site for free Office suite trial. make sure you get the version that includes access as not all do. There may even be a stand alone Access trial down load. They also have tons of online tutorials. If you use it past 30 days guys in black suits and sun glasses beat you with rabid animals tied to sticks. The wombat is the worst... Good luck with the job.
its because its a database, so like a database you have to commit any changes you make.........................
If you're doing any serious database programming, you need to know Boyce-Codd Normal Form, aka Third normal form, in order to create simple relational databases. http://en.wikipedia.org/wiki/Boyce-Codd_normal_form http://www.datamodel.org/NormalizationRules.html http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/rm8.html A little SQL will come in handy for more complex jobs as well: Here's a tutorial: http://www.w3schools.com/SQl/default.asp http://en.wikipedia.org/wiki/SQL MS Access Assistance: http://www.blueclaw-db.com/download/
What are they expecting you to do in Access? As Tokyo says, if you're designing databases and tables, you probably need to understand third-normal form. If you're generating reports for existing databases and tables, you probably need to understand sql. If you're creating forms and programming a front end to the databases and tables, you probably need to understand visual basic and sql. Access is really just a lightweight database/gui designer/report generator built into one tool (similar to foxpro that microsoft bought out years ago), but it's not industrial strength for client-server scenarios with more than a few users.
