Access Query and Reports

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Using Simple Queries

· Using Queries

· The Simple Query Wizard

· Creating a Query in Design View

· Opening and Running a Query

· Adding a Table to a Query

Modifying Query Results

· Sorting and Printing a Query

· Adding Criteria to and Hiding a Field in a Query

Creating Basic Reports

· Using the Report Wizard

· Using AutoReport

· Working in Print Preview

· Basing a Report on a Query

· Grouping and Summarising Report Data

Using Queries with Operators

· Using Comparison Operators

· Using the And Condition

· Using the Or Condition

· Using the Between...And Operator

· Using the Expression Builder

· Using Wildcard Characters

Designing Advanced Queries

· Setting Top Values

· Creating and Formatting Calculated Fields

· Creating a Function Query (overview)

· Creating a Parameter Query

· Creating a Concatenation Query (overview)

· Filter a Query


Creating Action Queries (Overview Only)

· Creating a Make-table Query

· Creating an Update Query

· Creating an Append Query

· Creating a Delete Query

Using Advanced Query Wizards (Overview Only)

· Using the Crosstab Query Wizard

· The Find Duplicates Query Wizard

· The Find Unmatched Query Wizard
...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

HTML
HTML/CSS Advanced
Programming in VBA using Access
Programming in VBA using Excel
Programming in VBA Using Word
Visual Basic
Certificate III in Business Administration
Certificate IV in Business Administration
Excel Formulas and Functions
Excel Pivot Tables & Filtering

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.