Pluralsight - Access 2013: Queries in Depth [repost]

Discussion in 'E-Books & Tutorials' started by Romanpower, Jul 22, 2015.

  1. Romanpower

    Romanpower Member

    Joined:
    Jul 14, 2015
    Messages:
    170
    Likes Received:
    1
    Trophy Points:
    16
    Gender:
    Female
    [​IMG]

    Pluralsight - Access 2013: Queries in Depth
    MP4 | AVC 161kbps | English | 1280x720 | 15fps | 4h 23mins | AAC stereo 128kbps | 546 MB
    Genre: Video Training

    Get more out of your Access database than just the data you put into it, using queries-tools that help you translate complex raw data into information you can use to make better decisions. Join Adam Wilbert, as he explains how to create real-world queries to filter and sort data, perform calculations, and 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, and increase accuracy and consistency in your database using program flow functions.

    Introduction
    Welcome
    Using the exercise files
    Introducing the database

    1. Creating Queries in Access
    Understanding queries
    Using the Query Wizard
    Exploring the design interface

    2. Creating Simple Select Queries
    Defining criteria
    Understanding comparison operators
    Renaming the column headers
    Exploring the property sheet
    Working with joins
    Challenge: Find the top ten employees
    Solution: Find the top ten employees

    3. Creating Parameter Queries
    Understanding parameter queries
    Obtaining parameters from forms
    Creating a combo box
    Challenge: Build a query that produces an employee phone list
    Solution: Build a query that produces an employee phone list

    4. Getting Started with Functions
    Exploring the Expression Builder interface
    Using mathematical operators
    Applying functions to text
    Challenge: Convert US dollars to Canadian dollars
    Solution: Convert US dollars to Canadian dollars

    5. Applying Aggregate Calculations
    Creating aggregate calculations
    Understanding the Totals field
    Understanding the WHERE clause

    6. Working with Dates in Queries
    Understanding how dates are stored
    Specifying a range of dates or times
    Using date and time functions
    Formatting dates
    Sorting formatted dates
    Defining today.s date
    Calculating time intervals
    Challenge: Collect information on all orders from 2014
    Solution: Collect information on all orders from 2014

    7. Understanding Program Flow Functions
    Introducing IIf
    Creating an IIf function
    Using the Switch function
    Challenge: Calculate sales prices for a product line
    Solution: Calculate sales prices for a product line

    8. Alternative Query Types
    Finding duplicate records
    Identifying unmatched records
    Creating crosstab results
    Creating backups
    Creating update queries
    Making, deleting, and appending records

    9. Exploring SQL Syntax
    Understanding SQL basics
    Writing SQL queries
    Writing a union query
    Embedding SQL code in queries

    10. Useful Query Tricks
    Using domain functions
    Returning values above or below average
    Returning random records from the database
    Challenge: Find out which products have the highest and lowest markup percentage
    Solution: Find out which products have the highest and lowest markup percentage

    Conclusion
    Next steps

    [​IMG]

    [​IMG]

    [​IMG]

    Code:
    http://xxxxxxxx.net/file/aba8e70b71eea81881e8d42a95ea9406/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part1.rar.html
    http://xxxxxxxx.net/file/4ff69e1624cedbf737c0bfdaf1ed7548/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part2.rar.html
    http://xxxxxxxx.net/file/610119c44a05ee95f2bee97a72d8bffd/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part3.rar.html
    http://xxxxxxxx.net/file/6372f5bc2f42956117aa2abdb6272b9f/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part4.rar.html
    http://xxxxxxxx.net/file/d40455648850e006fc363d43597a684d/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part5.rar.html
    
    http://xxxxxxxx.net/file/xcbsk8lp/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part1.rar
    http://xxxxxxxx.net/file/6uw274gc/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part2.rar
    http://xxxxxxxx.net/file/xy63dnme/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part3.rar
    http://xxxxxxxx.net/file/tt0id14o/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part4.rar
    http://xxxxxxxx.net/file/bczjvyqb/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part5.rar
    
    http://www.nitroflare.com/view/4585CD340DD8226/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part1.rar
    http://www.nitroflare.com/view/327AECD1A79571F/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part2.rar
    http://www.nitroflare.com/view/A20BB5E0B272A44/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part3.rar
    http://www.nitroflare.com/view/26F5188986DD238/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part4.rar
    http://www.nitroflare.com/view/929C8829E6C67F3/8ywzn.Pluralsight.Access.2013.Queries.in.Depth.repost.part5.rar
    
    
     

Share This Page