Creating Access Database - Part 1 (Planning a Database)

Explaining the value of a multi-table database by looking at tables of data in a spreadsheet prior to getting into Access.

[Proximian]

You may very well be the best teacher in explaining databases that I have found in many years. I am currently building a big database with lots of tables and wanted to refresh my memory. I did not realize how much I forgot and I am basically learning everything all over again. I am so glad I found your videos. Thank you very much for sharing your knowledge.

[MIKETAYLOR]

I'm a college student and you did a better job explaining this than my instructor did!
AWESOME JOB!!! THANK YOU SO MUCH

[planiolro]

Awesome video because the explanations given during the clip. For those who are not so confident with access the explanations are much appreciated. I am looking forward for the next parts.

[MIKETAYLOR]

I'm a college student and you did a better job explaining this than my instructor did!
AWESOME JOB!!!

[jeffreyb]

Ralph - Thank you very much for posting the training series in Access Database. I'm taking an online course as part of my MBA, and the training THEY provided was apparently missing essential information on setting up multiple tables with the relationship set-up. Your videos made the concept clear. Well done!

[TheValdamar]

I have seen part 1 to 6 and I must say its awesome. Thank you so much for using your time helping novices like me.

[bsbeitler]

Good clear video explaining one of the most common data migration processes when creating a database (from Excel to Access).
It gives the viewer the understanding and option to go with the 'Flat File' v 'Relational Database - RDBMS' approach using one or more tables.
You will need to look at part 2 for the next step or find an free online user reference

[zara]

If only I found this before designing my own database....
Your explanation is so good, I understand my mistakes now..
Thank you very much...
T_T

[davidbrand]

Should watch the next few in the series as he goes into Access Databases. This one is designed to show the limitations of Excel and where Access comes into play.

[eevileva]

Excellent tutorial! Thank you. This was very helpful.

[TheNonforprofit]

Hey so I work for a non for profit and I'm trying to create a MS Access database to track our members. I Love your videos except I'm having trouble with relationships with tables. Could you help me out? We need to track Members personal info (name, phone, address) and also membership dues (joined date, membership exp date).

[BldingMn]

he really has a crush on carla, doesn't he xD

[arusid]

yes ! indeed very nice explanation . Thank you

[alexmiller]

As the planning is mostly done on a spreadsheet, you can just import this into some tool like Ragic and get your online database. Could be easier.

[Insken]

im trying to create a Sales and Inventory system for a Pharmacy Store this could help to some basics and also naming tables...

[MrNotubo]

Why is the combo box use to look up records not functioning in Office 2007? it works in office 2003.

[Sebastien]

What about if the employee did the same job many times in the past? (In that case, we may see the JobName repeated many times)

[SonoftheLivingGod]

what kind of database structure does the fbi, cia, police use? With images of the "prisoner" fingerprints, and you just search for something and all that is relevant comes up?

[Murphy]

This is great! now I can keep track of all the slaves in my slave plantation

[McGavel]

One-to-many, private key to foreign key.