Access IV Advanced Queries

In this class, we will dive deep into the realm of advanced query techniques, equipping you with the skills to manipulate and extract valuable information from your databases. Throughout this course, you will learn how to create powerful action queries, allowing you to perform bulk updates, deletions, and insertions with precision and efficiency. We will explore the versatility of Wildcards, enabling you to search and filter data based on flexible and pattern-based criteria. Additionally, we will delve into the world of Null values, uncovering techniques to handle and evaluate these special data types effectively. Moreover, we will delve into the art of advanced parameter queries, allowing you to create dynamic and interactive queries that prompt users for input. By the end of this class, you will possess the knowledge and expertise to leverage advanced query techniques, enabling you to manipulate and extract data with sophistication and precision. Get ready to unlock the full potential of Microsoft Access and take your query skills to the next level!

Now that your data is safely being held in Access tables, it’s time to create a means to enter new data and print that data. This class focuses on Form and Report Design, utilizing Access’s Form and Report Controls. We also continue working with Queries including creating user prompts, Parameter Queries, and Grouping Queries. PARAMETER QUERIES * GROUPING * FORM & REPORT DESIGN!

• Creating an action query
• Append
• Update
• Delete
• Using Expression Wizard
• Criteria
• Creating an Alias query
• Advanced parameter queries
• Using a form to for query criteria
• Using Wildcards
• Using Null Values