Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

< 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 Beginner Level 6
Description: Access Beginner Level 6
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access Beginner Level 5
Running Time: 1 Hour, 18 Minutes
Cost: $11.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 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 tutorial, microsoft access 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
 
 

 

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
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 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/6/2023 12:00:02 AM.