Create a SEARCH FORM - easily find records [Microsoft Access]

Learn how to create a form with multiple input objects (text, combo boxes, options etc.) which you can use to enter search criteria and find records in a table quickly and easily. And functional buttons to run a query and reset your form directly from the form.

0:00 Intro
01:19 Demonstrating the Search Form i will be creating
05:10 Understanding the mechanics of how the search form works
07:04 Creating the search Form (Adding Text boxes, Combo box, Options). Some basic formatting
14:16 Naming your objects (this is important for later when you are creating the Query)

16:33 Creating the Query (initial steps)
19:35 Understanding Wild cards in query criteria

23:51 Adding the criteria in the Query from the Form
23:51 Adding the criteria from a text box
27:16 Adding a button to the Form to run the query
28:21 Adding the criteria from a Combo Box
30:27 Adding criteria with an operator, accounting for when nothing is entered in the form (use of Is Null)
39:10 Adding the criteria from an option control
41:19 Creating a reset button for the form
44:54 Format your form to make it more user friendly