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  6 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... Component are purchased with or without Serial No from Multiple Vendors , Which are then used in Different Machines (BOM`s) Inventory Management of Raw Materials, Semi Finished Goods, Components, Finished Goods (Machines Manufactured) are maintained Manufacturing of Finished Goods are done at 2 Different Units and 2 Different Warehouses Quotes(Reports) are provided to Prospective Customers, Need to Track Marketing Data like Prospect,Closed,Lost Customers, Sales Commission. I Have Customers with Multiple Branches,Customers Shift Machines to Different Branches For Each Machine Sold Need to Track Dispatch Details (Packing Labels) Serials of Components Warranty Status Service History (Spares/Service provided in Warrantee/Out of Warrantee Period) How do I Plan my Database like Tables and its Relations Richard Rost 6 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. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

What is an LACCDB file Link  Anthony Lorenti  7 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 7 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 7 months ago Windows 8 and 10 are almost the same: Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Themes 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... Reply from Alex Hedley: Are you using a runtime version of access or is it licensed? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Form Design 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... Reply from Alex Hedley: You aren't modifying the Table you are modifying the CONTROL on the FORM, you are binding a CONTROL to link it to a Field in your Table, if you change this and it doesn't exist as a Field it won't work or the CONTROL's name is just different to the underlying RecordSource. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

A field in my table whose type is set to Hyperlink 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... Dim WebSite as String WebSite = "http://www............." Application.FollowHyperlink WebSite Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

A field in my table whose type is set to Hyperlink 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... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

A field in my table whose type is set to Hyperlink 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? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

A field in my table whose type is set to Hyperlink 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... Reply from Alex Hedley: Does it just show the 🚫sign when you try? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Green Triangle 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... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

File Menu Link  Rajiv Dass  6 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... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format