Microsoft Access 2013 for Database Managers
3.6 (6 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.
771 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2013 for Database Managers to your Wishlist.

Add to Wishlist

Microsoft Access 2013 for Database Managers

This explores modern database systems while getting familiarized with utilities used to explore and explain data sets
3.6 (6 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.
771 students enrolled
Created by GreyCampus Inc.
Last updated 9/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 15 hours on-demand video
  • 2 Articles
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • An overview of databases, database objects and terminology
  • Planning a database structure and tables
  • Describe the Relational Database Design Process
  • Understand concepts of Data Normalization
  • Determine Table Relationships and Designate Primary / Foreign Keys
  • Explore Types of queries – Select, Make Table, Append, Delete, Update
  • Developing Forms using Wizard and Layout views
  • Using Design and Layout views to create simple reports
  • Developing Simple Macros using Macro Builder and Code Builder
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

This course explores the modern database systems while getting familiarized with utilities used to explore and explain data sets. In this course, learners will also acquire the essential skills needed to use a database, including entering data into forms and tables, running queries to search data, and producing meaningful reports.

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

  • An overview of databases, database objects and terminology
  • Planning a database structure and tables
  • Describe the Relational Database Design Process
  • Understand concepts of Data Normalization
  • Determine Table Relationships and Designate Primary / Foreign Keys
  • Explore Types of queries – Select, Make Table, Append, Delete, Update
  • Developing Forms using Wizard and Layout views
  • Using Design and Layout views to create simple reports
  • Developing Simple Macros using Macro Builder and Code Builder
Who is the target audience?
  • Very much advantageous to novice who would like to master in Access Database
  • Anyone new to Microsoft Access
Students Who Viewed This Course Also Viewed
Curriculum For This Course
72 Lectures
14:50:37
+
Course Introduction
1 Lecture 04:53
+
Exploring the Microsoft Office Access Environment
6 Lectures 52:47

Explore the User Interface
02:40

Explore the Ribbon
15:25

Customize the Access Environment
14:52

MS-Access Help
05:38

Use an Existing Access Database
05:51
+
Database Overview / Terms / Planning
4 Lectures 49:54
An overview of databases, database objects and terminology
15:58

Tables, Queries
11:04

Planning a database structure and tables
17:38

Creating a new database
05:14
+
Designing a Database
7 Lectures 01:18:16
Describe the Relational Database Design Process
09:41

Define Database Purpose
11:42

Review Existing Data
21:54

Determine Fields
15:34

Normalize Data
02:15

Designate Primary and Foreign Keys
12:40

Save a Database as a Previous Version
04:30
+
Working with Tables
10 Lectures 01:40:31
Designing a Table, Rules for entering Field Names
11:25

Enter data types, field descriptions
32:42

Setting a Primary Key
09:16

Removing a Primary Key
03:05

Defining Field Properties (Default values, Input masks, Validation rules and tex
10:55

Insert, Delete, Move and Rename Fields
08:07

Table Wizards
04:21

Managing Data in a Table
12:24

Modify Table Data
03:30

Sort Records
04:46
+
Entering and Editing Data
4 Lectures 53:21
Switching Views in Access
13:52

Entering and Editing Data
12:30

Working in Data Entry Mode
09:12

Sorting Data, Finding & Replacing Data
17:47
+
Importing & Linking Data
4 Lectures 51:38
Importing from Access and Excel
19:04

Linking to an external Access Database Table
13:35

Linking to an Excel Workbook using the Wizard
04:02

Renaming and Copying Tables
14:57
+
Relationships
4 Lectures 01:24:23
Why create relationships between tables?
30:20

Different types of relationships
21:17

Referential Integrity
17:47

Cascade Update and Delete
14:59
+
Queries
8 Lectures 01:50:40
Select query
27:31

Running a Select Query
11:03

The Query Design Window
06:54

Adding fields to a query, Display/Suppress the display of a field
19:06

Removing fields from a query
03:05

Specifying sub string searches using wild Card Characters
14:03

Working with Conditions - BETWEEN, AND, OR, NOT, NULL
13:16

Calculated fields
15:42
+
Multi Table Queries
7 Lectures 01:23:43
Multiple Table Queries
14:57

Joining Tables for a query
32:22

Join Properties - Inner and Outer Joins
16:26

Make Table Query
09:38

Append Query
04:26

Delete Query
02:04

Update Query
03:50
5 More Sections
About the Instructor
GreyCampus Inc.
4.0 Average rating
1,982 Reviews
25,076 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.