Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access 2010 Beginner 6
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 years ago

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.

Social Security Number Input Upload Images   Link 
Larry Fisackerly 
8 days ago
If the SSN input mask is used to hide the SSN, how do I view the SSN when I need to use it?
Larry Fisackerly
8 days ago
What I meant was if I encrypt the ssn with *********, how do I later read the ssn?
Richard Rost
8 days ago
Easiest solution: make a manager-only form that shows it. Optionally, you could make a button that would change the InputMask on demand. That would require a tiny bit of VBA. This would actually make a cool TechHelp video. I'll add it to the list.
Add a Reply
CustomerWithoutFullAddressQ Upload Images   Link 
Penny Hiotis 
2 months ago
Might be in a different lesson but in relation to the CustomerWithoutFullAddressQ is possible that you could create this by not changing the criteria from Is Not Null to using the customerT and then returning all records which were NOT in the customerWithFullAddressQ - Thank-you
Scott Axton
2 months ago
Hi Penny -
Unless I'm not understanding your question, this is exactly what is covered in Lesson 1 of  this Beginner 6 series.  The opposite of IS NULL is IS NOT NULL.

Remember that a query is just a way to display your data.  All of the data is still there.  You are just limiting what you are looking at.

Penny Hiotis
2 months ago
Hi Scott,
I dont think I am explaining it right
In my new query I want to use the CustomerT & CustomerWithFullAddressQ and somehow say can you display all the records in the CustomerT which were not displayed in the CustomerWithFullAddressQ

Hope this is clearer Penny
Add a Reply
OLE Object Image Upload Images   Link 
Mark Parsons 
3 months ago
Hi Rick, love the videos and following along and building the DB. But no matter what i`ve tried to insert an image, it only displays as an icon? i`ve tried all different formats from bitmap to jpeg, and also tried inserting. But still no luck, can you help please.
Richard Rost
3 months ago
Bitmap should do it. I've never seen a BMP not working. Honestly, I don't even like this method of working with images anymore. I prefer the NEW METHOD which was only added in Access 2013, I believe. Next time I re-record this class, I'll be sure to teach the new method. OLE Objects need to go away. :)
Julie VanDeburgh
5 days ago
It was no picnic for me today to figure out how to get my employee pic into the bound object frame on my employee form.  Drop and drag did not work.  The pic was HUGE! Inserting the btmap image with a right click in the form preview did the job.
Add a Reply
Great Videos Upload Images   Link 
Mark Parsons 
3 months ago
Hiya Rick, great videos really helpful. I`
Richard Rost
3 months ago
Thanks, Mark. Glad you liked them.
Add a Reply
Exclusive Access Upload Images   Link 
Harold Sheats 
6 months ago
Why Does it i do not have Exclusive access to the database?
Richard Rost
6 months ago
Is anyone else on your network using the database? If it's a stand-alone database, try rebooting. If that doesn't work, look for an .LACCDB file with the same name as your database and delete it.
Add a Reply
Access Assistance Available Upload Images   Link 
William B 
3 years ago
I got to looking into the property sheet and in the Employee Form for the Picture frame,needed to be set in the Data Section under control Source for Picture. Not sure if i missed it in lesson, But it working for now.
Add a Reply
Access Assistance Available Upload Images   Link 
William B 
3 years ago
On lesson Beginner 6 Mr Rost explains how to put pictures into a employee file. this is the response i get from my computer. When attempting to do so.

Microsoft Access                                                                       X
Add a Reply
Images Upload Images   Link 
modi waggeh 
5 years ago
Hi Richard, will the picture be remain in access, if I delete the original image on my local computer? And how to use file path to OLE object?

Reply from Alex Hedley:

I would advise against storing the picture in the db. Read More...
Add a Reply
I went back through the lessons and cannot find wh Upload Images   Link 
Marianne Bennett 
5 years ago
I went back through the lessons and cannot find where you taught how to build a mailing label report.  Could you guide me to that particular lesson?

Reply from Alex Hedley:
Add a Reply
Overlapping Windows Upload Images   Link 
Bernardo Ito 
5 years ago
Hi Richard,
My question is regarding the way Access displays the information.
I would like to be able to  make Access let me have multiple forms, tables or queries open so I can work with them at the same time. (As you did in Lesson 3 Level6 Beginner at Time Index: 02:15, when you used two Forms at the same time). However, my Access only let me have one Form open covering all the screen. Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

9/17/2021Overlapping Windows
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
8/29/2021What is Microsoft Access?
8/27/2021Union Query

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access 2010 beginner 5 address is null is not null ole objects pictures images align to grid size  Page Tag: whatsnew  PermaLink