Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 
Courses - Microsoft Access 101
Description: Introduction to Microsoft Access
Running Time: 99 minutes
Pre-Requisites: Windows 101 recommended, Windows 102 or Windows 110 recommended, Excel 101 recommended, Word 101 helpful
Next Lesson: Access 102
Main Topics: Beginner Database Concepts, Tables, Queries, Forms, Mailing Labels
Versions: This course is valid for Access 2000 through 2003. If you are using Access 2007 or 2010, you will still benefit from this course. You will find that the concepts are the same, but there are cosmetic differences between the versions.

    

Order before 11/24/2019 to get a FREE upgrade to our Access 2010 version!
Click here for details

 
Microsoft Access 101
Introduction to Microsoft Access

Create a customer table, queries, customer form, mailing labels, and more. 99 Minutes.
 

AC101 Major Topics

  • Basic Database Concepts
  • Build a Customer Table
  • Create a Query to Limit Data
  • Design an Interactive Form
  • Generate Mailing Label Reports

If you want to learn how to build databases with Microsoft Access, you've come to the right place. Our instructor, Richard Rost, is one of the most knowledgeable Access developers you'll find. When he's not teaching Access, he's building databases for our clients worldwide.

Access is one of the most powerful tools available today for building databases of all sizes. It can be used for personal databases, running an entire small business, or even managing data on an enterprise level using a back-end such as SQL Server. Access can do it all.

We'll begin our course by covering all of the basic database terminology. We'll talk about the different components of a database: tables, queries, forms, reports, macros, modules, and so on. We'll spend some time teaching you how to plan your database on paper before starting to build it on the computer. This step is very important for proper database design.

 

We'll get started by building a database from scratch. We avoid using a lot of the wizards - we want to teach you how to build databases, not just have databases built for you with some wizard. We'll show you how to create your database file. We'll show you the different parts of Access and walk you through the interface briefly.

Our goal is to build a small business database to track customers, contacts, orders, products, and so on. Eventually this database will be a full-fledged contact manager. We'll add more to it in future Access courses. In today's class we will begin by creating the customer table. We'll talk about what tables are and how they work. We'll talk about the different fields you'd use in your customer table.

 

We'll talk about different data types (text, number, memo, etc.) We'll tell you why certain fields that are really numbers should be stored as text data types (like ZIP code). We'll learn about AutoNumbers and Primary Keys. We'll teach you how to save your tables with the right table name.

 

Next we'll add some sample data to our new customer table. We'll show you all of the right ways to enter data such as dates, notes, and so on.

 

When we're all done with tables we'll move on to building a customer Query. We'll show you how to construct Queries to limit your data based on certain criteria (such as, "show me a list of customers sorted by last name who are from New York.")

 

When we're done with Queries, we'll get into the fun stuff: building forms. Forms are a great way to build interactive windows-based databases that are easy for your end-users to work with.

 

We'll spend time teaching you how to create great-looking forms. We'll talk about labels, text boxes, check boxes, and so on. We'll show you how to format your forms, change the colors, resize objects, and so on.

 

Our goal is to teach you the skills you need to make professional-quality forms!

 

When we're done building our Customer form, we'll show you how to create mailing labels for your customers right in Access. Yes, for this we'll use the Label Wizard, but it's a good wizard (you don't want to lay labels out by hand).

 

We'll use the wizard to create easy-to-use mailing labels that are based right off our table.

 

Again, if you're really looking to learn Access, this is the perfect course to start with. We'll cover all of the fundamentals from concept to completion. We'll show you how to build tables, store your data, generate queries, construct forms, and make mailing labels. This course will teach anyone how to build a database - no prior knowledge of databases is assumed. Even if you have been using Access for a while, this is still a great course for learning the fundamentals - and how a database should be built, properly.

 

 

Access 101 Outline
 
1. Introduction
Welcome to Access 101
Important concepts

2. Terminology
What is a database
Database components (tables, queries, etc.)
Describe each component and it's function

3. Planning Your Database
Planning your database on paper
Plan for needed tables
Plan for needed fields in each table

4. Getting Started
Starting Access
Parts of the interface
Creating a blank new database

5. Customer Table, Part 1
Creating a customer table using design view
Creating the FirstName field

6. Customer Table, Part 2
Brief description of basic data types (text, memo, etc.)

7. Customer Table, Part 3
Adding additional fields to your table (phone, address. etc.)
Brief description of basic field sizes (long int, decimal)

8. Customer Table, Part 4
Creating a CustomerID Autonumber
Moving fields in order
Saving your table
Setting the primary key

9. Entering Data
Adding data to your table
Deleting records

10. Customer Query
Building a query in design view
Adding fields to your query
Sorting your query (LastName, FirstName)
Moving fields in your query
Using criteria (e.g. show all customers from NY)

11. Customer Form
Building a form using design view
Selecting a data source
Adding fields to your form using the field list
Lining up your controls
Switching to Form View and back to Design View
Using navigation buttons to navigate records
Moving controls with the Hand
Selecting a block of controls
Deleting controls
Trick to add all controls from the field list to the form
Saving your form

12. Form Formatting
Changing colors of your form and objects
Deleting a label, keeping the text box
Editing your label text
Resizing a text box
Moving a block of controls together
Moving a label independent of it's text box
Resizing your form
Object borders and special effects
Deleting a record from the form

13. Mailing Labels
Using the mailing label wizard
Desigining a prototype label
Report Print Preview
Zooming in and out
 
 


Try a FREE Demo Lesson

 
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP