Lynda - Access 2013 Queries In Depth
File List
- 03. Creating Simple Select Queries/03_01-Defining criteria.mp4 17.0 MB
- 06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp4 16.8 MB
- 03. Creating Simple Select Queries/03_05-Working with joins.mp4 16.7 MB
- 11. Useful Query Tricks/11_01-Using domain functions.mp4 16.3 MB
- 07. Working with Dates in Queries/07_03-Using date and time functions.mp4 16.3 MB
- 07. Working with Dates in Queries/07_07-Calculating time intervals.mp4 16.1 MB
- 04. Creating Parameter Queries/04_03-Creating a combo box.mp4 15.9 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.3 MB
- 09. Alternative Query Types/09_06-Making, deleting, and appending records.mp4 15.2 MB
- 09. Alternative Query Types/09_05-Creating update queries.mp4 13.5 MB
- 04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp4 13.3 MB
- 09. Alternative Query Types/09_03-Creating crosstab results.mp4 13.1 MB
- 03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp4 13.0 MB
- 07. Working with Dates in Queries/07_05-Sorting formatted dates.mp4 12.9 MB
- 10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp4 12.8 MB
- 08. Understanding Program Flow Functions/08_03-Using the Switch function.mp4 12.8 MB
- 08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp4 12.7 MB
- 07. Working with Dates in Queries/07_04-Formatting dates.mp4 12.5 MB
- 04. Creating Parameter Queries/04_01-Understanding parameter queries.mp4 12.3 MB
- 10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp4 11.8 MB
- 07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp4 11.7 MB
- Exercice Files/Ex_Files_Access2013_QiD.zip 11.7 MB
- 06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp4 11.3 MB
- 01. Introduction/01_03-Introducing the database.mp4 11.1 MB
- 02. Creating Queries in Access/02_02-Using the Query Wizard.mp4 10.9 MB
- 02. Creating Queries in Access/02_01-Understanding queries.mp4 10.8 MB
- 02. Creating Queries in Access/02_03-Exploring the design interface.mp4 10.5 MB
- 04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp4 10.3 MB
- 10. Exploring SQL Syntax/10_03-Writing a union query.mp4 9.5 MB
- 11. Useful Query Tricks/11_02-Returning values above or below average.mp4 9.2 MB
- 07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp4 9.1 MB
- 10. Exploring SQL Syntax/10_02-Writing SQL queries.mp4 9.0 MB
- 11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp4 8.7 MB
- 07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp4 8.1 MB
- 09. Alternative Query Types/09_02-Identifying unmatched records.mp4 8.0 MB
- 05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp4 7.8 MB
- 06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp4 7.8 MB
- 03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp4 7.6 MB
- 09. Alternative Query Types/09_01-Finding duplicate records.mp4 7.6 MB
- 07. Working with Dates in Queries/07_06-Defining today`s date.mp4 7.6 MB
- 01. Introduction/01_01-Welcome.mp4 7.3 MB
- 05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp4 6.9 MB
- 08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp4 6.7 MB
- 03. Creating Simple Select Queries/03_03-Renaming the column headers.mp4 6.2 MB
- 11. Useful Query Tricks/11_03-Returning random records from the database.mp4 5.3 MB
- 03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp4 5.1 MB
- 08. Understanding Program Flow Functions/08_01-Introducing IIf.mp4 3.8 MB
- 09. Alternative Query Types/09_04-Creating backups.mp4 2.9 MB
- 12. Conclusion/12_01-Next steps.mp4 2.1 MB
- 07. Working with Dates in Queries/07_08-Challenge Collect information on all orders from 2014.mp4 1.7 MB
- 04. Creating Parameter Queries/04_04-Challenge Build a query that produces an employee phone list.mp4 1.7 MB
- 03. Creating Simple Select Queries/03_06-Challenge Find the top ten employees.mp4 1.6 MB
- 05. Getting Started with Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp4 1.5 MB
- 08. Understanding Program Flow Functions/08_04-Challenge Calculate sales prices for a product line.mp4 1.4 MB
- 11. Useful Query Tricks/11_04-Challenge Find out which products have the highest and lowest markup percentage.mp4 1.4 MB
- 01. Introduction/01_02-Using the exercise files.mp4 741.5 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.