Lynda Access 2016 Queries in Depth Torrent Download Locations

Lynda-Access 2016 Queries in Depth
     Readme.txt -

     004 Explaining the challenges.mp4 -

     002 Using the exercise files.mp4 -

     043 Challenge - Calculate sales price for a product line.mp4 -

     059 Challenge - Identify the highest and lowest pricing markup.mp4 -

     025 Challenge - Convert US dollars to Canadian dollars.mp4 -

     015 Challenge - Create a select query.mp4 -

     038 Challenge - Expand order details.mp4 -

     020 Challenge - Gather employee emails based on department.mp4 -

     061 Next steps.mp4 -

     050 Create a backup of the database.mp4 -

     003 Trusting the exercise files.mp4 -

     029 Use the WHERE clause.mp4 -

     040 IIf() conditional statement.mp4 -

     035 Obtain today`s date.mp4 -

     048 Make a crosstab query.mp4 -

     026 Solution - Convert US dollars to Canadian dollars.mp4 -

     047 Create an unmatched records query.mp4 -

     056 Pull random records from the database.mp4 -

     016 Solution - Create a select query.mp4 -

     012 Rename the column headers.mp4 -

     031 Select a range of dates or times.mp4 -

     011 Use wildcards in criteria.mp4 -

     001 Welcome.mp4 -

     046 Identify unmatched records.mp4 -

     060 Solution - Identify the highest and lowest pricing markup.mp4 -

     054 Create a union query to join tables.mp4 -

     037 Calculate time intervals with DateAdd().mp4 -

     045 Find duplicate records.mp4 -

     010 Understand comparison operators.mp4 -

     027 Summarize data with aggregate functions.mp4 -

     022 Explore the Expression Builder interface.mp4 -

     055 Nest SQL code in other queries.mp4 -

     057 Return records above or below the average.mp4 -

     032 Date and time functions.mp4 -

     036 Calculate elapsed time with DateDiff().mp4 -

     030 Dates as serial numbers.mp4 -

     039 Solution - Expand order details.mp4 -

     051 Update data with a query.mp4 -

     044 Solution - Calculate sales price for a product line.mp4 -

     033 Format dates.mp4 -

     019 Use a combo box to select criteria.mp4 -

     034 Sort dates chronologically.mp4 -

     006 Understand queries.mp4 -

     053 Explore the basics of SQL.mp4 -

     049 Add information to a crosstab query.mp4 -

     007 Create a query with the wizard.mp4 -

     028 Understand the Totals field.mp4 -

     017 Understand parameter queries.mp4 -

     041 Create an IIf() function.mp4 -

     058 Process a column of values with domain functions.mp4 -

     005 The H+ Sport database.mp4 -

     042 Use the Switch() function.mp4 -

     021 Solution - Gather employee emails based on department.mp4 -

     023 Use mathematical operators.mp4 -

     014 Work with joins.mp4 -

     052 Make table, delete, and append queries.mp4 -

     013 Explore the property sheet.mp4 -

     018 Obtain parameters from forms.mp4 -

     008 Modify a query with the design interface.mp4 -

     009 Define query criteria.mp4 -

     024 Apply functions to text.mp4 -

     Ex_Files_Ac2016_QueriesID.zip -