Mastering Database Concepts - The Access Way

Basic guide to master in Database concepts
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.
495 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 12
  • Length 1.5 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

Databases are required in almost every enterprise section of today like banks, hospitals, post offices, fast food restaurants, travel agencies and you name it. Not only in the above mentioned areas,it also plays a major key role in different social networking sites like Facebook,Twitter,Google+ and many more,which handles a huge Database. This course focuses on hand-on methods that enterprises use to store or extract data instantly. Data manipulation techniques have been demonstrated which allows you to analyze data as per business requirements.

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

  • Switching Views in Access
  • Entering and Editing Data
  • Working in Data Entry Mode
  • Sorting Data, Finding & Replacing Data
  • Importing from Access and Excel
  • Linking to an external Access Database Table
  • Linking to an Excel Workbook using the Wizard
  • Renaming and Copying Tables

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?

  • Sorting Data, Finding & Replacing Data
  • Working in Data Entry Mode
  • Entering and Editing Data
  • Switching Views in Access
  • Importing from Access and Excel
  • Linking to an external Access Database Table
  • Renaming and Copying Tables
  • Linking to an Excel Workbook using the Wizard

What is the target audience?

  • Very much advantageous to novice who would like to master in 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
02:21
Section 2: Switching Views in Access
Switching Views in Access
Preview
13:03
Section 3: Entering and Editing Data
Entering and Editing Data
12:30
Section 4: Working in Data Entry Mode
Working in Data Entry Mode
09:12
Section 5: Sorting Data, Finding & Replacing Data
Sorting Data, Finding & Replacing Data
Preview
16:37
Section 6: Importing from Access and Excel
Importing from Access and Excel
17:36
Section 7: Linking to an external Access Database Table
Linking to an external Access Database Table
13:35
Section 8: Linking to an Excel Workbook using the Wizard
Linking to an Excel Workbook using the Wizard
04:02
Section 9: Renaming and Copying Tables
Renaming and Copying Tables
13:18
Section 10: Additional Material
Additional Material
Preview
Article
Section 11: Exercises
Exercises
Article
Section 12: Course Conclusion
Review Appreciated!
Article
Section 13: 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