Learn Access -3- Build a Database ("One More Day" by David Bailey) (cc)

Build a new database. Create File. Make Tables and Fields. Define Primary Keys. Create Relationships.

Demonstrations use Access 2003, 2007, and 2010. Version does not matter! Learn HOW. If this video helps you, tell others.

~~~~~
featured music:

"One More Day"
by David M. Bailey
Feb. 26, 1966 - Oct. 2, 2010

http://www.DavidmBailey.com/
http://www.cdbaby.com/cd/davidmbailey

David M. Bailey was amazing. He was a poet, philosopher, prolific songwriter, and so much more -- and he loved coffee. Where he went, he made a difference. His music and memories remain. Hearing David perform this song in person, once in a big crowded tent and another alone in a meadow, is something I will never forget. David was an amazing man who said important things with music.
~~~
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

happy learning!

Warm Regards,
Crystal

*
(: have an awesome day :)
*

Category:

Education

Tags:

• Tables
• Microsoft Access
• Access
• Database
• Fields
• Data Type
• Field Size AutoNumber
• Primary Key
• Relationships
• Relationship
• David Bailey
• David M. Bailey
• One More Day
• Access 2003
• Access 2007
• Access 2010

[LearnAccessByCrystal]

Hi Joe, thanks! I don't always know all parts of someone's birthday -- maybe I just know the month and the day. By storing year, month, and day in 3 separate places, I can fill out what I know. If the value were stored as a date, I could not fill it out -- or I would have to make up a year to get the month and day in ... and then I'd need to know which DOBs had some made-up data...

Warm Regards,

Crystal *  (: have an awesome day :) *

[JoeOxfordCT]

Hi Crystal, I was on the webinar with you & Juan Soto for the CAUG. Surfed on into your sites. Really impressive videos. Just curious, in your Contacts table why did you store DOB info in 3 separate fields as integers rather than just use a date data type ?

J. :)