|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
Search Seminar Lessons Welcome to Access Search. Total running time is 9 Hours, 26 Minutes. Lessons
Resources
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
IntroIn this lesson, you will learn how to perform searches in Microsoft Access from the basics to more advanced techniques. We'll cover simple find and replace, filters and sorts, building dynamic search forms with parameter queries, handling blank and null values, using wildcard searches, working with combo boxes, and writing VBA code for custom search functionality. You'll also explore building multi-table search forms, summary searches, natural language search, and creating reports from search results. By the end, you'll have a solid understanding of both basic and advanced search solutions for your Access databases.TranscriptWelcome to the Access Search Seminar brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.There are four major goals for today's class. First, you are going to learn how to perform simple search and sort operations. Next, we are going to learn how to handle complex query parameters, including working with null values. You are going to get a basic knowledge of SQL programming. You are also going to learn how to perform dynamic form searches with VBA. We are going to start out in the first couple of lessons by going over basic Access find and replace, and filter and sort techniques. Even if you consider yourself an advanced Access user, I still want you to watch these first couple of lessons. You might pick up a couple of tips or tricks you did not know, and some techniques for showing other people how to perform basic filtering, sorting, finding, and replacing inside of your Access databases. We are going to learn how to work with parameter queries, which is having the database ask us for a parameter, for some criteria. We will learn how to work with multiple AND/OR conditions and how to use those parameter queries in our forms. We will set up some database infrastructure, including a main menu form and a continuous form to show all customers. We will then learn how to filter to show only customers from a particular state. Then we will make a button to open the specific selected customer from that continuous form. We will learn how to work with form field parameters, which is setting a value on one form, and then using that as a criteria when we open up another form. You will learn about wildcard searches, which is specifying a portion of a criteria and showing all the records that match that, such as showing all states that start with the letter N. Then we will cover a very difficult topic for beginner Access developers, how to show blank values. If the user leaves the criteria blank, do you want to show the null values or not? Next, you will learn how to make a search combo box, where you can simply pick a customer from a list and have the form jump immediately to that customer's record. Next, we will learn about embedded macros, how they are different from VBA functions, and you will learn about the pros and cons of working with embedded macros. Next, we will make a single field search button, in case you have a particular field that you always search on, like a company name, a phone number, or someone's last name. You click on the search button, type in what you are looking for, press OK, and the form jumps right to that record. First, we will build this using an embedded macro, then we will build the same thing with some Visual Basic code. Do not worry if you have never programmed before; I will show you exactly what you need to do step by step. We will talk about the prerequisites for this course in a few minutes. Next, we will cover multiple field filters using some VBA code, where you can specify multiple parameters in a continuous form, click a filter button, pick whether you want an AND or OR condition, and then Access will show you just those records. Then, we will build something similar, but instead of using filters, we will use SQL record source changes. Once again, a recurring theme that pops up throughout searching is how to deal with blank values or null values in our search results. Next, we will learn how to change the sort order of our search results. Would you like an ascending or descending sort? We will change that with some toggle buttons. We will also learn how to sort based on multiple fields. Next, we will take a look at how to build a search form that is designed for the novice user. If you have other people who are going to be using your database that are not Access gurus, you are going to want a way for them to quickly and easily search for information in the database. So, we will build a nice, simple search form for them, where they can type in whatever they are looking for, and then hit search. However, for you and the advanced users, we want to give them the ability to enter in advanced options. So, I will show you how to make a button to resize your form, show the advanced options, and allow those users to take advantage of those features. You probably have a small group of customers that you deal with on a regular basis. Next, we will learn how to create a recent customer list. As part of your search form, whenever you have a customer that you know you work with on a regular basis, you can add him to a little mini list of recent customers. Then, just double-click on that customer's name and it will open up his record. Next, we will make a multi-table search form. If you are looking for information, but you are not sure which table it is in, you can type information into this form and it will search multiple tables. For example, you may wish to find all the people in your database from New York, whether they are employees, vendors, or customers. This form will search all three tables. It will present you with one single list and, based on which record you double-click on, will open up the particular form. Next, we will build a form for searching products in a product table. We will learn how to search by vendor or product name, but more importantly, between ranges of values, such as find all products that were updated between these two dates, or find all products that are between this range of costs. You might have a particular product and you want to find out who the cheapest vendor is. You will learn how to display summary information on your search results, such as the count of items found, the maximum value, the minimum value, and so on. Next, we will build a form focusing on natural language searching. This is where Access tries to determine what you are looking for based on the phrasing of your search term. For example, are you searching on multiple keywords? Are you looking for a phrase inside of quotes? The search form will actually write custom SQL code based on how you type in your search phrase. We will then customize the natural language search form and turn it into a search-as-you-type form, so as you are typing in your search phrase, with each character press, the Access form updates the search results. You will find this is very similar to how Google gives you instant search results as you are typing information into a search query. Finally, we will learn how to take the custom SQL that our forms are writing for us and use that to print a custom report. Let's talk about the prerequisites for today's seminar. You should definitely have taken my Access 2010 Beginner 1-4 classes. If you do not know the fundamentals in these four classes, you will definitely be lost in today's seminar. You should know how to work with the Access interface, the ribbon, design tables, basic queries, simple forms, and reports. In Level 4, I cover basic find and replace, but on a real, real simple level. I will cover all of that and more today, but if you have a little bit of an understanding of find and replace before starting today's class, it will definitely be helpful. Now, I have something called the SQL Seminar, where I cover SQL structured query language in depth. Do you need to take it before taking this class? No, you do not. But if you take Level 1 of the SQL Seminar before taking this class, it will be a big help to you. The SQL Seminar is in three parts. Part 1 is basic select queries, which is all we are going to be working with today pretty much. Levels 2 and 3 are more advanced. You do not need those. I will take it slow, and I do not assume that you know any SQL before starting the seminar, but again, it would be helpful if you took it. I will also be covering some Access VBA or Visual Basic for Applications in today's class. I do not assume that you know how to program before taking this class. I will take it slow and explain everything that you need, step by step, so if you have never programmed in VBA before, that is fine. We are only going to cover a handful of functions and such today. However, if you want to learn how to program, I recommend taking my Access 300 Series first before taking this class. My Access 300 Series gives you a more gradual understanding of how VBA works, starting with the most simple functions. Today I do jump into it a little bit, but I will cover everything you need to know. Now, as of right now, it is currently October 2012. I do not have any Access advanced or developer lessons available for 2010. They are still coming. So my Access 300 Series is currently for Access 2003, but once you are into the more advanced material, like VBA programming, it is really all the same. VBA has not changed since the early versions of Access. With that being said, I will be using Access 2010 in class. However, all the techniques that I show you today should work just fine with Access 2007 and Access 2003. Yes, the interface is a little bit different. Designing a form from scratch, for example, is a lot different from 2003 to 2007, but if you are taking this course, you should already know how to build forms from scratch. If not, once again, take my Access Beginner classes. I assume you know how to build basic tables, queries, and forms. There is a sample database that you can download for this class. You will find it at accesslearningzone.com/databases. If you are a student who has paid for this course, you can find the password to unlock the zip file in your account on the website. There is also a copy that people who are not paid students can download if you want to evaluate the database. You will not be able to see any of the code, but you can see how the database functions. If while you are watching this class you have questions, feel free to post them in the student forum. If you are watching this course online on my website, you will find the student forum pops up right next to the video. If you are watching offline, you can visit the student forum by simply visiting AccessLearningZone.com and looking for the forums. If you need technical support, if you have problems with your Access Database, you can ask them to me directly on my TechHelp page by going to AccessLearningZone.com/TechHelp. Now let's take a more in-depth look at each lesson and what topics will be covered. In lesson 1, we'll review the sample database that you can download for this class and we'll see how to perform a simple find and replace operation. In lesson 2, we'll learn how to apply simple filters and sorts to our tables and forms. In lesson 3, we're going to begin building a customer search form by using a parameter query to prompt the user for a bit of information and then display the search form with just that data. In lesson 4, we'll learn about menus and buttons. First, we'll make a main menu that will open up when the database starts. We'll make a button to browse customers and another button to show customers by state that will open up the customer list form that we built in the last lesson. On that form, we'll make a button to open the selected customer that will open up the specific customer form for the selected customer on the customer list form. In lesson 5, we're going to learn how to get a parameter from a form field instead of having to use those pop-up prompts. In lesson 6, we'll learn about wildcard searches where you can search for records based on any part of a criteria. Lesson 7 gets pretty complex. Now we're going to learn how to work with blank values. In other words, customers that do not have state or city values if they are null or empty. We will learn how to show those in our results. In lesson 8, we're going to use the combo box wizard to create two different combo boxes to search for records in our form. I'll show you how to do that with the company name and with the customer name, and we'll learn a little bit of SQL so we can make the customer name box sorted showing last name, comma, first name. In lesson 9, we're going to learn about embedded macros and how they are different from Visual Basic code. We'll learn how to create a unique list of company names, search for those, and then create a find next button using an embedded macro. In lesson 10, I'm going to show you how to build a single field search button where you can click on a button, type in a value, and search a specific field using an embedded macro. In lesson 11, we're going to take the search button that we made in lesson 10 and change it from an embedded macro over to VB code. I'm going to teach you how to write this from scratch and we're going to learn a little bit how VBA works and some basic functions. In lesson 12, we'll make more find buttons. We'll make a find button for the company name field and for the address field. Plus, I'll show you how to make your own subroutines so you do not have lots of duplicated code throughout your form. In addition, we'll make the find next button work. In lesson 13, we're going to learn how to apply filters using VBA code. In lesson 14, we're going to learn how to modify the record source of a form using an SQL statement that we will build from scratch. This has several advantages over simply using filters. In lesson 15, we'll add triple state checkboxes to our form so we can see values that are null or are not null. In lesson 16, we're going to add a second field to search by, so you can search by last name then first name or state then city. We'll make a set of toggle buttons where you can change whether it is an ascending or descending sort. In lesson 17, we're going to build a simple search form that is designed specifically for novice users. In lesson 18, we're going to add some advanced options to our simple search form, but we're going to hide them by default and make a button to resize the form and show those advanced options for our power users. I know that I have certain customers that I deal with on a regular basis, so in lesson 19, I'll show you how to create a recent customers list where you can add these customers to a search list at the bottom of your search form. In lesson 20, we're still working with the recent customer list. We're going to see how to handle a problem if the user tries to add the same customer list twice, and we'll also see how to delete the customer and make sure that a value has been selected before we allow the delete operation. In lesson 21, we're still working with the recent customer list. I'll show you how to dynamically resize the column widths inside of your list box and the width of the list box itself. We'll also make those two fields functional to tell us the last time and date that we interfaced with the customer and how many times that customer's record was opened. In lesson 22, we're going to add labels to the top of each column in our customer search list to sort based on that column. In lesson 23, we're going to begin building a multi-table search form where you can type in some parameters and then Access will search multiple tables for those values. In lesson 24, we're continuing to work with the multi-table search form. We're going to set up extra list boxes for our vendors and for our employees and have one search button that will search and show results for all three. In lesson 25, we'll construct a union query to bring the results from three tables into one, and we'll make checkboxes so the user can select which of those three tables they want to search in. In lesson 26, we'll start working on a product search form. This product search form will allow us to work with other types of data, for example, currency values, dates, times, and so on. In lesson 27, we're continuing with our product search form. We'll learn how to search between a range of unit costs or a range of dates updated. In lesson 28, we'll learn how to get summary information when we perform a search. For example, the number of records returned, the min or max values of the unit cost of the products returned, and we'll learn how to click on one of the items and see the notes in a separate field. In lesson 29, we're going to see how to count up how many customers purchased a specific product and generate a list of those customers so you can market to them. If you want to see how many people bought product A and you now want to offer them product B, this is essential. In lesson 30, we're going to begin looking at natural language search. That is where you have one search box, much like Google does, and it will search a table or multiple tables if you want, for multiple fields of data that have that phrase in it. In lesson 31, we'll learn how to break up a long search term into multiple shorter keywords. In lesson 32, we're going to continue with natural language searches. We're going to cover phrase searches, negative keywords, and an exact match search. In lesson 33, we're going to turn our natural language search form into a search-as-you-type form. So as we key in our search phrase, it refreshes the search results with each character. In lesson 34, we'll learn how to take the search results that we generated with our previous search forms and use that same SQL to print a report with those results. QuizQ1. What is the primary focus of the Access Search Seminar?A. Maintaining network security in Access databases B. Learning how to perform various search methods within Access C. Creating websites with Access D. Migrating data from Access to SQL Server Q2. Which of the following is NOT one of the four major goals of the class? A. Learning how to perform simple search and sort operations B. Building custom web applications C. Gaining basic knowledge of SQL programming D. Performing dynamic form searches with VBA Q3. Why does the instructor recommend even advanced Access users watch the first couple of lessons? A. To learn advanced VBA techniques B. To learn about web integration C. To possibly pick up new tips and techniques related to basic search, filter, and sort D. To set up payment information Q4. What is a parameter query used for in Microsoft Access? A. To encrypt database fields B. To prompt the user for values as search criteria C. To store images in the database D. To import data from Excel Q5. What technique will students learn for searching only customers from a particular state? A. Using cross-tab queries B. Creating a filtered continuous form C. Building macros for security purposes D. Linking Access to SharePoint Q6. What is a wildcard search useful for? A. Encrypting sensitive data B. Searching for partial matches in fields C. Printing reports D. Backing up the database Q7. When searching, what is the special challenge when dealing with null values? A. Ensuring the database does not crash B. Deciding whether or not to show blank values in results C. Converting all nulls to zeros D. Exporting null values to PDF files Q8. What concept is introduced when teaching how to make a search combo box? A. Automatically updating table relationships B. Jumping directly to a selected record C. Creating digital signatures D. Encrypting user passwords Q9. What is one main difference between embedded macros and VBA functions in Access? A. Macros are used only for tables, not forms B. VBA can perform more complex operations and embed code directly C. Macros work on Mac computers, VBA does not D. Embedded macros require SQL knowledge but VBA does not Q10. What advantage does the use of SQL record source changes have over just using filters? A. It enables animated graphics in forms B. It can perform searches across multiple tables or fields more flexibly C. It restricts the number of queries in the database D. It increases database security automatically Q11. How will the seminar accommodate both novice and advanced users in the search form design? A. By building two completely separate databases B. By showing and hiding advanced options as needed C. By allowing only one user interface for everyone D. By removing all advanced features Q12. What is one feature of the recent customer list covered in the class? A. Importing customers from Excel only B. Automatically updating customer addresses C. Quick access to frequently used customer records D. Disabling deleted customer records permanently Q13. Why is the multi-table search form important? A. It allows searches across different tables when unsure where data is located B. It increases database security C. It exports data to XML D. It converts tables to macros Q14. What function does the range search on product values provide? A. Lets users search for products between two values, like cost or update date B. Transfers products between vendors C. Deletes duplicate products D. Changes the database theme Q15. What does the seminar promise regarding SQL knowledge before starting? A. Assumes students are experts in SQL B. Assumes no prior knowledge of SQL and will guide accordingly C. Requires passing an SQL pretest D. Only covers advanced SQL programming Q16. If a student has never programmed in VBA before, what does the course suggest? A. Skip all VBA sections B. Watch the instructions as everything is shown step by step C. Hire a programmer D. Use macros instead Q17. Besides technical tutorials, where can students get help if they have questions? A. By emailing classmates directly B. By visiting the student forum on the AccessLearningZone.com website C. Through a dedicated phone support line D. There is no extra support available Q18. What kind of summary information can the search forms display about search results? A. Only the first record B. The count, maximum, minimum, and related summaries C. Only the average price D. Supplier contact details Q19. The "search as you type" form feature is most similar to: A. Email sorting B. Google instant search suggestions C. Printing reports D. Adding new tables Q20. What is the final lesson about in this seminar? A. Exporting data to PDF B. Using custom SQL from search forms to generate a print report C. Creating custom data types D. Building mobile apps with Access Answers: 1-B; 2-B; 3-C; 4-B; 5-B; 6-B; 7-B; 8-B; 9-B; 10-B; 11-B; 12-C; 13-A; 14-A; 15-B; 16-B; 17-B; 18-B; 19-B; 20-B DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone is the Access Search Seminar, and I'm Richard Rost, your instructor for this course.There are four primary objectives for this seminar. First, I'll teach you how to conduct basic search and sort operations in Microsoft Access. Then, we'll move on to working with more complex query parameters, including managing null values. You'll also receive an introduction to SQL programming, and we'll cover how to perform dynamic form searches using VBA. We'll begin with the fundamentals. In the first few lessons, I'll demonstrate how to use Access's find and replace functions along with filter and sort tools. Even if you're already comfortable with Access, I encourage you not to skip these sections. You might discover some useful techniques or helpful ways to show others how to work with simple filtering, sorting, finding, and replacing in your Access databases. Next, we'll explore parameter queries. These allow your database to prompt users for specific criteria when running queries. I'll walk you through handling multiple AND and OR conditions and incorporating these parameter queries into forms. We'll also set up a main menu form and a continuous form to display all customers, then learn how to filter that list based on state. I'll show you how to add a button that lets users open a specific customer's record directly from the continuous form. We'll discuss form field parameters, which enable you to set a value in one form and use it as a criterion in another. You'll learn how to use wildcard searches, which return records that partially match your criteria - for instance, listing all states starting with 'N.' We'll also tackle one of the trickier issues for new Access developers: displaying blank or null values. We'll look at how you want your queries to behave when the user doesn't specify any criteria. After that, I'll introduce the concept of a search combo box. With this tool, you can pick a customer from a dropdown list and instantly jump to their record in the form. We'll compare embedded macros to VBA functions, discussing the strengths and weaknesses of each. If there's a field like company name, phone number, or last name that you frequently search, I'll show you how to build a dedicated single-field search button for it. We'll first use an embedded macro, then I'll re-create it in VBA. Don't worry if you're new to programming; I'll guide you step by step. Multiple-field searches come next. Using VBA, you'll be able to specify several parameters in your continuous form, click a filter button, and decide if they should be linked using AND or OR logic. We'll even review how to change the form's record source using custom SQL, instead of simple filters, to give you more flexibility. Throughout all search operations, handling of blank or null values remains an important theme. Sorting search results is another crucial topic. I'll demonstrate how to use toggle buttons to switch between ascending and descending sort orders, and how to sort by multiple fields. We'll discuss designing a user-friendly search form for individuals who may not be Access experts. This simple form will allow users to search quickly, while advanced users will benefit from additional options that can be revealed as needed using a button. For those who regularly work with a core group of customers, I'll show you how to create a recent customer list. You can save frequent contacts in a quick access list, and open their records with a double-click. I'll introduce a method to search across multiple tables. Suppose you need to find all people from New York, whether they're employees, vendors, or customers. This multi-table search form will return a combined list, and double-clicking a record will open the corresponding form. We'll also build a search form for products, allowing you to search by vendor, product name, or between value ranges such as date updated or cost. I'll show you how to provide summary information in your search results, like totals, maximums, and minimums. We'll explore natural language searching, which interprets your user's search phrases intelligently - whether they're looking for multiple keywords, specific phrases, or more. The search form will actually build its own SQL code based on what's entered. I'll enhance this natural language search to become a search-as-you-type feature, updating results instantly as the user enters characters, similar to how Google search works. To wrap up, I'll demonstrate how to use the SQL generated by your search forms to print customized reports. Let me talk for a moment about prerequisites. You absolutely should be familiar with the material in my Access 2010 Beginner 1 to 4 courses before starting this seminar. If you're not comfortable with the Access interface, using the ribbon, creating tables, queries, and basic forms and reports, you'll probably find today's content challenging. Level 4 of my beginner series covers basic find and replace, though I revisit these topics with more depth today. Some background in these basics will certainly help. If you want a deeper understanding of structured query language, my SQL Seminar covers it in detail. You don't need it before this course, but taking Part 1 (on select queries) will make the material in today's class much easier. Parts 2 and 3 are more advanced and not necessary for this seminar. I'll take things slowly and won't assume any prior SQL experience, though pre-study is advantageous. We'll be working with some Access VBA. I don't expect you to know how to program, and I'll walk you through what you need carefully. If you want a more complete programming foundation, I recommend my Access 300 Series before this seminar. It's designed to provide a gradual introduction to VBA. Even though I use Access 2010 in this seminar, VBA hasn't changed since the early versions of Access, so my programming tutorials (which were originally made for Access 2003) are still relevant. Everything I teach today works in Access 2010, and should be compatible with Access 2007 and 2003, though the interface has changed. If you can design basic tables, queries, and forms, you'll be fine. If not, please begin with the Access Beginner classes. There's a sample database available for download at my website, accesslearningzone.com/databases. Paid students can find the password for the file in their online account. There's also a demo version for evaluation. The demo lets you see how the database works, though the code isn't accessible. If you have any questions during the seminar, you're welcome to post in the student forum. The forum appears next to the video if you're taking the class online. If you're offline, just visit the Access Learning Zone website and locate the forums section. For technical support with your Access database, you can contact me directly using the TechHelp page on the website. Now I'd like to give you an overview of each lesson in the course: Lesson 1 starts by introducing the sample database and demonstrating a simple find and replace operation. Lesson 2 moves on to applying basic filters and sorts to tables and forms. Lesson 3 lays the groundwork for a customer search form by using a parameter query to prompt for information and display filtered results. In Lesson 4, we build a main menu, add navigation buttons for browsing customers and displaying customers by state, and enable opening a specific customer record from a list form. Lesson 5 covers retrieving parameters directly from form fields, replacing the need for pop-up prompts. Lesson 6 introduces wildcard searches, allowing partial matches for flexible searching. Lesson 7 addresses a more complex topic: handling blank or null values, such as customers without a specified state or city. Lesson 8 uses the combo box wizard to create searchable dropdowns, both for company and customer names. I'll also show you how to sort customer names as 'Last, First.' Lesson 9 examines embedded macros: what they are, how they differ from VBA, and when to use them. We'll create a unique company name list and a "Find Next" button using macros. Lesson 10 focuses on building a single-field search button for specific fields using an embedded macro. Lesson 11 replaces the macro from Lesson 10 with a VBA solution, giving you an introduction to writing basic VB code. Lesson 12 adds more search buttons for the company name and address fields, introduces the use of subroutines to avoid duplicated code, and improves the 'Find Next' feature. Lesson 13 explains how to apply filters with VBA. Lesson 14 shows how to change the form's record source using SQL that you build programmatically, outlining the benefits of this approach. Lesson 15 adds triple-state checkboxes for displaying records that are null or not null. Lesson 16 incorporates a second search field and toggle buttons, enabling you to choose between ascending and descending sort orders. Lesson 17 creates a simple search interface for novice users. Lesson 18 enhances this simple form with advanced options, which are hidden by default and revealed using a resize button for power users. Lesson 19 explores building a recent customer list to quickly access people you contact frequently. Lesson 20 continues working with the recent customer list, covering duplicate handling, deletion, and ensuring a value is selected before deleting. Lesson 21 teaches you how to dynamically adjust column widths in the list box, display last contact time, and track how often a customer's record is accessed. Lesson 22 adds sortable column labels to your customer search list. Lesson 23 begins constructing a multi-table search form, allowing you to search for a value across several tables. Lesson 24 extends that functionality with extra list boxes for additional tables (like vendors and employees) and a unified search button. Lesson 25 uses a union query to combine search results from three tables and gives users checkboxes to select which tables they want to include. Lesson 26 introduces a product search form, dealing with other data types like currency, dates, and times. Lesson 27 enhances the product form with search-by-range options for unit costs and updated dates. Lesson 28 shows how to generate summary information for search results, such as record counts and min/max values, and lets you view notes attached to specific items. Lesson 29 demonstrates how to identify and list customers who have purchased a given product, which is invaluable for targeted marketing. Lesson 30 marks the starting point for natural language searches -- one search box that can examine multiple tables and multiple fields for a given phrase, similar to a web search. Lesson 31 shows you how to break complex search terms into individual keywords. Lesson 32 extends natural language searches to include phrase and negative keyword searches, plus options for exact matches. Lesson 33 creates a search-as-you-type interface, updating results as each character is entered. Lesson 34 explains how to generate and print a custom report from your search results using the SQL your forms produce. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListSimple find and replace operations in AccessApplying filters and sorts in tables and forms Building customer search forms with parameter queries Creating main menu forms with navigation buttons Opening specific records from a continuous form Using form field parameters for query criteria Performing wildcard searches for partial criteria Handling blank and null values in search results Creating search combo boxes with the wizard Sorting combo box results using SQL expressions Working with embedded macros for search operations Building a single field search button with macros Converting macro search buttons to VBA code Eliminating duplicate VBA code with subroutines Implementing a find next button in forms Applying filters using VBA code Modifying the form record source with SQL statements Adding triple state checkboxes for null criteria Searching and sorting on multiple fields with toggle buttons Designing a simple search form for novice users Adding hidden advanced options to search forms Building and managing a recent customers list Handling duplicates and deletions in recent customer lists Dynamically resizing list box columns in forms Tracking last accessed date and open count for records Sorting search results by clicking column labels Constructing multi-table search forms Using union queries to combine results from multiple tables Selecting tables to search with checkboxes Creating product search forms with various data types Searching by ranges of unit cost or dates Displaying summary information in search results Viewing related notes for selected products Counting and listing customers who bought specific products Creating basic natural language search forms Breaking search terms into keywords for searching Implementing phrase, negative, and exact match searches Building search-as-you-type functionality in Access Printing custom reports from search result SQL |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: Access Search Seminar PermaLink How To Create Advanced Search Forms, Filters, Parameters, and Dynamic Queries in Microsoft Access |
