Mastering Analysis Techniques of Databases

Curriculum:
– Course Introduction 
– Select query 
– Running a Select Query 
– The Query Design Window 
– Adding fields to a query, displaying / suppressing the display of a field 
– Removing fields from a query 
– Specifying sub string searches using wild card characters 
– Working with Conditions – BETWEEN, AND, OR, NOT, NULL 
– Calculated fields 
– Creating Reports using Wizard 
– Working with a Report Layout View 
– Using a Design View to create simple reports 
– Including Subtotals, Headers and Footers 
– Additional Material 
– Exercise 
– Mock Test