Thanks for all of your help. Much appreciated.

Good point.

Okay so something like MS Azure as a cloud based Data Warehouse or an instance of Sql Server on a networked server, instead of my machine.
Access...

Thanks, fairly certain I could learn the Access element to this. Any decent resources available?

One additional issue if I am giving users a front end to populate a...

If I was joining tables, I would typically only be looking for relationships between people or companies.
For the career history tab I would look at things like time in...

Yes it is an error, that was me trying to copy and paste to speed things up. 

I can add data validation to ensure that things are entered correctly....

A few example tables attached. (this is just a couple of rows of dummy data for each example table). There would be a few more columns for each table. There...

Thanks, sorry the code was a bit of mess where I was changing things around. Sorted now, thanks for your help.

Thanks for your help all of you. Am now in.

Much appreciated.

John Mitchell-245523 (1/6/2017)

---

You can install it on its own - it's a separate product from SSMS these days. If you're installing on a PC, it needs to be Windows...

Ah no, I didn't install SQL Server? Should I delete the whole lot and start again or can I install SQL server on its own?

Dot is fine....I'm in the UK 🙂

At the moment it is just connecting, I reckon I could do the restore once I am beyond that.

I'm a bit confused as to...

Ah okay, that would require me to get past the connection screen wouldn't it.

At the moment, I just get an error message as the connection is looking to point...

It does end .bak, how do you restore a file?

Thanks for that. Sorry about posting on the other board, I posted before I had seen your response.

Ah sorry I wasn't clear, I have the local version of SQL Server 2016, it's just that the Azure DB I was connected to has now run out (free trial...