Linkedin Learning Access 2021 Queries-XQZT

Another exquisit release
Linkedin.Learning.Access.2021.Queries-XQZT
     Title: Access 2021: Queries
 Publisher: Linkedin Learning
  Category: N/A
      Size: 829M
     Files: 9F
      Date: 2022-02-14
  Course #: 3017060
 Published: Linkedin.Learning
   Updated: N/A
       URL: https://linkedin.com/learning/access-2021-queries
    Author: Adam Wilbert
  Duration: 4:29:32
 Exer/Code: [X]
Installation:
Unpack that shit, run that shit
Description:
Learn how to craft better queriesthe key to finding raw data and
transforming it into something usablein Access 2021.

8.1M	01.01-do_more_with_access_queries.mkv
6.1M	01.02-trust_the_exercise_files.mkv
12M	02.01-the_red30_tech_database.mkv
22M	02.02-understand_queries.mkv
18M	02.03-create_a_query_with_the_query_wizard.mkv
20M	02.04-explore_the_query_design_view.mkv
16M	02.05-build_a_query_in_design_view.mkv
22M	03.01-define_query_criteria.mkv
9.9M	03.02-understand_comparison_operators.mkv
13M	03.03-use_wildcards_in_criteria.mkv
14M	03.04-rename_the_column_headers.mkv
26M	03.05-explore_the_property_sheet.mkv
15M	03.06-work_with_joins.mkv
1.6M	03.07-challenge_create_a_select_query.mkv
19M	03.08-solution_create_a_select_query.mkv
20M	04.01-understand_parameter_queries.mkv
26M	04.02-obtain_parameters_from_forms.mkv
17M	04.03-use_a_combo_box_to_select_criteria.mkv
6.6M	04.04-requery_with_a_button_macro.mkv
1.4M	04.05-challenge_gather_products_by_category.mkv
28M	04.06-solution_gather_products_by_category.mkv
15M	05.01-explore_the_expression_builder_interface.mkv
19M	05.02-use_mathematical_operators.mkv
21M	05.03-apply_functions_to_text.mkv
1.3M	05.04-challenge_convert_us_dollars_to_canadian_dollars.mkv
12M	05.05-solution_convert_us_dollars_to_canadian_dollars.mkv
16M	06.01-summarize_data_with_aggregate_functions.mkv
15M	06.02-understand_the_totals_field.mkv
8.4M	06.03-calculate_a_sum_total.mkv
7.0M	06.04-using_the_where_clause.mkv
13M	07.01-select_a_range_of_dates_or_times.mkv
19M	07.02-date_and_time_functions.mkv
16M	07.03-format_dates.mkv
16M	07.04-sort_dates_chronologically.mkv
12M	07.05-obtain_todays_date.mkv
15M	07.06-calculate_elapsed_time_with_datediff().mkv
14M	07.07-calculate_time_intervals_with_dateadd().mkv
1.4M	07.08-challenge_expand_order_details.mkv
21M	07.09-solution_expand_order_details.mkv
5.1M	08.01-iif()_conditional_statement.mkv
18M	08.02-create_an_iif()_function.mkv
25M	08.03-use_the_switch()_function.mkv
1.6M	08.04-challenge_calculate_sales_price_for_a_product_line.mkv
15M	08.05-solution_calculate_sales_price_for_a_product_line.mkv
14M	09.01-find_duplicate_records.mkv
6.5M	09.02-identify_unmatched_records.mkv
7.6M	09.03-create_an_unmatched_records_query.mkv
9.3M	09.04-make_a_crosstab_query.mkv
5.5M	09.05-create_a_backup_of_the_database.mkv
13M	09.06-update_data_with_a_query.mkv
21M	09.07-make_table_delete_and_append_queries.mkv
12M	10.01-explore_the_basics_of_sql.mkv
15M	10.02-create_a_union_query_to_join_tables.mkv
18M	10.03-nest_sql_code_in_other_queries.mkv
11M	11.01-pull_random_records_from_the_database.mkv
13M	11.02-return_records_above_or_below_average.mkv
22M	11.03-process_a_column_of_values_with_domain_functions.mkv
952K	11.04-challenge_identify_the_highest_and_lowest_pricing_markup.mkv
25M	11.05-solution_identify_the_highest_and_lowest_pricing_markup.mkv
2.0M	12.01-next_steps.mkv
26M	Ex_Files_Access_2021_Queries.zip
826M	total