Description
Course Content
Planning and Designing Databases
♦ Database Objective
♦ Scope Document
♦ Overview of creating a Database
Select Queries
♦ Data Sources
♦ Field Selection
♦ Multiple Sorts
♦ Selection Criteria Overview
♦ Complex Selection Criteria
♦ Show/Hide
♦ Logical Operators
♦ Wildcards
♦ Unique Values
♦ Parameters
♦ Totals
♦ Calculated Fields
Creating a CrossTab Query
♦ Using the wizard
♦ Applying formats
♦ Re-arrange the Pivot Layout
Find Duplicates Wizard
♦ Find Matching Data
♦ Clean a Table of duplicate entries
Multi-Table Select Queries
♦ Table Order
♦ Creating Temporary Relationships
♦ Query Join Types
Find Unmatched Query Wizard
♦ Compare records in two Tables
♦ Locate mismatched records
Calculated Queries
♦ Using Formulae Functions in a Query
♦ Concatenate (join fields together)
♦ Extract parts of data using Left/Mid/Right functions
Action Queries – Overview
Update Query
♦ Update Records Quickly
♦ Search and replace data
Append Query
♦ Merge fields and records to new Table
♦ Merge data to existing Table
Make Table Query
♦ Convert Query results to a Table
♦ Use for static reporting results
Delete Query
♦ Delete records based on multi criteria
♦ Delete single or block records from Table
Course Duration: One Day