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

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