Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 
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.

    
 
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

 
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 8:45:24 AM. PLT: 0s