Office Productivity
Microsoft
Microsoft Access
Introduction to Microsoft Access Tables
4.4 (223 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,174 students enrolled

Introduction to Microsoft Access Tables

This course teaches the basics of working with databases by teaching how to use Microsoft Access tables.
4.4 (223 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,174 students enrolled
Created by Simon Sez IT
Last updated 6/2018
English
English [Auto]
Preview this course
Introduction to Microsoft Access Tables
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Creating database tables in Access 2010
  • Creating database tables in Access 2013
  • Relationship between tables
  • Relationship between tables and basic setup of relationships
  • Entering data types into tables
  • Changing table attributes
  • Copy, rename, and delete records
Requirements
  • Microsoft Access 2010
  • Microsoft Access 2013
Description

During this introductory course on using Microsoft Access tables, we'll teach you the basics for working with them – in both Microsoft Access 2010 and Access 2013.

We’ll start with some basic concepts to help you understand how a table organizes information into rows and columns. Then we’ll provide an easy to follow example using some fairly straightforward data. We’ll then move into some of the more advanced aspects of database tables including creating relationships between tables, one of the fundamentals concepts of database design and management.

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Who this course is for:
  • Anyone new to Microsoft Access or databases
Course content
Expand all 14 lectures 02:32:58
+ – Access 2010 Tables
7 lectures 01:36:19
Creating Tables and Basic Setup of Relationships
Preview 15:40
Essential Information for a Successful Training Experience
01:01
Using Quick Parts to Setup New Tables, Importing Spreadsheet
Preview 16:23
Entering Data Types into Tables
15:23
Changing Table Attributes, Copy, Rename, Delete Records
16:28
Table Structures
15:22
Table and Field Properties
16:02
+ – Access 2013 Tables
7 lectures 56:38
Creating Tables - Part 1
Preview 15:43
Essential Information for a Successful Training Experience
01:31
Exercise files for Access 2013 lessons
00:24
Course Review
00:43
Creating Tables - Part 2
14:53
Relationships Between Tables - Part 1
14:40
Relationships Between Tables - Part 2
08:43