Access Training

[amywilson95]

Hi,

I am looking for some online Access training, can anyone help me?

Thanks,
Amy

[ItsMe]

There are many options. Depending on various factors you will want to choose carefully. I would, first, determine what experience you currently have and also what the scope of your project(s) will be. For instance, I use my experience in various fields when using Access. However, you may not need to understand something like computer networking or Microsoft Server in order to accomplish your goals.

At the bare minimum you will need to understand Relational Database, Normalization Rules, and how to create an Entity Relational Diagram.

[amywilson95]

Thanks.

I am a beginner to access, so I am particularly interested in training on queries, data tables, forms etc.

[ItsMe]

Regardless of anything, I would suggest learning about Relational Databases, first. Depending on how complex your projects will be, you may need to learn some advanced database theory. There is this thing called business rules. It takes time to recognize and understand what business rules may exist in a given circumstance. The more complex the business rules are, the more you will need to understand Relational Database.

So it is a double edged sword, you need to understand how complex your database will be before you understand the nuances that dictate how complex a database is. Perhaps a simple explanation of what you want to accomplish in Access would help.