Microsoft Access Database: Working With A Database You Didn’t Create

Microsoft Access Database: Working With A Database You Didn’t Create

Working with Microsoft Access database is a skill to have and makes you stand out from the crowd of advanced Excel spreadsheet users and those wishing to step up and move into the world of MS Access will probably start by inheriting other people’s databases.

So what’s the first thing you need to do if you are given someone else’s Access database?

microsoft access database working with a database you didnt create

I wrote another post about a couple of years ago which addressed the challenges of inheriting other people’s Microsoft Access databases and it’s worth a revisit.

Microsoft Access Database: Working With A Database You Didn’t Create

The official Microsoft website has useful tutorial which steps you through some the tasks and then tests your knowledge; it’s called work with a database you didn’t create. It uses version 2003 but that doesn’t matter as the principles are of course identical!

This course includes a three self-paced lessons and three practice sessions for hands-on experience with a short test at the end of each lesson (tests are not scored). There is also A Quick Reference Card you can take away from the course.

You can jump to different sections (there are 27 steps) and some of the features maybe better served using the later versions too.

Not all the objects it suggests is necessary especially if you have a good level and knowledge of Access and can either use VBA code or tweak SQL to your advantage.

But it’s essential to master the RDBMS (relational database management system) if it exists and if it doesn’t, well that just may well trigger a real rethink and possibly a new design database is in order.

If you need help to develop a new database, build forms, manage table structure and ask the correct query questions, then take a look at the various Microsoft Access database eBooks I have to offer which all come with a guaranteed ‘no questions asked’ money back policy.

This entry was posted in Database Theory, MS Access, Utilities and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.