Lynda Access 2016 Queries in Depth | AE602299FABC5BE1F76BB59A0A5322CF678293E3

Lynda Access 2016 Queries in Depth

Name	Lynda - Access 2016 - Queries in Depth	DOWNLOAD Copy Link
Total Size	740.5 MB
Total Files	62
Hash	AE602299FABC5BE1F76BB59A0A5322CF678293E3

/01. Introduction/
01_01-Welcome.mp4	9.2 MB
01_03-Trusting the exercise files.mp4	4.7 MB
01_02-Using the exercise files.mp4	1.1 MB
01_04-Explaining the challenges.mp4	393.8 KB
/02. Introduction to Access Queries/
02_04-Modify a query with the design interface.mp4	23.4 MB
02_01-The H Sport database.mp4	17.1 MB
02_03-Create a query with the wizard.mp4	16.3 MB
02_02-Understand queries.mp4	15.4 MB
/03. Creating Simple Select Queries/
03_01-Define query criteria.mp4	23.4 MB
03_05-Explore the property sheet.mp4	20.7 MB
03_06-Work with joins.mp4	18.7 MB
03_02-Understand comparison operators.mp4	11.7 MB
03_03-Use wildcards in criteria.mp4	8.8 MB
03_04-Rename the column headers.mp4	8.4 MB
03_08-Solution Create a select query.mp4	8.2 MB
03_07-Challenge Create a select query.mp4	1.8 MB
/04. Creating Parameter Queries/
04_02-Obtain parameters from forms.mp4	22.6 MB
04_05-Solution Gather employee emails based on department.mp4	18.4 MB
04_01-Understand parameter queries.mp4	16.7 MB
04_03-Use a combo box to select criteria.mp4	15.2 MB
04_04-Challenge Gather employee emails based on department.mp4	2.0 MB
/05. Use the BuiltIn Functions/
05_03-Apply functions to text.mp4	23.7 MB
05_02-Use mathematical operators.mp4	18.7 MB
05_01-Explore the Expression Builder interface.mp4	12.0 MB
05_05-Solution Convert US dollars to Canadian dollars.mp4	7.3 MB
05_04-Challenge Convert US dollars to Canadian dollars.mp4	1.6 MB
/06. Aggregating Records with a Totals Query/
06_02-Understand the Totals field.mp4	16.6 MB
06_01-Summarize data with aggregate functions.mp4	11.9 MB
06_03-Use the WHERE clause.mp4	5.2 MB
/07. Working with Dates in Queries/
07_05-Sort dates chronologically.mp4	15.4 MB
07_04-Format dates.mp4	14.2 MB
07_10-Solution Expand order details.mp4	13.5 MB
07_01-Dates as serial numbers.mp4	13.2 MB
07_07-Calculate elapsed time with DateDiff.mp4	13.2 MB
07_03-Date and time functions.mp4	12.9 MB
07_08-Calculate time intervals with DateAdd.mp4	11.1 MB
07_02-Select a range of dates or times.mp4	8.5 MB
07_06-Obtain todays date.mp4	5.9 MB
07_09-Challenge Expand order details.mp4	1.8 MB
/08. Understanding Program Flow Functions/
08_03-Use the Switch function.mp4	17.5 MB
08_02-Create an IIf function.mp4	16.7 MB
08_05-Solution Calculate sales price for a product line.mp4	13.9 MB
08_01-IIf conditional statement.mp4	5.6 MB
08_04-Challenge Calculate sales price for a product line.mp4	1.6 MB
/09. Alternative Query Types/
09_08-Make table, delete, and append queries.mp4	19.9 MB
09_05-Add information to a crosstab query.mp4	16.2 MB
09_07-Update data with a query.mp4	13.9 MB
09_01-Find duplicate records.mp4	11.3 MB
09_02-Identify unmatched records.mp4	9.7 MB
09_03-Create an unmatched records query.mp4	7.3 MB
09_04-Make a crosstab query.mp4	6.7 MB
09_06-Create a backup of the database.mp4	4.5 MB
/10. Writing Queries with Structured Query Language/
10_01-Explore the basics of SQL.mp4	16.1 MB
10_03-Nest SQL code in other queries.mp4	12.3 MB
10_02-Create a union query to join tables.mp4	10.9 MB
/11. Useful Query Tricks/
11_03-Process a column of values with domain functions.mp4	16.9 MB
11_02-Return records above or below the average.mp4	12.3 MB
11_05-Solution Identify the highest and lowest pricing markup.mp4	10.4 MB
11_01-Pull random records from the database.mp4	8.2 MB
11_04-Challenge Identify the highest and lowest pricing markup.mp4	1.6 MB
/12. Conclusion/
12_01-Next steps.mp4	2.4 MB
/Exercice Files/
Ex_Files_Ac2016_QueriesID.zip	33.6 MB
Total files 62