How To Design An Access Database: Take The First Step And Plan It

How To Design An Access Database: Take The First Step And Plan It

It’s that time of year again where new students need ‘real world’ induction and training and that sometimes includes Microsoft Access.

But the very first step in learning how to use MS Access is to have a database application in mind and in order to know how to design an Access database.

Here’s a quick (four and half minutes) video tutorial to help explain the concepts. Take a look…

How To Design An Access Database: Take The First Step And Plan It

You will find most database systems are typically based around an entity or profile which needs to be tracked and in this video it highlights customers in a book store wirth orders – just expand this into your own area of interest like warehouse distribution, production and manufacturing or the finance sector.

how to design an access database (planning)

 

 

 

 

 

 

 

 

 

Any business process is essentially modelled on the same or similar concepts. I have used a sales orders processing system which has customers, suppliers and products for my training sessions and have written seven articles on MS Access database design by scoping out the process from start to finish.

You will note that most of the time in early stages it’s a pen and paper exercise before even getting your hands dirty in Access.

If you need to really immerse yourself into more detail and don’t really have the time to attend formal training then take a look at my eBook (and others available too) on How to Build An Access Database which is a real time save and great value for money.

One Reply to “How To Design An Access Database: Take The First Step And Plan It”

Leave a Reply

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