The 3 Musketeers of Database - Online Self Learning

Although tables store all of your data, the other three objects—forms, queries, and reports—offer you ways to work with it. Each of these objects interacts with the records stored in your database's tables. This course allows you to unleash these objects and use your relational database efficiently.

USD 199

Enroll
1-Year Access
Hands-on videos
Excercises
Quizes

Course Description:

Although tables store all of your data, the other three objects—forms, queries, and reports—offer you ways to work with it. Each of these objects interacts with the records stored in your database's tables. This course allows you to unleash these objects and use your relational database efficiently.

Objectives:

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Explore the Query Design Window
  • Adding fields to a query, Display/Suppress the display of a field
  • Creating Forms using Wizard and Form Layout View
  • Properties of Different Controls & Forms
  • Using Controls in Forms (Command Button, Labels, Textbox, Combo Box, Etc.
  • Working with Report Layout View and Design view to create simple reports
  • Including Subtotals, Headers and Footers

Course Inclusions:

  • 1-year e-learning access
  • Audio-Video Lectures
  • Hands-on videos
  • Assignements
  • Additional Materail
  • Mock Exams
  • Course Completion certificate

Course Cirrculum:

  1. Select query
  2. Running a Select Query
  3. Creating a query from the query window
  4. Adding fields to a query, Display/Suppress the display of a field
  5. Removing fields from a query
  6. Specifying sub string searches using wild Card Characters
  7. Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  8. Calculated fields
  9. Creating forms using Wizard
  10. Working with Form Layout View
  11. Using Design view
  12. Introducing Sub Forms
  13. Properties of Different Controls & Forms
  14. Using Controls in Forms (Command Button, Labels, TextBox, ComboBox, Etc.)
  15. Creating Reports using Wizard
  16. Working with Report Layout View
  17. Using Design view to create simple reports
  18. Including Subtotals, Headers and Footers

Prerequisties:

Basic knowledge of computing, and databases; familiarity with the Microsoft Office work environment. Knowledge of database design terms would be an added advantage.

FAQ's:

1. How do I get certified?

A: Visit the page for more details:

https://www.microsoft.com/learning/en-in/exam-77-885.aspx

Please note – This module only covers a part of the actual MOS curriculum. 

2.  What are the Pre-requisites for this course?

A: Basic knowledge of computing, and databases; familiarity with the Microsoft Office work environment. Knowledge of database design terms would be an added advantage.