Course Outline

Queries

  • The types of queries
  • Query Wizard
  • Query Design View
  • query Properties
  • Grouping in Queries
  • Create a simple select query
  • Crosstab queries
  • Query the search duplicates
  • Not matching the search query data
  • Parameter queries
  • Queries (forming a table, delete, append, updating)
  • Create a table with a query
  • Archiving data using an append query
  • Troubleshoot queries

Expressions in Queries

  • Examples of the use of expressions
  • Calculations in queries
  • Functions

SQL in Access

  • Download the data
  • Restrict results
  • Sorting Data
  • SQL Functions
  • Aggregating data using the grouping
  • Retrieving data from multiple tables
  • subqueries
  • Operators collective

Requirements

Knowledge of Windows

  14 Hours
 

Testimonials

Related Courses

MS Word Basic

  14 hours

Word Advanced

  14 hours

Word 2019 - Part 1

  7 hours

Advanced MS PowerPoint

  7 hours

Advanced PowerPoint for sales teams

  7 hours

Creating Slide Decks for the Financial World

  7 hours

Delivering Impressive Presentation Decks - Social Skills Workshop

  14 hours

Advanced Slide Design in PowerPoint

  7 hours

PowerPoint and Camtasia for Marketing

  21 hours

Excel Advanced with VBA

  21 hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

  21 hours

Visual Basic for Applications (VBA) in Excel - Advanced

  14 hours

Visual Basic for Applications (VBA) in Excel (intermediate level)

  14 hours

Excel and VBA Programming for Audit and Finance Professionals

  28 hours

Data and Analytics - from the ground up

  42 hours