Scribd
Upload
2 views2 pages

Lesson Plan for Database (Ms Access & SQL Query)

The document outlines a training schedule for Microsoft Access, covering topics such as database fundamentals, SQL commands, and data relationships over 12 sessions. Each session lasts 30 minutes and includes hands-on practice and practical applications like creating queries and forms. The training is structured to build skills progressively, starting from basic concepts to more advanced SQL techniques and data management.

Uploaded by

Khinsandar Naing
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views2 pages

Lesson Plan for Database (Ms Access & SQL Query)

The document outlines a training schedule for Microsoft Access, covering topics such as database fundamentals, SQL commands, and data relationships over 12 sessions. Each session lasts 30 minutes and includes hands-on practice and practical applications like creating queries and forms. The training is structured to build skills progressively, starting from basic concepts to more advanced SQL techniques and data management.

Uploaded by

Khinsandar Naing
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Sr Sessions Descriptions Week Duration

1. Introduction to Microsoft  Database Fundamentals 1 30 Mins


Access & Database  What is a database?
Fundamentals  Tables, records, and fields
 Primary keys and
relationships
 Access Interface Tour
- Navigation pane
- Ribbon tabs and
commands
- Object types (tables,
queries, forms, reports)
- Backstage view

2. Creating a Simple Database 1 30 Mins


in Access  SQL Commands
 Create a new database
 Create a table in Design
View
 Enter sample data in
Datasheet View
 Delete Tables
 Primary Key creation
 Properties Sheet and Fields
Properties

3. Data Adding and Table  Add data to tables 2 30 Mins


Relationships  One-to-many relationships
 Foreign keys
 Hands-on: Create related
tables
 Establish relationships in
Relationship View

4. Introduction to SQL in  What is SQL? 2 30 Mins


Access  Basic SELECT statement
structure
 Access SQL vs. standard
SQL
 Switching between Design
View and SQL View
 Basic selection queries
 Sorting and filtering
5. SQL Practice  Write queries from scratch 3 30 Mins
in SQL View
 Common errors and
debugging
 Formatting SQL for
readability

6. Hands-on Practice  Create queries with criteria 3 30 Mins


 Use AND/OR conditions
 Sort query results
 Save and run queries

7. Joining Tables in Access  INNER JOIN syntax 4 30 Mins


 Multi-table queries
 Hands-on: Create join
queries

8. Aggregate Functions  GROUP BY clause 4 30 Mins


 COUNT, SUM, AVG
functions
 HAVING clause vs.
WHERE
 IN and NOT IN operators
 EXISTS operator
 Wildcards
9. Indexing  Indexing 5 30 Mins
 Summarizing Data
 Unmatched Query Wizard

10. Form  Create form 5 30 Mins


 Navigate form
 Modify Form
11. Reports  Report Basic 6 30 Mins
 Formatting Report
12. Import, Export and Project  Access Project 6 30 Mins

You might also like