| |
| |
|
|
|
Access 2010 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: |
Microsoft
Office Access 2010
Access 2007 users should be able to follow along fine |
| 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 |
| |
| |
Student Interaction:
Access 2010 Beginner 6
|
Richard on 8/8/2012:
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
Click here for more information on Access 2010 Beginner Level 6, including a course outline, sample videos, and more. |
Brent on 8/9/2012: Level Seven is in production after Search Seminar right? you said you were going to jump right over to the search seminar after level 6.
|
Selby on 8/9/2012: Dear Richard, Thanks for your help, your the best, Regards Selby
|
Karen on 8/20/2012: I'm creating an order form that has a Customer, a Pickup and a delivery contact. Sometimes my customer is also the pickup or delivery, sometimes its three different contacts. How do I set up my order form to pull information for all three contacts. Understanding relationships between tables do I need to set up a master "Contact" table and then seperate "Customer", "Pickup" and "Delivery" tables or can I pull from just the "Contact table"?
Reply from Richard Rost:
Ideally, you would want 2 different tables here. One for your "contact" as you call it, and then a second table to store the related information (customer, pickup, delivery). This is a classic one-to-many relationship. I have NOT covered this yet as of Access Beginner Level 6. I will be covering it in Access Expert Level 1. If you want to learn it now, you can see Access 201 (for 2003) or my Access Relationship Seminar.
|
Tom Cermak on 9/21/2012: I used paint, changed the picture to a bitmap, but it still displays as an icon.
Reply from Richard Rost:
Make sure you don't have the "display as" set to ICON. Beyond that, I'm not sure... I've never encountered an Access database that couldn't display a bitmap.
|
Tom Cermak on 9/21/2012: Display type is set to "Content" still the same. I tried inserting it (as opposed to the drag and drop) no luck there either.
Reply from Richard Rost:
I'd have to see your database to tell you for sure. I've never known Access 2010 to do that. Older versions were horrible with displaying images, but 2010 has always worked great.
|
Srinath Nandyal on 10/1/2012: A minor correction. When you moved Last Name next to First name, you did not change the label of First name to First and Last Name
|
Wanda W on 11/28/2012: I'm trying to insert a picture in my form, it's an inventory list form, and I converted the file to Bitmap and I get this error message when I drag the bitmap file over: "Microsoft Access can't read the OLE object because communication was interrupted. If the OLE server application is located on a network server, make sure your computer is connected to it". It is on a network server and it is connected, I have confirmed this. The original picture was a 2.3 Mb jpeg and when I converted to a bitmap it became a 20.5 Mb file. Would the larger file size be an issue? I know we have limitations on our server with emailing files larger than 10Mb, but this is not email. Would the file size be the issue? Can I convert the bitmap file to a smaller size?
Reply from Richard Rost:
I would guess that the error is caused by the size of your file. Yes, that's pretty big. First, try the JPG directly. It might work. JPG and GIF files work OK on some systems, they just don't work reliably on ALL systems.
Second, you might want to consider a different technique for displaying your images. I have a whole seminar on ACCESS IMAGING. Basically, storing images in your database works OK for small files, and when you don't have a lot of them, but for BIG files (or lots of files) the best solution is to just store the image on your network (or PC) drive and save the path/filename in your database.
I cover several different methods for doing this in the seminar, and there's also a TIP VIDEO that explains a good technique too.
Oh, and yes, it's sometimes possible to shrink the size of a bitmap. Get it on your screen and perform a screen capture of it (press PRINTSCREEN, paste into PAINT). You'll lose some resolution if it's a HUGE file, but that's usually good enough.
|
Vannak Hou on 12/9/2012: If you were to put "Is Null" on the same line in the "or" right across in each field, does it affect anything? You put "Is Null" in each of a different place under the "OR" section. It's like a step ladder. Are you suggesting that is a good way of writing a code/program? Index Time: 12:40-12:50.
Reply from Richard Rost:
If you go straight across one row, you're making an AND condition. So FirstName Is Null AND LastName Is Null AND CompanyName Is Null.
If you go DOWN one "OR" row each column, then it becomes an OR condition. So you get FirstName Is Null OR LastName Is Null OR CompanyName Is Null.
It all depends on your needs.
|
Eli Tilahun on 12/11/2012: I used paint, changed the picture to a bitmap. It displays on the Form, however it doesn't display on the report (label).
Reply from Richard Rost:
It should. As long as you're using the same control type, and it's still bound to the same field, and that field is in your report, it should work.
Make sure the field that stores the picture is in the underlying record source for the report. You should just be able to copy and paste that picture control from the form directly to the report.
Also, make sure you're in PRINT PREVIEW mode. Pictures don't generally show up in the default "report" view.
|
Eli T on 12/14/2012: I can copy the picture from the Form and paste it to the Report, but it doesn't show up automatically.
Reply from Richard Rost:
I've done it a million times in my databases, but I'd have to see a copy of your database to tell you why it's not working for you. JPGs and GIFs can sometimes be a pain with Access, but BMPs always work.
|
Ron on 12/15/2012: In Level 6, Lesson 4, for inserting picture into the form. I followed your steps as given but the best that will come out after I changed a jpg to a bmp to a small picture (kind of like an Icon) with the file name listed under it. Tried other ways but keep getting the same results. The form will print but the picture remains small showing the picture file name. Can you help as I know that I will have the same problem in Lesson 5 for ID's. Thanks
Ron, make sure that you have Microsoft Paint set up as the DEFAULT HANDLER for BMP images. This is a Windows setting. You want to make Paint the application that opens BMP images by default. You can do this by right-clicking on any BMP file, selecting OPEN WITH, and then selecting Paint. Make sure to set this as the DEFAULT app (open with this app every time). The steps are roughly the same, but slightly different with each version of Windows. You may have some other application install that's trying to "handle" BMP files which is causing problems in Access. You can also TRY to do the same thing with GIF and JPG images.
|
Ron F on 12/17/2012: Richard, did what you said and still not successful. Talked to the IT Department here and they think it could be a problem with the Network. They will look into it. Just as long as I know HOW it should be done and not that I or you are doing something wrong. Thanks for your help!
|
Nick WILLIAMS on 1/17/2013: I tried the procedure shown in this lesson but it didn't work. First I converted the JPEG via Painter into a .bmp file. The resulting file is big - 22.9 MB. When I tried to paste it into the box on the form (form view) I got this message:
"MS Access can't read the OLE object because communication was interrupted. If the OLE server application is located on a network server, make sure your server is connected to it."
Not sure what that means; my home computer is connected to a WiFi router and network.
I also tried the other route: right click in the box --> new Access menu --> create from file --> browse, etc. But I got the same message.
thanks, Nick
Reply from Richard Rost:
As I mentioned in the lessons, Access itself doesn't handle images. It relies on whatever your computer's default application is for that image type. You can determine what this is by double-clicking on an image file from Windows Explorer (or My Computer) and whatever app opens up the image is your default handler. Any time Access gives you that error message, it's having a hard time communicating with the handler app. You can try CHANGING that app by right-clicking on the image file and selecting OPEN WITH... Pick another program like Microsoft Paint or MS Photo Viewer. Sometimes other 3rd-party apps like Photoshop or even your web design editor can "take over" handling of JPGs and Bitmaps, which is bad.
|
Mike Rand on 3/31/2013: Me too. I'm having a similar problem. Both *.jpg and *.bmp pictures render properly on my desktop but when I drag them to the picture field they appear as only an icon. I can send you a "Prnt Scrn" or my PCResale Customer Database file, oi that would be helpfull.
|
Mike Rand on 3/31/2013: Where di I find the "Display as Icon" setting?
|
Patricia Clark on 4/22/2013: This is the fun part for me...I like making things look pretty. You sure make it easy. Thanks
|
Patricia Clark on 4/23/2013: Is Format Painter available in Access 2007? I can't find it.
Reply from Richard Rost:
Yep. It's been in there since at least Access 2000. I don't have 2007 installed anymore so I can't tell you exactly where it is, but in 2013 it's on the Form Design Tools > Format tab.
|
Mo Khan on 5/3/2013: How did you select all the fields from the field list? Its been bugging me all day.
Reply from Richard Rost:
Click on the first one. Hold down the SHIFT key. Click on the last one.
|
Kevin Robertson on 5/4/2013: ... or select one and hit [ctrl] + A
|
|
|
| |
|
You may want to read these articles from the 599CD News: |
|
|
|
