Access Novice Needing to learn fast

[rmacnair]

Hi all,

Over the next few weeks and months (at least) I will no doubt be frequenting this forum on a regular basis.

I have a strong background in using Excel and in particular applying VBA.

However, recently I have undertaken a project for a company in the North East of England to produce an all inclusive training matrix for their staff across a number of offices. I suggested using Microsoft Access stored on a SharePoint style server as a way of centralising the data and reducing human error and then using a VBA driven Excel Workbook to push/pull data on the database and manipulate and display it how I like.

I apologise for my ignorance as I have only ever used Access for 1 month over 10 years ago.

 

[rmacnair]

rmacnair,

If you take on this project, forget everything you know about Excel for a month or so. Google Access table normalization. Read about it and watch Youtube videos, whatever it take to get the concept. Then put together some field lists on paper. Ask for help on how to construct your tables. This would be a good first step. Good luck with your project.

Thanks,

I will do that. I've always built tables in excel in a structured manner, using validation lists from lookup tables, defined ranges etc. so hopefully it will help.

Unfortunately I only have a month or so to get the first phase up and running alongside my normal 9-5 day job so time isn't all that available. So far today I've sussed out the basics of Tables, Relationships and using SQL and the integration in to VBA using ADODB.