Access Beginner 2

Access Beginner 2
By 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.

Unrecognised Database Format Upload Images Link
Mark Parsons
4 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
4 months ago

Mine works fine? Have you tried going down the troubleshooter?

Mark Parsons
4 months ago

Hi Adam, the trouble shooter? Within help you mean.

Show 4 More Replies...

Scott Axton
4 months ago

Mark
No Richards troubleshooter. He gave you the link above but here it is again:

https://599cd.com/blog/display-article.asp?ID=1193

Scott Axton
4 months ago

Mark -
i just got to thinking about a couple other possibilities.
I just ran up and got a copy of the Beginer Level 2 sample database and it ran just fine for me. BUT I'm running 32bit Access.
You didn't mention which version you are running so If you are running 64 bit that may be the issue.  I know there was an issue in the past.
This is an older video but you might try the solution Richard suggested here. This link:

https://599cd.com/blog/display-article.asp?ID=778

Also - Make sure you are running it in a trusted location.  Depending on settings that might be an issue as well.

Mark Parsons
4 months ago

Hi Scott, thanks very much really helpful. Ive only started working with access in a any real sense. So any help and advice I get is really appreciated.

Richard Rost
4 months ago

Mark: it should run fine as an ACCDB regardless of whether you're using 32 or 64 bit Access. The only problem occurs when you're using an ACCDE file and the wrong bit version of Access. In any case, I just downloaded it myself and checked it, and it's fine. It was created for Access 2010 and I'm using 365 (2019) now, so it's a good file. What's the EXACT error message you're getting?

Scott and Adam: thank you!

Planning Your Database Upload Images Link
Mohammad Abrar
13 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
13 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.

What is an LACCDB file Upload Images Link
Anthony Lorenti
14 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
14 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
14 months ago

Windows 8 and 10 are almost the same:

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...

Form Design Upload Images Link
Modi
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...

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...

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...

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?

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...

Green Triangle Upload Images Link
Rafael Gonzalez
5 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...

Show Older Comments...
View in Table Format