Mastering Analysis Techniques of Databases
0.0 (0 ratings)
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.
1,082 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Analysis Techniques of Databases to your Wishlist.

Add to Wishlist

Mastering Analysis Techniques of Databases

Ms Access
0.0 (0 ratings)
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.
1,082 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The Query Design Window
  • Creating a query from the query window
  • Adding fields to a query, Display/Suppress the display of a field
  • Specifying sub string searches using wild Card Characters
  • Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  • Creating Reports using Wizard and Design Window
  • Working with Report Layout View and use Design view to create simple reports
  • Including Subtotals, Headers and Footers
View Curriculum
Requirements
  • Some knowledge of basic computing, and databases; familiarity with the Microsoft Office work environment. Knowledge of database design terms would be an added advantage.
Description

Microsoft Access queries and reports let you slice and dice your data and present it in detail or summary form regardless of how the data is. It also offers a great deal of power and flexibility to analyze and present results. This course empowers you with the techniques used in analyzing Access data sets.

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

  • The Query Design Window
  • Creating a query from the query window
  • Adding fields to a query, Display/Suppress the display of a field
  • Specifying sub string searches using wild Card Characters
  • Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  • Creating Reports using Wizard and Design Window
  • Working with Report Layout View and use Design view to create simple reports
  • Including Subtotals, Headers and Footers
Who is the target audience?
  • This course helps you to refresh your Access Knowledge and also update your skills with the new Access Techniques
  • Very much advantageous to novice who would like to master in Access Database
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
03:09:16
+
Course Introduction
1 Lecture 02:42
+
Select query
1 Lecture 23:48
+
Running a Select Query
1 Lecture 11:03
+
The Query Design Window
1 Lecture 06:54
The Query Design Window
06:54
+
Adding fields to a query, Display/Suppress the display of a field
1 Lecture 19:06
Adding fields to a query, Display/Suppress the display of a field
19:06
+
Removing fields from a query
1 Lecture 03:05
Removing fields from a query
03:05
+
Specifying sub string searches using wild Card Characters
1 Lecture 14:03
Specifying sub string searches using wild Card Characters
14:03
+
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
1 Lecture 13:16
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
13:16
+
Calculated fields
1 Lecture 12:09
Calculated fields
12:09
+
Creating Reports using Wizard
1 Lecture 09:09
Creating Reports using Wizard
09:09
6 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
1,996 Reviews
25,129 Students
51 Courses
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.