Learn Access -4- Tables and Relationships
Channel: LearnAccessByCrystal
Date: 2013-07-08

Learn Access! The most important part of an Access database is the structure ... Tables, Fields, and Relationships.  In this lesson, we start with 3 tables from the previous lesson and we create 7 more. As we go, we build relationships using the Primary Keys and Foreign Keys in our design, and layout the Relationships diagram. Learn Access by focusing on the structure first ... the rest is downhill if this is done right.

Key fields (Primary Keys and Foreign Keys) have the same name in the main table and in the related table so that it is easy to see them!  Key fields are listed at the top of the field list.

Add Tracking Fields to your tables ... very easy to automatically store the date and time a record was added by using the Now() function as the Default Value for a field.

Create AutoNumber values using an Append Query.

Use an InputMask to display Phone numbers with symbols.

Switch between Tabbed Documents and Overlapping Windows by changing the Access Defaults.

Disable AutoCorrect, which is a multi-step process.

Use icons on a customized Quick Access Toolbar.

Learn how to layout the Relationships Diagram so that it is very easy to see what the database is tracking and how tables are related.

~~~~~
Captions: coming! If you are interested in translating, please contact me.

~~~~~
featured music:

"Colors of the Lonely"
- JD Live (Jerome Dixon from Houston)
full song: http://www.youtube.com/watch?v=08XQjgGTbis

http://myspace.com/jdlivepro
http://www.youtube.com/user/jdlivepro

Looking for a song to commemorate a special occassion, or great entertainment for your next party? Contact JD at jdlivepro@yahoo.com

~~~~~
related video:

Customize the Quick Access Toolbar
Tip: Add Save As Icon to QAT (cc) - Français, Dutch, Deutsch, English 
http://www.youtube.com/watch?v=WrG4f_TElTE

links:

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html

Database Issue Checker Utility, by Allen Browne
http://allenbrowne.com/AppIssueChecker.html

Failures caused by Name AutoCorrect
http://allenbrowne.com/bug-03.html

~~~
more Access Tutorials
http://www.everythingaccess.com/tutorials.asp

*****
FREE book on 'Access Basics'
(even if you are not a beginner, chances are you will discover something new)

http://www.AccessMVP.com/strive4peace

*****
contact me for free remote Presentations to User Groups and Organizations

happy learning!

______________________
Intro and End: Microsoft Office PowerPoint.
Screen-shots: Techsmith SnagIt.
Screen capture and production: Techsmith Camtasia
Audio edited with GoldWave
~~~~~~~~
Capture and Production Settings:
Video: H.264, 24-bit color, 30 fps, 1280x720
Audio: PCM, 44,100 kHz, 16-bit, 172 kb/sec
~~~~~~~~
Render Format: QuickTime MOV
~~~~~~~~

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

warm regards,
crystal

Remote Programming & Training -- connect to me, let's built it together

~ have an awesome day ~