strive4peace

If you like my video tutorials, please donate so I can keep on creating them.
thank you
watch! 2015 Microsoft MVP Virtual Conference on Channel 9 (MSDN) for Access
53 minute presentation

The "Learn Access" series takes an idea from concept to application. Since contact information is the heart of most applications, this is where we start. You will learn, from the beginning, how to develop a useful application in Access. We spend a lot of time in the planning stage because this is often what distinguishes the master from the apprentice.

Access Basics Video Tutorials Learn VBA ListFiles Database Random Picker Error Handling Reference Database Whistles & Bells Help Examples Crystal's Analyzer Code Documenter

Each step along the way is packed with lots of information. I did not choose to show you how to use Access by picking something easy ... but once you get done with this series (and I get done making it), you will be ready for the rest of the world!

If these videos help you, tell others!


Close-Caption and Translations

All of the "Learn Access" videos have Captions. On this page, you need to be watching the video to see the choices.

  • Turn Captions on or off: click the triangle button in the lower right corner of the viewing window and choose CC or the icon for Captions -- then choose the language you wish to see. English is always available, and we are working on translations to other languages.

  • There is a "Translate" feature available, but the quality of the translation is questionable as it will be literal. For those of you who speak another language, please give me feedback! Click the email link at the bottom of this page.

Learn Access -1- Perspective -- Types Of Applications (9:46)  watch on YouTube

Before we dive into Access, we will put it into perspective with other applications (thank you John Mishefske for this idea)
If you learn an application in each of the following categories, you will have a well-rounded foundation on which to build:

  • Word Processor
  • Spreadsheet
  • Database
  • Graphics and Multimedia
  • eMail and Communications
  • Web Browser

*** Translations ***
Portugese: Luiz Cláudio
French: John Viescas

~~~~~~~~~~~~~~~~~~~~

Learn Access -2A- Planning a Database (9:28)  watch on YouTube

It takes time to plan a good database. A good design is everything when it comes to Access; structuring data is the most important thing to do well. This foundation tutorial is the first of 2 parts on Planning -- what to do BEFORE you create Access objects ...

  • Prepare
  • Visualize
  • Organize
  • Design for Flexibility
  • Naming Guidelines

*** Translations ***
Portugese: Luiz Cláudio

~~~~~~~~~~~~~~~~~~~~

Learn Access -2B- Planning a Database (9:59)  watch on YouTube

Planning a Database, part B: what to know before you create Access objects ...

  • Naming Conventions
  • Questions
  • Field Names
  • Key Fields
  • Relationships
~~~~~~~~~~~~~~~~~~~~

Learn Access -2C- Planning a Database (10:00)  watch on YouTube

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)

I have changed a few of the fieldnames from previous lessons ...

*** Translations ***
French: John Viescas

~~~~~~~~~~~~~~~~~~~~

Learn Access -3- Build a Database ("One More Day" by David Bailey) (cc) (8:01)  watch on YouTube

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.

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 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 is something I will never forget. David was an amazing man who said important things with music.

~~~~~~~~~~~~~~~~~~~~

Learn Access -4- Tables and Relationships (cc) ~music: JD Live (36:04)  watch on YouTube

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.

Links

Customize the Quick Access Toolbar: Tip: Add Save As Icon to QAT (cc) - Français, Dutch, Deutsch, English
Problem names and reserved words in Access, by Allen Browne
Database Issue Checker Utility, by Allen Browne
Failures caused by Name AutoCorrect, by Allen Browne

featured music:

"Colors of the Lonely"
by JD Live (Jerome Dixon from Houston)
Colors of the Lonely on YouTube: http://www.youtube.com/watch?v=08XQjgGTbis
JD on MySpace: http://myspace.com/jdlivepro
JD's website http://www.youtube.com/user/jdlivepro

JD lives and performs in Houston

~~~~~~~~~~~~~~~~~~~~~~

Learn Access -5- Modify Data Structure (cc) {music by Melanie Phippard} (4:11)  watch on YouTube

Data structure is an iterative process. Before building forms, let's modify the data structure from the end of Lesson 4. Learn how to Rename tables, Add fields, Modify existing fields, and Copy fields from one table to another. As you make structure changes, adjust the Relationships Diagram.



~~~~~~~~~~~~~~~~~~~~~~

Learn Access -6- Create a Continuous Form in Microsoft Access (cc) {music by April Kelly} (28:02)  watch on YouTube

Data structure is an iterative process. Before building forms, let's modify the data structure from the end of Lesson 4. Learn how to Rename tables, Add fields, Modify existing fields, and Copy fields from one table to another. As you make structure changes, adjust the Relationships Diagram.




YouTube

To watch these videos in a bigger viewing window, click here to go to Crystal's YouTube Channel. The videos are numbered -- be sure to watch them in order.

If the video list does not appear to the right of the viewing window, click "Uploads" in the header to see the list.

If you wish to be notified when I post new videos, watch them on YouTube and SUBSCRIBE to me ... OR send me email with this subject: "Subscribe to Videos"

To comment on a video, watch on YouTube and sign in (it is free to make an account). There is a Comments link just below the video viewing window on my channel for the featured video (which is NOT the first one in the series -- click on a video to the right to swap it).

If you want to watch in the regular YouTube window instead of my channel, click on the video title just below the video viewing window OR click on the watch on YouTube link to the right of each video title on this page.


If you do not find the help you need in Access Basics or my video tutorials and seek private help, ask me for information. I will be happy to help you &mdash I love to teach and do remote training and custom programming with great success!

I can also create custom video tutorials for your company using your data

contact me for free remote Presentations to User Groups and Organizations

If you have comments and ideas, I'd like to hear from you


Access Basics Copyright © 2009-2016 Crystal Long All rights reserved.| Last Updated: Nov 2016 |