Data Management Challenges in Access - Demystified

Learn effective Data management techniques and functionalities in MS Access
5.0 (2 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.
406 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 22
  • Length 3 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

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

What are the 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.

What am I going to get from this course?

  • 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

What 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

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
03:21
Section 2: Select query
Select query Part 1
Preview
09:03
Select query Part 2
Preview
14:45
Section 3: Running a Select Query
Running a Select Query
11:03
Section 4: The Query Design Window
The Query Design Window
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
15:13
Section 10: Multiple Table Queries
Multiple Table Queries
13:44
Section 11: Joining Tables for a query
Joining Tables for a query Part 1
17:24
Joining Tables for a query Part 2
14:57
Section 12: Join Properties - Inner and Outer Joins
Join Properties - Inner and Outer Joins
16:26
Section 13: Make Table Query
Make Table Query
09:38
Section 14: Append Query
Append Query
04:26
Section 15: Delete Query
Delete Query
02:04
Section 16: Update Query
Update Query
03:02
Section 17: Additional Material
Additional Material
Article
Section 18: Exercise
Exercise
Article
Section 19: Mock Test
Mock Test
20 questions
Section 20: Course Conclusion
Review Appreciated
Article
Bonus Lecture on Data Management Challenges in Access - Demystified
Article

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