01. Introduction/01_01-Welcome.mp4 7.29 MB
01. Introduction/01_02-Using the exercise files.mp4 741.49 KB
01. Introduction/01_03-Introducing the database.mp4 11.14 MB
02. Creating Queries in Access/02_01-Understanding queries.mp4 10.84 MB
02. Creating Queries in Access/02_02-Using the Query Wizard.mp4 10.94 MB
02. Creating Queries in Access/02_03-Exploring the design interface.mp4 10.5 MB
03. Creating Simple Select Queries/03_01-Defining criteria.mp4 16.96 MB
03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp4 5.14 MB
03. Creating Simple Select Queries/03_03-Renaming the column headers.mp4 6.21 MB
03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp4 12.97 MB
03. Creating Simple Select Queries/03_05-Working with joins.mp4 16.67 MB
03. Creating Simple Select Queries/03_06-Challenge Find the top ten employees.mp4 1.62 MB
03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp4 7.6 MB
04. Creating Parameter Queries/04_01-Understanding parameter queries.mp4 12.26 MB
04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp4 13.26 MB
04. Creating Parameter Queries/04_03-Creating a combo box.mp4 15.92 MB
04. Creating Parameter Queries/04_04-Challenge Build a query that produces an employee phone list.mp4 1.71 MB
04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp4 10.33 MB
05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp4 7.8 MB
05. Getting Started with Functions/05_02-Using mathematical operators.mp4 15.7 MB
05. Getting Started with Functions/05_03-Applying functions to text.mp4 15.31 MB
05. Getting Started with Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp4 1.45 MB
05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp4 6.87 MB
06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp4 11.27 MB
06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp4 16.79 MB
06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp4 7.75 MB
07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp4 9.09 MB
07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp4 8.12 MB
07. Working with Dates in Queries/07_03-Using date and time functions.mp4 16.34 MB
07. Working with Dates in Queries/07_04-Formatting dates.mp4 12.49 MB
07. Working with Dates in Queries/07_05-Sorting formatted dates.mp4 12.87 MB
07. Working with Dates in Queries/07_06-Defining today`s date.mp4 7.56 MB
07. Working with Dates in Queries/07_07-Calculating time intervals.mp4 16.14 MB
07. Working with Dates in Queries/07_08-Challenge Collect information on all orders from 2014.mp4 1.73 MB
07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp4 11.68 MB
08. Understanding Program Flow Functions/08_01-Introducing IIf.mp4 3.79 MB
08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp4 12.68 MB
08. Understanding Program Flow Functions/08_03-Using the Switch function.mp4 12.78 MB
08. Understanding Program Flow Functions/08_04-Challenge Calculate sales prices for a product line.mp4 1.42 MB
08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp4 6.68 MB
09. Alternative Query Types/09_01-Finding duplicate records.mp4 7.57 MB
09. Alternative Query Types/09_02-Identifying unmatched records.mp4 7.96 MB
09. Alternative Query Types/09_03-Creating crosstab results.mp4 13.13 MB
09. Alternative Query Types/09_04-Creating backups.mp4 2.86 MB
09. Alternative Query Types/09_05-Creating update queries.mp4 13.53 MB
09. Alternative Query Types/09_06-Making, deleting, and appending records.mp4 15.19 MB
10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp4 12.84 MB
10. Exploring SQL Syntax/10_02-Writing SQL queries.mp4 9.03 MB
10. Exploring SQL Syntax/10_03-Writing a union query.mp4 9.45 MB
10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp4 11.77 MB
11. Useful Query Tricks/11_01-Using domain functions.mp4 16.35 MB
11. Useful Query Tricks/11_02-Returning values above or below average.mp4 9.15 MB
11. Useful Query Tricks/11_03-Returning random records from the database.mp4 5.28 MB
11. Useful Query Tricks/11_04-Challenge Find out which products have the highest and lowest markup percentage.mp4 1.38 MB
11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp4 8.65 MB
12. Conclusion/12_01-Next steps.mp4 2.07 MB
Exercice Files/Ex_Files_Access2013_QiD.zip 11.68 MB
Download Info
Tips
“Lynda - Access 2013 Queries In Depth” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.
