Microsoft Access Relational Tables (Relationships) How to Join Tables

Learn how to make two tables relational in Microsoft Access. Create relationships between multiple tables.
Go to 599CD.com/Acce... for more free tutorials.
RESOURCES:
Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free101
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/Tech...
Learning Connection 50% OFF: 599cd.com/Conn...
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/Acce...
Twitter: / learningaccess
Email Me: [e-mail]
en.wikipedia.o...
products.offic...
microsoft.com/...

[@memelvin1]

Wish your videos were around in the mid-90's when I was just starting out in Access!! Well-done.

[@599CD]

Yes, this is from an older version of Access... but the concepts are still perfectly viable in any modern version. I'll be updating this video soon for Access 2010 or 2013.

[@cruzinsweetsntreats]

And even now 2016 to Office 365. The look of the app has changed, yet the majority of the functions have not. Though my presumption is some have been adjusted and corrected, and some requests have been implemented as well.

[@qwertyfshag]

thank you. i never understood why there would be duplicate data until i watched this

[@Tmalik21g]

Thank you so much. Seeing this has helped me do my homework and gotten me an A. Thank you so much.

[@kennzoariel]

amazing!!! ur better than my proffesor!! thanks for uploading this, it helps me a lot in my subject! thanks thanks thanks

[@599CD]

Thanks!

[@599CD]

Surprisingly, this is not the first time I've heard this. Access isn't something you can just "jump in" and teach like Word or even Excel. If you don't have a solid understanding of databases, you shouldn't be teaching it - especially at the college level. Give him the link to my KZbin channel. Tell him I can put something together for his students. :)

[@scottt2012]

Thank you for all the work you have put into these tutorials. They are very helpful and have got me off to a great start. I look forward to checking out your site and getting my company company on board with getting us some official lessons.

[@599CD]

My pleasure

[@PuffPure]

Just starting this at school, confusing stuff.. This vid helped a lot tho! Thanks.

[@radhayadav9888]

please can i have the videos for the access tutorial beginner level 2 i need those videos very much. U have done a adorable job in presenting the easiest way to learn access. the videos are very helpful... please help me

[@599CD]

You can find Level 2 on my web site at 599CD(dot)com/XZNCKQ

[@MsDogmojo]

Hi Richard, I am beginning to build a database in Access 2013. I have worked in and built databases before but they have not been very complicated. I am planning to build a much more complex database with a customer list, product list, ordering system for sales staff and design instructions for design staff, so that through the database all parties (owner, sales, design staff, project manager) can view the data they need and if information (customer data) changes than we can all make quick updates and have it updated in all places. My sales staff use tablets to enter order information and our customers sign on the tablet to approve the order. Our design Staff accesses the spreadsheet located on our dropbox account that has to be updated manually by our sales staff in order for the owner, project manager and design staff view the order form with complete instructions and the owner views the spreadsheet for sales progress, ad copy and proof status etc... I believe that Access Database would be a much better system but I have a few questions: Do we all need a full copy of Access in order to make this happen? How can we enter data into the database from a tablet using a form and then email the report to the customer confirming the order? Can the form or report accept customer signatures? Is there an app that would function as a data entry point as opposed to a full version of Access? If I can accomplish this using Access Database I will purchase your tutorials to learn how to do this but I would like to know if it is possible before investing the time.

[@599CD]

Pamela Hiebert Good questions. YES, you will need at least ONE full copy of Access to do the design work. I recommend an Office 365 subscription which is less than $10 per month. You can compile your finished database into a version that other people can USE without having to buy Access. YES, you can design data-entry forms that can be used on a tablet or web browser, but then you'll need a hosted Access solution which will cost another $10 per month or so (your data needs to be "in the cloud") or you have to set up your own server for this. Accepting customer signatures (like the UPS guy does on his tablet) is POSSIBLE, but not easy. That's a lot more advanced. If you have any more questions, contact me on my web site at 599cd.com/XCF

[@prasadavasare1]

First and second level verifier also has checklist as processor.

[@tishkorasoul4656]

Hello from 2021 :)

[@599CD]

Howdy!

[@TheViiolate]

Thanks! helped me alot! :)

[@Aleneden]

Now a quick question, if I set up my relationships incorrectly, and i don't my queries, and the data for the query doesn't show up does it have something to do with my relationships in the database systems

[@tuktaaa]

thanks!

[@prasadavasare1]

•When processor select 1st inbox he should see only 5 checks. First verifier find the record with Case#/Account#/user ID and should only view the the fields updated by processor in another form plus he has to fill below fields: 1st Level Verification Date; 1st Verifier(5 ppls); #of errors;Error description Second Verifer find the record with Case#/Account#/user ID and should only view the fields updated by processor and first verifier plus 2nd Lvl Verification Date;2nd Verifier.Pls suggest

[@JohnSmith-hl3hz]

Hey Richard! I have a table with a primary key, and want to have it be the 'one' side of a one-to-many relationship with 3 other tables (so one primary key relates to the foreign keys of 3 other tables. When I try to view the subtables in the table format by clicking on the plus sign, nothing shows up. Is it possible to create multiple one-to-many relationships stemming from one primary key in a table? Thanks!

[@599CD]

Nope. Subtables will only work with ONE child table. To do this, use a form with three separate subforms.

[@Lengjoanna]

can i pull multiple fields like name, last name and email from table 1, and have them appear on table 2, whuch also consist of additional fields like date, remarks, etc?

[@599CD]

Copy & paste

[@9324481095]

Sir How to track orders and deliveries in access??

[@599CD]

599cd.com/invoicing