Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon  
 
 
Access 2010 Beginner 2
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 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 2010 Beginner Level 2, including a course outline, sample videos, and more.

Planning Your Database Link 
Mohammad Abrar   
4 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    
4 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 Link 
Anthony Lorenti   
5 months ago
Rick,

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,

Tony
Richard Rost    
5 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    
5 months ago
Windows 8 and 10 are almost the same:
Add a Reply
Themes Link 
Greg Maus 
4 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 Link 
Modi  
4 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 Link 
simon b 
4 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 Link 
Scott S 
4 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 Link 
Scott S 
4 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 Link 
Scott Shirley 
4 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
Green Triangle Link 
Rafael Gonzalez    
4 years ago
How does one correct an item to get rid of the
Geen triangle that comes up on the left hand corner.


Reply from Alex Hedley:

The Green Triangle should have a little drop down beside it, click on it and follow the fix issue steps Read More...
Add a Reply
File Menu Link 
Rajiv Dass    
5 years ago
For windows 10 "pressing and releasing" the "Alt" key does not open file edit menu (1:25)?


Reply from Alex Hedley:

Can you right click and show the menu.
Are you pressing the alt on the lhs or rhs of the keyboard? Read More...
Add a Reply

Show Older Comments...
View in Table Format

Post a New Comment or Question
 
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.
 
Subscribe
 

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

11/29/2020Wildcard Search and LIKE
11/25/2020Tab Control
11/21/2020Shortcut Keys Ctrl-Period Ctrl-Comma
11/19/2020Hide Page Footer on First Page
11/19/2020Single-Field Search Button
11/19/2020Get Username WScript
11/18/2020Access Developer 19
11/18/2020Access Developer 19 Lessons
11/18/2020Access Developer 19
11/18/2020DateAdd to Add Months
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access 2010 beginner 2 forms design view layout view overlapping windows laccdb  Page Tag: whatsnew  PermaLink