The 3 Musketeers of Database

An easiest way of learning about the three most important topics in Database viz. forms, queries and reports.
5.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
481 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 22
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

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.

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

What are the requirements?

  • A basic knowledge on computer,internet and MS Excel
  • Knowledge of database design terms would be an added advantage.

What am I going to get from this course?

  • 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

What is the target audience?

  • A clear description on the important topics in Databases viz. Forms,Queries & Reports
  • Very much advantageous to novice who would like to master in Access Database

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Introduction
Preview
02:45
Section 2: Select query
Select query
Preview
23:48
Section 3: Running a Select Query
Running a Select Query
11:03
Section 4: The Query Design Window
The Query Design Window
Preview
06:54
Section 5: Adding fields to a query, Display/Suppress the display of a field
Adding fields to a query, Display/Suppress the display of a field
19:06
Section 6: Removing fields from a query
Removing fields from a query
03:05
Section 7: Specifying sub string searches using wild Card Characters
Specifying sub string searches using wild Card Characters
14:03
Section 8: Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
13:16
Section 9: Calculated fields
Calculated fields
Preview
12:09
Section 10: Creating Forms using Wizard
Creating Forms using Wizard
05:29
Section 11: Working with Form Layout View
Working with Form Layout View
06:55
Section 12: Using Design view
Using Design view
04:37
Section 13: Introducing Sub Forms
Introducing Sub Forms
08:44
Section 14: Properties of Different Controls & Forms
Properties of Different Controls & Forms
09:05
Section 15: Using Controls in Forms (Command Button, Labels, TextBox, ComboBox, Etc.)
Using Controls in Forms (Command Button, Labels, TextBox, ComboBox, Etc.)
13:20
Section 16: Creating Reports using Wizard
Creating Reports using Wizard
09:09
Section 17: Working with Report Layout View
Working with Report Layout View
07:05
Section 18: Using Design view to create simple reports
Using Design view to create simple reports
Preview
42:15
Section 19: Including Subtotals, Headers and Footers
Including Subtotals, Headers and Footers
24:36
Section 20: Additional Material
Additional Material
Article
Section 21: Exercise
Exercise
Article
Section 22: Course Conclusion
Review Appreciated!
Article
Section 23: Mock Test
Mock Test
20 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course