MS Access is a Microsoft Relational Database Management System (RDBMS) - MS Access & SQL Topics Covered as follows: MS - Access:- Understanding Databases

• Starting and Opening an Existing Database
• Moving Around in Access
• Understanding Datasheet View & Design View
• Using the Mouse Pointer to Navigate
• Using the Keyboard to Navigate

Creating Tables

• Creating a Database
• Creating a Table Using the Wizard
• Creating and Modifying a Table
• Adding Fields to Tables
• Adding and Editing Records
• Printing Tables
• Moving and Deleting Fields
• Deleting Records

Working with Tables

• Formatting a Table
• Modifying Field Properties
• Sorting Records in a Table
• Finding Records in a Table
• Using Filters with a Table
• Establishing Relationships Between Tables
• Creating Subdatasheets
• Importing Records From an External Source

Designing a Form

• Creating a Form Using Auto Form
• Creating a Form Using the Form Wizard
• Adding Controls to a Form
• Modifying Control Properties
• Resizing and Moving Controls
• Entering Records into a Form
• Creating Calculated Controls

Designing a Report

• Creating a Report Using Auto Report
• Creating a Report Using Report Wizard
• Adding a Control to a Report
• Formatting a Report
• Resizing and Moving Controls
• Creating Calculated Controls

Creating and Using Queries

• Creating and Running a Query
• Specifying Criteria in a Query
• Using Comparison Operators
• Creating a Calculated Field
• Creating a Multiple-Table Query
• Printing a Query

Automating Tasks

• Creating an Auto Keys Macro
• Using Controls to Run a Macro
• Assigning a Macro to an Event
• Assigning a Macro to a Condition
• Testing and Debugging a Macro

  SQL:- SQL Overview

• Relational database concepts, specific products
• SQL syntax rules
• Data definition, data manipulation, and data control statements
• Getting acquainted with the course database and editor

SQL SELECT statements

• Clauses
• The SELECT clause: columns and aliases, where expressions, order by expressions how null Values behave

SQL Functions and Expressions

• Eliminating duplicates with DISTINCT arithmetic expressions
• Replacing null values
• Numeric operations, including rounding
• Date and time functions
• Nested table expressions
• Case logic
• Other expressions in specific DBMS Products

SQL Updating

• The INSERT, UPDATE and DELETE statements
• Column constraints and defaults
• Referential integrity constraints

SQL Joins

• Inner joins with original and SQL 92 syntax
• Table aliases
• Left, right, and full outer joins, Inner joins
• Self-joins

SQL Sub Queries and Unions

• Intersection with IN, and, Between
• Subqueries
• The difference with IS NULL and IS NOT NULL subqueries
• The purpose and usage of UNION and UNION ALL

SQL Summarization

• The column functions MIN, MAX, AVG, SUM and COUNT, UPPER, LENGTH, LOWER
• The GROUP BY and HAVING clauses Grouping in a combination with joining