Data Management Challenges in Access - Demystified
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.
417 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Management Challenges in Access - Demystified to your Wishlist.

Add to Wishlist

Data Management Challenges in Access - Demystified

Learn effective Data management techniques and functionalities in 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.
417 students enrolled
Created by GreyCampus Inc.
Last updated 10/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
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Select query
  • Running a Select Query
  • The Query Design Window
  • Creating a query from the query window
  • Adding fields to a query, Display/Suppress the display of a field
  • Specifying Text, numeric, date, and logic criteria
  • Specifying sub string searches using wild Card Characters
  • Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  • Types of queries - Make Table Query, Append Query, Delete Query, Update Query
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

Data is better protected and maintained when it can be shared using a database instead of creating new iterations of the same data stored in new files for every new application. This course enables database users to explore the powerful features of queries.

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

  • Select query
  • Running a Select Query
  • The Query Design Window
  • Creating a query from the query window
  • Adding fields to a query, Display/Suppress the display of a field
  • Specifying Text, numeric, date, and logic criteria
  • Specifying sub string searches using wild Card Characters
  • Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  • Types of queries - Make Table Query, Append Query, Delete Query, Update Query
Who is the target audience?
  • Very much advantageous to novice who would like to master in Access Database
  • This course helps you to refresh your Access Knowledge and also update your skills with the new Access Techniques
  • Anyone new to Microsoft Access
Compare to Other Microsoft Access Courses
Curriculum For This Course
22 Lectures
03:12:43
+
Course Introduction
1 Lecture 03:21
+
Select query
2 Lectures 23:48
+
Running a Select Query
1 Lecture 11:03
Running a Select Query
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 15:13
+
Multiple Table Queries
1 Lecture 13:44
Multiple Table Queries
13:44
10 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
2,211 Reviews
26,806 Students
53 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.