Access 2013 Introduction
4.6 (10 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.
40 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2013 Introduction to your Wishlist.

Add to Wishlist

Access 2013 Introduction

Learn the basics of building an Access database with well-built tables, queries, forms, and reports.
4.6 (10 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.
40 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become familiar with various database components, concepts, and terminology.
  • Become familiar with the Access user interface.
  • Understand relational databases.
  • Create and join tables.
  • Understand field data types.
  • Edit and modify tables.
  • Filter and sort table data.
  • Create simple queries.
  • Work with criteria, wildcards and keywords.
  • Perform multi-table queries.
  • Design and create reports.
  • Modify reports.
  • Create labels.
  • Create forms.
  • Design and modify forms.
  • Work with bound and unbound controls.
View Curriculum
Requirements
  • Basic computer skills.
Description

This course is an introduction to Microsoft Access 2013. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2013 Intermediate course.

Who is the target audience?
  • Students interested in learning the basics of Access.
  • Students looking to move beyond working with data in Excel.
  • Anyone looking to build a simple database to manage data.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
56 Lectures
05:44:03
+
Introduction
1 Lecture 01:04
+
Getting Started with Access
7 Lectures 34:13

Understanding Database Terminology
02:26

Working with the Access Interface
04:29

Understanding Flat File Databases
04:26

Understanding Relational Databases
08:57

Joining Tables
09:44

Using the Access Ribbon
02:42
+
Creating Databases and Objects
11 Lectures 01:11:37

Working with Field Data Types
11:02

Understanding Table Design View
05:28

Understanding Table Datasheet View
03:52

Calculating Fields
04:29

Calculating Numbers
05:24

Calculating Dates
09:00

Calculating Strings
06:19

Using the Lookup Wizard
05:23

Linking Tables
07:29

Indexing
05:28
+
Advanced Customization and Working with Data Files
7 Lectures 36:04

Navigating a Table
04:02

Editing Data in a Table
05:02

Adding a New Record
03:15

Performing Advanced Filtering
07:30

Using Subdatasheets
04:34

Using Additional Filter and Sort Techniques
02:28
+
Queries
9 Lectures 01:04:18

Creating a Simple Query
07:42

Understanding the Dynaset
02:58

Entering Criteria
07:19

Using Wild Cards
10:38

Using Keywords
06:20

Sorting and Hiding Fields
07:13

Performing Multi-Table Queries
09:34

Querying Tips and Tricks
07:26
+
Reports
8 Lectures 01:05:30
What are Reports?
06:41

Understanding Different Types of Reports
09:45

Designing Reports
04:18

Using AutoReport
09:05

Using the Report Wizard
09:14

Using the Report Design View
10:23

Creating Labels
05:57

Additional Reporting Tips and Gotchas
10:07
+
Forms
12 Lectures 01:09:47
What are Forms?
04:40

Understanding Form Types
04:47

Creating Forms
04:47

Navigating in the Form
03:42

Editing Data in a Form
04:12

Using the Form Wizard
06:45

Using the Form Design View
09:36

Working with Bound and Unbound Controls
04:31

Selecting, Moving, and Resizing Controls
06:52

Deleting Controls and Adding Fields
05:17

Using the Form Layout View
05:08

Working with Forms Tips and Tricks
09:30
+
Conclusion
1 Lecture 01:30
Course Recap
01:30
About the Instructor
Intellezy Trainers
4.4 Average rating
4,573 Reviews
26,695 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.