[Lt]-Access 2016 Queries in Depth

seeders: 1

leechers: 2

Download torrent

Added on July 5, 2016 by signrcin Other > Tutorials
Torrent verified.

Main

add to bookmarks

[Lt]-Access 2016 Queries in Depth (Size: 706.2 MB)

		Readme.txt	1.29 KB
		004 Explaining the challenges.mp4	384.61 KB
		002 Using the exercise files.mp4	1.09 MB
		043 Challenge - Calculate sales price for a product line.mp4	1.48 MB
		059 Challenge - Identify the highest and lowest pricing markup.mp4	1.49 MB
		025 Challenge - Convert US dollars to Canadian dollars.mp4	1.54 MB
		015 Challenge - Create a select query.mp4	1.7 MB
		038 Challenge - Expand order details.mp4	1.74 MB
		020 Challenge - Gather employee emails based on department.mp4	1.93 MB
		061 Next steps.mp4	2.27 MB
		050 Create a backup of the database.mp4	4.25 MB
		003 Trusting the exercise files.mp4	4.49 MB
		029 Use the WHERE clause.mp4	4.94 MB
		040 IIf() conditional statement.mp4	5.36 MB
		035 Obtain today`s date.mp4	5.62 MB
		048 Make a crosstab query.mp4	6.44 MB
		026 Solution - Convert US dollars to Canadian dollars.mp4	6.95 MB
		047 Create an unmatched records query.mp4	6.96 MB
		056 Pull random records from the database.mp4	7.82 MB
		016 Solution - Create a select query.mp4	7.87 MB
		012 Rename the column headers.mp4	8.05 MB
		031 Select a range of dates or times.mp4	8.13 MB
		011 Use wildcards in criteria.mp4	8.41 MB
		001 Welcome.mp4	8.76 MB
		046 Identify unmatched records.mp4	9.25 MB
		060 Solution - Identify the highest and lowest pricing markup.mp4	9.89 MB
		054 Create a union query to join tables.mp4	10.42 MB
		037 Calculate time intervals with DateAdd().mp4	10.55 MB
		045 Find duplicate records.mp4	10.78 MB
		010 Understand comparison operators.mp4	11.16 MB

Description

Access 2016: Queries in Depth
Duration: 4h 9m
Level: Intermediate
Published Date: Jun 07, 2016
Subjects: Business IT, Access 2016

Learn how to find and translate complex raw data into information you can use to make better decisions, with Access queries. Access expert Adam Wilbert explains how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering challenges that help you master the material. Find out how to identify top performers, automate repetitive analysis tasks, make queries more flexible with parameter requests, and increase accuracy and consistency in your database using program flow functions. Adam closes with an assortment of useful query tricks. Take the challenges posed along the way to test and practice your new Access skills.
Topics include:
Creating a query with the wizard
Defining query criteria
Using comparison and wildcards in criteria
Working with joins
Creating parameter queries
Using the built-in functions in Access
Summarizing data
Aggregating records with totals
Working with dates
Creating alternative queries: unmatched, crosstab, and more
Writing queries with SQL

For Info:

h**ps://www.lynd@.com/Access-tutorials/Access-2016-Queries-Depth/455726-2.html

Sharing Widget

Download torrent

706.2 MB

seeders:1

leechers:2

[Lt]-Access 2016 Queries in Depth