The built-in parameter value dialog box is a good start when creating dynamic select queries, but they don't provide a very user-friendly interface. By moving the parameter collection task to a well designed form, the end user experience is enhanced. In this movie, Adam will demonstrate how to obtain query criteria from a form.
- [Voiceover] I wanna start this movie…by passing on a fundamental concept…that might change the way you think about Access.…Every object, every form, every button, or check box,…or label, or test box, everything,…has a name and value associated with it…inside of Access.…And every name or value can be used as an input…somewhere else in your database.…Really understanding this concept will set you on the path…of becoming a true Access rock star, and here's why.…Access objects, that is tables, forms, queries,…reports, et cetera, they're all presented…by the interface's individual components…of your database.…But in reality, it's the interaction and interconnections…between objects that allow your databases…to do some pretty amazing things.…
In a previous movie, we looked at how we can provide…our end users with a pop-up dialogue box…to define some query parameters.…Let's take that a step further and see…how we can define some of those same parameters…using form controls.…For this exercise, I wanna take a look at our customers…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.