Rating 4.55 out of 5 (46 ratings in Udemy)
What you'll learn- Get more accurate data entry by controlling a user’s input with controls
- Find unique values and records, and using wildcards
- Create prompts and do mass record updates with Action Queries
- How to Filter and Sort records in Forms and Reports
- Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons
- Quickly summarize the details of your records in Forms with Subforms
- Quickly summarize the details of your records …
Rating 4.55 out of 5 (46 ratings in Udemy)
What you'll learn- Get more accurate data entry by controlling a user’s input with controls
- Find unique values and records, and using wildcards
- Create prompts and do mass record updates with Action Queries
- How to Filter and Sort records in Forms and Reports
- Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons
- Quickly summarize the details of your records in Forms with Subforms
- Quickly summarize the details of your records in Forms with Subforms
- Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training
DescriptionGo Beyond Access Basics
Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.
Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks. Below are just a few of the topics that you will master:
How to set data entry defaults and using Validation Rules
Show a field’s history and create Lookup Fields
Hide duplicate values and records in a Query
How to use Action Queries: Update, Append, Delete and Make Table
Create Form drop-down lists to lookup values, or Combo Boxes
Add Form Option Groups that controls the list of choices available for a user
Add more space to your Forms without scrolling with Tabs
Jump around quickly to other Access Objects by creating Form Command Buttons
Add, Sort and Filter records in a Report, as well as keeping groups together
Add summary fields to your Reports and include SubReports
And much, much more!
