Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Access 8
By Richard Rost   Richard Rost on LinkedIn Email Richard Rost   12 years ago

It's done. It's live in the Theater and available in the Order Form. I haven't had a chance to put up the full outline yet, but here's what's covered:


00. Intro (6:51)

01. Value List Combo Box (15:02)
Combo Boxes provide for uniform data entry
Select an option from a list
Add LeadSource to Customer Table
Make sure LeadSource is in Customer Form
Change RecordSource to CustomerT
Add Combo Box to Customer Form
I will type in the values that I want
Store that value in this field
Selecting values
Why is it called a Combo Box?
Limit to List
Edit List Items
Adding Items to the List
Default Value
Allow Value List Edits

02. Table-Based Combo Box (12:27)
Why you should NOT use a Value List Combo
Create a LeadSource Table
Combo Box get the values from another table
Which fields do you want in combo box
What sort order do you want
Save in the LeadSource field
Row Source Type: Table/Query
List Items Edit Form
Create a LeadSource Multiple Items Form

03. Multi-Column Combo Box (8:58)
Combo Box to pick States
Create a State Table
State Abbreviation and Name
Hide Key Column
Resize Column Widths
Which column to store in CustomerT
List Width
Column Widths
List Rows

04. Tab Order (10:58)
Show the Tab Order on CustomerListF
Rearrange Controls
Tab Order button
Detail Section
Auto Order
Manually Edit Tab Order
Tab Stop Property
Cycle Property
All Records
Current Record
Fix the Customer Form Tab Order

05. List Boxes (8:55)
Preferred Shipping Method
Create ShippingT
Shipping field in CustomerT
Change To > Combo Box
Don't use Table Lookup Wizards

06. Search Combo Box (2:39)
Turn on Form Header/Footer
Combo Box Find Record

07. Review (5:54)

Comments for Access 8
 
Age Subject From
12 yearsAccess 8Mubeezi Micah

 

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to Access 8
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 4:29:13 AM. PLT: 0s
PermaLink  Access 8