Access 2007-2016
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  
 
 
 

< Previous: Access Beginner 5

Next: Access Beginner 7 >

Access Beginner Level 6
Beginner Microsoft Access Tutorial - 1 Hour, 18 Minutes

 
 
This Microsoft Access video tutorial picks up where Level 5 left off. This class covers finding customers with missing address info, creating an employee form with a picture, creating employee name badges, and more. Topics include:
 
  - Missing Address Info
  - Is Null and Is Not Null Scenarios
  - OLE Objects
  - Storing Pictures in a Database
  - Align / Size to Grid
  - Stretch, Clip, Zoom Images

  - Employee Name Badges
  - Adding a Company Logo
  - Bound v. Unbound Image Controls

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first lesson of this course (free of charge), or scroll down for more information.




 

Access 2010 Beginner Level 6
Description: Access 2010 Beginner Level 6
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Beginner Level 5
Running Time: 1 Hour, 18 Minutes
Cost: $12.99


This class picks up where Level 5 left off. We will begin with another great query example. This time we'll use the Is Not Null keyword see how to find customers that have ALL of their address info (street address, city, state, and ZIP code) so we don't print mailing labels for customers that are missing info.

 

Then we'll generate a report for our secretary to call any customers who are missing data in ANY of their address fields. We'll use the Is Null keyword and the OR rows.

 

Next we'll build an Employee table. We'll see how to save some time by copying similar fields from the Customer table. We'll see the input mask for a Social Security Number. We'll learn how to store pictures in our database using an OLE Object. And, you'll learn how to edit a hyperlink.

 

Once the Employee table is built, we'll construct an Employee Form. Again, we'll learn how to recycle some of the similar fields from our Customer form. You'll learn about CTRL-A to select all fields. We'll learn more about the form design grid and the Align to Grid and Size to Grid features. We'll see how the Format Painter works, and how to resize a group of fields together.

 

Next you'll learn how to insert pictures into our employee records using a Bound Object Control. Since JPG and GIF images don't always display in Access, I'll show you how to use Microsoft Paint to convert your pictures to BMP files which will display on your forms and reports. We'll learn about the Stretch, Zoom, and Clip properties of images.

 

Finally, we'll create Employee Name Badges. This will be a report showing all of the employees in the database, their name, title, picture, and a company logo. The latter will be added using an Image Control, and we'll talk about the difference between bound and unbound images.

 

Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access 2010 Beginner Level 6

00. Intro (6:49)

01. Address Info (16:25)
Customers with full address query
Is Not Null AND
Report Property Sheet
Change mailing label report RecordSource
Unexpected Enter Parameter Value
Report Too Wide
Some data may not be displayed
Not enough horizontal space on the page
Customers missing any address info
Is Null OR
Create Quick Report
Report Layout View
Resizing Columns
Moving Fields
Moving Page Number Block

02. Employee Table (13:05)
Distinct Separate Data Means New Table
"EmployeeID" vs. just "ID"
Copy Fields from Customer Table
Insert Rows in Table Design View
Social Security Number Input Mask
Picture
Attachment - Brief Discussion Of
OLE Object - What it is
Editing a hyperlink
03. Employee Form (13:53)
Create Form in Design View
Bring over fields for Employee Form
Copy Address Fields from CustomerF
CTRL-A To Select All Objects
Align to Grid
Size to Grid
Set Form Background Color
Format Painter
Double-Click to Keep Active
Resize a Group of Fields

04. Inserting Pictures (9:59)
Copy Image from Web Site to Desktop
JPG and GIF may show icon only
Convert to BMP using Microsoft Paint
Click and Drag to OLE Object
Stretch, Clip, Zoom

05. Employee ID Report (11:44)
Label Wizard
Manually Resizing Labels
Adding Employee Picture
Transparent Border
Bound Object Frame
Unbound Object Frame
Image Control
Insert a Static Company Logo
Editing Pictures in Place

06. Review (5:53)
 

 


 
Keywords: Missing Info, Picture, Image, OLE Object, Employees, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 training, is null, is not null, and across, or down, employee info, social security number, input mask, picture, OLE object, edit hyperlink, copy fields, select all, align to grid, size to grid, format painter, convert jpg to bmp, microsoft paint, stretch, clip, zoom, label wizard, employee name badge, image control, bound object frame, unbound object frame, company logo
 

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