Lynda Access 2016 Queries in Depth | 40D6BD4D7C81185EE403A6C58FC8BEF1B19289AF

Lynda Access 2016 Queries in Depth

Name	Lynda-Access 2016 Queries in Depth	DOWNLOAD Copy Link
Total Size	740.5 MB
Total Files	63
Hash	40D6BD4D7C81185EE403A6C58FC8BEF1B19289AF

/
Readme.txt	1.3 KB
004 Explaining the challenges.mp4	393.8 KB
002 Using the exercise files.mp4	1.1 MB
043 Challenge - Calculate sales price for a product line.mp4	1.6 MB
059 Challenge - Identify the highest and lowest pricing markup.mp4	1.6 MB
025 Challenge - Convert US dollars to Canadian dollars.mp4	1.6 MB
015 Challenge - Create a select query.mp4	1.8 MB
038 Challenge - Expand order details.mp4	1.8 MB
020 Challenge - Gather employee emails based on department.mp4	2.0 MB
061 Next steps.mp4	2.4 MB
050 Create a backup of the database.mp4	4.5 MB
003 Trusting the exercise files.mp4	4.7 MB
029 Use the WHERE clause.mp4	5.2 MB
040 IIf() conditional statement.mp4	5.6 MB
035 Obtain today`s date.mp4	5.9 MB
048 Make a crosstab query.mp4	6.7 MB
026 Solution - Convert US dollars to Canadian dollars.mp4	7.3 MB
047 Create an unmatched records query.mp4	7.3 MB
056 Pull random records from the database.mp4	8.2 MB
016 Solution - Create a select query.mp4	8.2 MB
012 Rename the column headers.mp4	8.4 MB
031 Select a range of dates or times.mp4	8.5 MB
011 Use wildcards in criteria.mp4	8.8 MB
001 Welcome.mp4	9.2 MB
046 Identify unmatched records.mp4	9.7 MB
060 Solution - Identify the highest and lowest pricing markup.mp4	10.4 MB
054 Create a union query to join tables.mp4	10.9 MB
037 Calculate time intervals with DateAdd().mp4	11.1 MB
045 Find duplicate records.mp4	11.3 MB
010 Understand comparison operators.mp4	11.7 MB
027 Summarize data with aggregate functions.mp4	11.9 MB
022 Explore the Expression Builder interface.mp4	12.0 MB
055 Nest SQL code in other queries.mp4	12.3 MB
057 Return records above or below the average.mp4	12.3 MB
032 Date and time functions.mp4	12.9 MB
036 Calculate elapsed time with DateDiff().mp4	13.2 MB
030 Dates as serial numbers.mp4	13.2 MB
039 Solution - Expand order details.mp4	13.5 MB
051 Update data with a query.mp4	13.9 MB
044 Solution - Calculate sales price for a product line.mp4	13.9 MB
033 Format dates.mp4	14.2 MB
019 Use a combo box to select criteria.mp4	15.2 MB
034 Sort dates chronologically.mp4	15.4 MB
006 Understand queries.mp4	15.4 MB
053 Explore the basics of SQL.mp4	16.1 MB
049 Add information to a crosstab query.mp4	16.2 MB
007 Create a query with the wizard.mp4	16.3 MB
028 Understand the Totals field.mp4	16.6 MB
017 Understand parameter queries.mp4	16.7 MB
041 Create an IIf() function.mp4	16.7 MB
058 Process a column of values with domain functions.mp4	16.9 MB
005 The H+ Sport database.mp4	17.1 MB
042 Use the Switch() function.mp4	17.5 MB
021 Solution - Gather employee emails based on department.mp4	18.4 MB
023 Use mathematical operators.mp4	18.7 MB
014 Work with joins.mp4	18.7 MB
052 Make table, delete, and append queries.mp4	19.9 MB
013 Explore the property sheet.mp4	20.7 MB
018 Obtain parameters from forms.mp4	22.6 MB
008 Modify a query with the design interface.mp4	23.4 MB
009 Define query criteria.mp4	23.4 MB
024 Apply functions to text.mp4	23.7 MB
Ex_Files_Ac2016_QueriesID.zip	33.6 MB
Total files 63