Learn Access -2.C- Planning Fields and Relationships

Learn Access -2.C- Planning Fields and Relationships

LearnAccessByCrystal

1 десятилетие назад

22,669 Просмотров

Planning a Database, part C. Plan fields and relationships for:
- People
- Categories
- Addresses
- Phones
- eMail
- Websites
- Types
- PAdr (cross-reference table between People and Addresses)

*** TRANSLATIONS ***
French: John Viescas (Microsoft MVP, Access) http://www.Viescas.com
Go to the link for great books by John Viescas!

*** CAPTIONS ***
turn Captions on or off:
click "cc" in the lower right corner of the viewing window. To translate, mouse-over CC and click the language you desire.

~~~
original music:
"Broken Ground" by Microsoft MVP Mark Davis (cybercow)
http://www.garageband.com/song?|pe1|S...
Mark's website (great search tools here, a worthwhile place to visit):
http://www.endprod.com

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

~~~
Access 2000 Reference Database with Zip Codes, Country Codes, State Abbreviations, Phone Codes, Airlines, and Airports
http://www.accessmvp.com/strive4peace/Reference

~~~
Learn Access. Enjoy! Grab a cup of your favorite beverage, relax and open your mind ... send me email for private training or custom programming

strive4peace2013 AT yahoo.com

~~~
Post comments!
I read everything and love hearing from you.

*****
FREE book on 'Access Basics'
(even if you are not a beginner, chances are you will discover something new)
http://www.accessmvp.com/strive4peace

~*~*~*~*~*~

Presentation -- Microsoft Office PowerPoint
Screen-shots -- Snagit
Drawings -- CorelDRAW
Audio -- GoldWave
Video production -- Camtasia

* 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 ~

Тэги:

#Planning #Database #Crystal #Learn #Access #strive4peace #MVP #French #Close-Caption #Caption #Microsoft #Access2010 #Access2007 #Access2003 #Mark_Davis #Access_2013 #Access_2010 #Access_2007 #Access_2003 #Microsoft_MVP ##mstips #Captions #Access_Reference_Database #Zip_Codes #Country_Codes #State_Abbreviations #Access_Relationships #Access_Fields #Fields_and_Relationships ##mvpbuzz #Planning_an_Access_Database
Ссылки и html тэги не поддерживаются


Комментарии:

LearnAccessByCrystal
LearnAccessByCrystal - 22.01.2013 19:35

thank you, Smiley :) it is nice to hear that ~ Crystal * have an awesome day :)

Ответить
TheSmileyCoder
TheSmileyCoder - 22.01.2013 15:16

Its very nice to see someone put so much work into and effort into making quality content. Thumbs up!

Ответить
ExcelIsFun
ExcelIsFun - 16.06.2012 09:13

The team work that goes into these videos is just great! Content = awesome! Teammate = Crystal + Mark + John = Great Video!!!

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 16.06.2012 08:14

thank you, Mike! I had a tough day ... it was so nice to see all your comments! Hope we can meet up in Seattle next year. Mark Davis' music really helps give life to the video - was nice to see him again at the Summit; he is a fellow Access MVP and, as you see, quite creative! I also used a couple screen shots from his apps in my tutorials. John Viescas, another fellow MVP and author of many books, translated the captions to French on this and other videos ~Crystal

Ответить
ExcelIsFun
ExcelIsFun - 16.06.2012 03:49

Totally amazing!!!

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 07.04.2011 01:10

@deviousoverdose. Thank you :) I absolutely plan to finish this series -- and now I have finally decided what I will call the main Name fields, which was initially stopping me from doing more; names are important. So far, it has not been an issue -- names always change in the planning stage as you get better ideas. Appreciate you taking time to make a comment.. Warm Regards, Crystal * (: have an awesome day :) *

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 10.07.2010 22:01

@upsfeup -- I do plan to continue, although it probably seems like I have stopped. Sorry. We moved and now we are moving again -- hopefully to a place we can plant ourselves for awhile :) It will be a few more months before I might be at a point to make more videos -- when I can, I will do it ! Thank you for your comment Warm Regards, Crystal * (: have an awesome day :) *

Ответить
José Sá
José Sá - 10.07.2010 15:43

I really wished that you had continue with the series, The missing part is the most important, actually implementing the design and making the queries go together!

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 26.05.2010 22:04

@sideshowmom You're welcome, Vina -- beautiful horses :) -- thanks back Warm Regards, Crystal * (: have an awesome day :) *

Ответить
sideshowmom
sideshowmom - 26.05.2010 20:37

Thank you for posting these Crystal! I'm redoing a database for my hobby and following your conventions and Access Basics!

Ответить
RobynHand
RobynHand - 12.03.2010 21:35

I cannot get this to play at all any ideas?

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 01.03.2010 00:12

Thanks. You are absolutely right!  I am still not sure which way I will store websites for the video. Many:many is more complex and how I do it for myself (smile) Warm Regards, Crystal * (: have an awesome day :) *

Ответить
James' Stash
James' Stash - 28.02.2010 08:15

Hi Crystal, You've got some great videos. I had a question about websites though. Would they also be a many to many in relation to people? For example, everyone I work with has the same work website. Thanks!

Ответить
Rajesh Chandnani
Rajesh Chandnani - 03.02.2010 08:31

Hi Crystal Just wanted to know where can i find more videos of yours about access. Regards Chor

Ответить
Mark Reid
Mark Reid - 26.06.2009 05:00

Gidday Crystal, Thanks for the effort you put into "series 2". Your simple and comprehensive explanations are very helpful, and in my case very timely as I'm trying to develop my first Access database. I look forward to the next in this series. Mareko

Ответить
LearnAccessByCrystal
LearnAccessByCrystal - 15.06.2009 12:13

you're welcome -- and thank you! Warm Regards, Crystal * (: have an awesome day :) *

Ответить
Ayman Zekry
Ayman Zekry - 15.06.2009 10:16

Beautiful! Great info and great explainations. I can hardly wait for your next videos. Thank you very much.

Ответить