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    2 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     2 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. Add a Reply

What is an LACCDB file Link  Anthony Lorenti    3 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     3 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     3 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. Add a Reply

Show Older Comments...
View in Table Format