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  
Home > Courses > Access > Beginner > B2 < B1
Access Beginner 2
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 1 left off. This class focuses primarily on building and formatting Forms in Access. You will learn:

- Setup a Trusted Location
- Working in Form Design View
- Manually Adding Fields
- Manipulating Form Objects
- Lining up Objects on The Grid
- Formatting Your Form
- Using Themes, Fonts, & Colors
- Working in Layout View
- Using Overlapping Windows

Click here for more information on Access Beginner Level 2, including a course outline, sample videos, and more.


Access 365 Beginner 2 Upload Images   Link 
Tuck Seng Phoon 
2 months ago
hello members,

I am new here. Can someone direct the Access 365 Beginner 2 course? The one enrolled was for version 2010.

Joe Hood
2 months ago
Hello Phoon,
Once you login on the website, you should see MyCourses at the top of the page. Click there to see all the courses you have signed up for.

Alex Hedley
2 months ago
B1 was re-recorded for Office 2019/365, B2 hasn't been yet but nothing much has changed since 2010 so it should look very similar and most/if not all will work the same.
Add a Reply
Unrecognised Database Format Upload Images   Link 
Mark Parsons 
6 months ago
When using your downloaded database, i get this message pop up? this happens when i tried following along with your beginner Level 2 for Forms.

It doesnt allow me to save the form.
Adam Schwanz
6 months ago
Mine works fine? Have you tried going down the troubleshooter?
Mark Parsons
6 months ago
Hi Adam, the trouble shooter?  Within help you mean.
Add a Reply
Planning Your Database Upload Images   Link 
Mohammad Abrar 
15 months ago
We Manufacture Small Construction Equipment's

We have  9 Unique Machines(BOM's) and 5 Variants of Each Machines (BOM),Each BOM consists of Raw Material, Semi Finished Goods & Components Read More...
Richard Rost
15 months ago
For now, keep a list of every type of THING you need to track. In your case: machines, materials, components, vendors, etc. Once you get to Expert Level 1 and 2 and finish the lessons on relationships, you'll have a much better understanding of how these things will relate together. For now, start building your tables keeping in mind that each of these is going to have an ID field to link them to something else.

Products and Vendors, for example: each Product will have a VendorID to tell you who you buy that product from. That's a one to many relationship. Or, you may have a situation where you have multiple vendors that supply the same products. That gets into many to many relationships, which are a little tougher.

I see you've only finished Access Beginner 6. Keep learning. You'll get there soon. The Expert Series starts relationships.
Add a Reply
What is an LACCDB file Upload Images   Link 
Anthony Lorenti 
16 months ago

Referencing: Video 06. Questions From Students (10:26) What is an LACCDB File?

I have Access 2019. How do I turn off the file extensions for my version?

Thank you,

Richard Rost
16 months ago
Hi Anthony. Your Access database is an ACCDB file. The LACCDB file is the record locking file created by Access to keep track of who has what open in the database. This way if two people are using the database at the same time, you don't run into conflicts. It's created when the database is open and it SHOULD be deleted automatically when everyone closes the database. To see these file extensions, you have to turn them on in WINDOWS. I think everyone SHOULD get used to seeing them. Microsoft turns them OFF by default. In any Windows Explorer, click on the VIEW tab and then make sure File Name Extensions is checked.
Richard Rost
16 months ago
Windows 8 and 10 are almost the same:
Add a Reply
Themes Upload Images   Link 
Greg Maus 
5 years ago
I noticed the "Themes" dropdown button is not usable for me (greyed out). In fact, the "Colors" and "Fonts" dropdowns on the Themes ribbon are also greyed out. Do you think there might be missing files I have to download to use these features? I'm using Access 2010 on a company laptop. Read More...
Add a Reply
Form Design Upload Images   Link 
5 years ago
Hi Richard, as you mentioned early that forms and queries do not store date, but tables, so when I modified some of the field names while designing form does not affect the table design I have made, help me please I do not understand that. Read More...
Add a Reply
A field in my table whose type is set to Hyperlink Upload Images   Link 
simon b 
5 years ago
if this problem continues you could create another text field in your table, copy across the hyperlinks as text and then delete the hyperlink field. use the code below to activate the URls stored as text. Read More...
Add a Reply
A field in my table whose type is set to Hyperlink Upload Images   Link 
Scott S 
5 years ago
No, I can't drag the URL into the field on a table or in a form. Would reloading Windows / Office help?

Reply from Alex Hedley:

It might be a bug in Office, check for updates or try a reinstall Read More...
Add a Reply
A field in my table whose type is set to Hyperlink Upload Images   Link 
Scott S 
5 years ago
No, but the fields on the form seem to "shudder".

Reply from Alex Hedley:

Does it work via a form?
Add a Reply
A field in my table whose type is set to Hyperlink Upload Images   Link 
Scott Shirley 
5 years ago
A field in my table whose type is set to Hyperlink will no longer accept urls from sites that I try to drag and drop with the mouse, only if I cut and paste it - way slow! Any suggestions? (Drag and drop works fine with all other MS Apps.) 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:

10/16/2021Relink Tables
10/16/2021Access Developer 34
10/16/2021Access Developer 34 Lessons
10/16/2021Access Developer 34
10/10/2021Copy Text from Field
10/10/2021Access for Free
10/8/2021Label Resize
10/2/2021Criticisms of Access
10/1/2021Access Developer 32

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 beginner 2 forms design view layout view overlapping windows laccdb  Page Tag: whatsnew  PermaLink