Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Long, Crystal
  New Posts New Posts RSS Feed - video: Learn Access -4- Tables and Relationships
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

video: Learn Access -4- Tables and Relationships

 Post Reply Post Reply
Author
Message Reverse Sort Order
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 35
Post Options Post Options   Thanks (0) Thanks(0)   Quote Crystal Long Quote  Post ReplyReply Direct Link To This Post Topic: video: Learn Access -4- Tables and Relationships
    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
(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
http://myspace.com/jdlivepro
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

*
(: 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 ~
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.