Print Page | Close Window

video: Learn Access -4- Tables and Relationships

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Long, Crystal
Forum Description: Access Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind ... whether you realize it or not.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=613
Printed Date: 10 Dec 2017 at 9:13pm


Topic: video: Learn Access -4- Tables and Relationships
Posted By: Crystal Long
Subject: video: Learn Access -4- Tables and Relationships
Date Posted: 08 Jul 2013 at 2:34pm
Learn Access -4- Tables and Relationships
This free video lesson is in a series called Learn Access, hosted by YouTube (where you can also see Captions).  The previous videos in this series cover perspective, planning, and creating a database.

Learning Access or know somebody that wants to?  This lesson focuses on building Tables and Relationships in Microsoft Access.


The most important part of an Access database is the structure ... Tables, Fields, and Relationships.  In this lesson, data and foreign keys are entered into tables.  Then we build 7 more tables; some from scratch and others by copying and modifying ... be careful when you copy!

As tables are created, Relationships are defined.  When arranged logically,  the Relationships diagram is a tremendous tool for planning, and to quickly see what a database is tracking and how information is related.

Learn Access by focusing on structure first ... the rest is downhill when this is done right.  If the structure is not strong, your database will have poor performance and you will often struggle to do
calculations and show reports the way you want to see them.  Good structure equates to flexibility and power.



watch on YouTube in playlist
Learn Access -4- Tables and Relationships (cc) 36:04
http://www.youtube.com/watch?v=kmECCLqkQtY&list=PL1B2705CCB40CA4CA" rel="nofollow - http://www.youtube.com/watch?v=kmECCLqkQtY&list=PL1B2705CCB40CA4CA
(click 'cc' in lower right on YouTube to turn on captions)

This free video lesson shows how to:

- Create new tables and modify structure of existing tables.

- Build Relationships with Referential Integrity.

- Layout the Relationships Diagram.

- 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 an append query to specify autonumber values.

- Use an InputMask to display Phone numbers with symbols.

- Switch between Tabbed Documents and Overlapping Windows.

- Collapse the ribbon to make more space.

- Drag from the Navigation Pane.

- Use icons on a customized Quick Access Toolbar to Hide Columns, Switch Windows, and more.

- How to Set and Turn off Subdatasheet.

- How to track of dates when you only know part of the value.

- Work fast with shortcut keys such as F2 to toggle selecting a whole field and its insertion point.


Read the  video description for links to related video lessons and resources that are discussed.

original music:
"Colors of the Lonely"
- JD Live (Jerome Dixon from Houston)
http://www.youtube.com/watch?v=08XQjgGTbis&list=PL2ACE40CE286131A6" rel="nofollow - http://www.youtube.com/watch?v=08XQjgGTbis&list=PL2ACE40CE286131A6
http://myspace.com/jdlivepro" rel="nofollow - http://myspace.com/jdlivepro
http://www.youtube.com/user/jdlivepro" rel="nofollow - http://www.youtube.com/user/jdlivepro

~ enjoy the lesson ~

happy learning!

Warm Regards,
Crystal

Microsoft MVP
Classroom and Remote Training and Development
... Connect to me, lets build it together!

free book, tips, and tools:
http://www.AccessMVP.com/strive4peace" rel="nofollow - http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*


-------------
Warm Regards,
Crystal
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together

http://www.AccessMVP.com/strive4peace
http://YouTube.com/LearnAccessByCrystal
~have an awesome day ~



Print Page | Close Window