Back to course list
- Level: Intermediate
- Duration: 04h 29m
- Release date: 2022-02-14
- Author: Adam Wilbert
- Provider: LinkedIn
Access 2021: Queries
Description
Content
Learn how to find and translate complex raw data into information you can use to make better decisions. Access expert Adam Wilbert explains how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering challenges that help you master the material. Find out how to identify top performers, automate repetitive analysis tasks, make queries more flexible with parameter requests, and increase accuracy and consistency in your database using program flow functions. Adam closes with an assortment of useful query tricks. Take the challenges posed along the way to test and practice your new Access skills.
- Introduction03m 22s
- Do more with Access queries01m 15s
- Trust the exercise files02m 07s
- 1. Introduction to Access Queries28m 20s
- The Red30 Tech database04m 03s
- Understand queries05m 46s
- Create a query with the Query Wizard05m 56s
- Explore the Query Design view06m 45s
- Build a query in Design view05m 50s
- 2. Create Simple Select Queries42m 27s
- Define query criteria07m 58s
- Understand comparison operators03m 39s
- Use wildcards in criteria04m 35s
- Rename the column headers04m 37s
- Explore the property sheet09m 19s
- Work with joins05m 28s
- Challenge: Create a select query00m 55s
- Solution: Create a select query05m 56s
- 3. Create Parameter Queries31m 23s
- Understand parameter queries06m 36s
- Obtain parameters from forms08m 08s
- Use a combo box to select criteria05m 21s
- Requery with a button macro02m 22s
- Challenge: Gather products by category00m 48s
- Solution: Gather products by category08m 08s
- 4. Use the Built-In Functions22m 31s
- Explore the Expression Builder interface05m 04s
- Use mathematical operators06m 11s
- Apply functions to text07m 03s
- Challenge: Convert US dollars to Canadian dollars00m 37s
- Solution: Convert US dollars to Canadian dollars03m 36s
- 5. Aggregate Recordings with a Totals Query15m 24s
- Summarize data with aggregate functions05m 05s
- Understand the totals field05m 08s
- Calculate a sum total02m 45s
- Using the WHERE clause02m 26s
- 6. Work with Dates in Queries41m 41s
- Select a range of dates or times04m 21s
- Date and time functions06m 19s
- Format dates05m 53s
- Sort dates chronologically05m 06s
- Obtain today's date03m 56s
- Calculate elapsed time with DateDiff()04m 46s
- Calculate time intervals with DateAdd()04m 38s
- Challenge: Expand order details00m 45s
- Solution: Expand order details05m 57s
- 7. Program Flow Functions21m 46s
- IIF() conditional statement03m 04s
- Create an IIF() function05m 35s
- Use the Switch() function07m 58s
- Challenge: Calculate sales price for a product line00m 50s
- Solution: Calculate sales price for a product line04m 19s
- 8. Alternative Query Types25m 25s
- Find duplicate records04m 25s
- Identify unmatched records01m 55s
- Create an unmatched records query02m 37s
- Make a crosstab query03m
- Create a backup of the database01m 54s
- Update data with a query04m 19s
- Make table, delete, and append queries07m 15s
- 9. Write Queries with Structured Query Language13m 41s
- Explore the basics of SQL04m 12s
- Create a union query to join tables04m 19s
- Nest SQL code in other queries05m 10s
- 10. Useful Query Tricks22m 18s
- Pull random records from the database03m 25s
- Return records above or below average03m 56s
- Process a column of values with domain functions06m 44s
- Challenge: Identify the highest and lowest pricing markup00m 32s
- Solution: Identify the highest and lowest pricing markup07m 41s
- Conclusion01m 14s
- Next steps01m 14s
Random courses
- OS Analysis with Volatility
- Creating an Empowered Life
- Intro to Metaverse Investing in Virtual Real Estate
- To the Advanced Trader,complete course for Pros.
- Advanced Searching and Reporting with Splunk Enterprise
- Learn Interview Q&A in Mandarin Chinese
- J.S. Bach: Minuet in G BWV Anh. 114, Experts Execution Piano
- Tabla course for the beginners
- Visual Studio 2022: Big Picture
- Container Infrastructure Analysis with Trivy
Latest courses
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals