Access 2016: Queries in Depth Год выпуска: 06/2016 Производитель: Lynda Сайт производителя: lynda.com/Access-tutorials/Access-2016-Queries-Depth/455726-2.html Автор: Adam Wilbert Продолжительность: 4:09 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Learn how to find and translate complex raw data into information you can use to make better decisions, with Access queries. 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. Научиться находить и переводить сложные сырых данных в информацию, которую вы можете использовать, чтобы сделать более обоснованные решения, запросы доступа. Эксперт доступа Адам Уилберт объясняет, как создавать реальных запросов для фильтрации и сортировки данных и выполнения расчетов, а также уточнения результатов запроса встроенные функции, все время предлагая задачи, которые помочь вам освоить материал. Узнайте, как определить лучших исполнителей, автоматизировать повторяющиеся задачи анализа, делает запросы более гибкими с просьбами параметров и повышение точности и согласованности в базе данных с помощью программы функции потока. Адам закрывает с ассортиментом полезных трюков запроса. Взять проблемы, возникающие по пути, чтобы проверить и практиковать свои новые навыки, доступ.
Содержание
Introduction 3m 35s Welcome 1m 3s Using the exercise files 30s Trusting the exercise files 1m 45s Explaining the challenges 17s 1. Introduction to Access Queries 26m 2s The H+ Sport database 5m 39s Understand queries 4m 46s Create a query with the wizard 6m 40s Modify a query with the design interface 8m 57s 2. Creating Simple Select Queries 37m 20s Define query criteria 8m 51s Understand comparison operators 4m 2s Use wildcards in criteria 3m 20s Rename the column headers 3m 11s Explore the property sheet 7m 31s Work with joins 6m 38s Challenge: Create a select query 32s Solution: Create a select query 3m 15s 3. Creating Parameter Queries 22m 3s Understand parameter queries 6m 12s Obtain parameters from forms 6m 51s Use a combo box to select criteria 4m 17s Challenge: Gather employee emails based on department 38s Solution: Gather employee emails based on department 4m 5s 4. Use the Built-In Functions 22m 50s Explore the Expression Builder interface 4m 29s Use mathematical operators 6m 59s Apply functions to text 8m 17s Challenge: Convert US dollars to Canadian dollars 28s Solution: Convert US dollars to Canadian dollars 2m 37s 5. Aggregating Records with a Totals Query 12m 17s Summarize data with aggregate functions 4m 30s Understand the Totals field 5m 53s Use the WHERE clause 1m 54s 6. Working with Dates in Queries 40m 5s Dates as serial numbers 4m 52s Select a range of dates or times 3m 10s Date and time functions 4m 42s Format dates 5m 12s Sort dates chronologically 5m 26s Obtain today's date 2m 9s Calculate elapsed time with DateDiff() 4m 43s Calculate time intervals with DateAdd() 4m 3s Challenge: Expand order details 33s Solution: Expand order details 5m 15s 7. Understanding Program Flow Functions 21m 2s IIf() conditional statement 2m 20s Create an IIf() function 5m 52s Use the Switch() function 6m 26s Challenge: Calculate sales price for a product line 27s Solution: Calculate sales price for a product line 5m 57s 8. Alternative Query Types 32m 1s Find duplicate records 4m 20s Identify unmatched records 3m 34s Create an unmatched records query 2m 34s Make a crosstab query 2m 35s Add information to a crosstab query 5m 46s Create a backup of the database 1m 40s Update data with a query 4m 41s Make table, delete, and append queries 6m 51s 9. Writing Queries with Structured Query Language 13m 59s Explore the basics of SQL 5m 59s Create a union query to join tables 3m 52s Nest SQL code in other queries 4m 8s 10. Useful Query Tricks 17m 16s Pull random records from the database 2m 46s Return records above or below the average 4m 8s Process a column of values with domain functions 5m 43s Challenge: Identify the highest and lowest pricing markup 25s Solution: Identify the highest and lowest pricing markup 4m 14s Conclusion 46s Next steps 46s
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}