Access 2013 The Basics

Learn the basics of Access 2013
3.3 (3 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.
41 students enrolled
$50
Take This Course
  • Lectures 131
  • Contents Video: 4 hours
    Other: 1.5 hours
  • Skill Level Beginner Level
  • 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 9/2013 English

Course Description

This course covers the basic functions and features of Access 2013. Students will learn about working with table data, querying a database, creating advanced queries, generating reports and customizing the Access environment.

Total Video Time: 3h 56m

Review Quizzes included for each Section, test your knowledge!

Workbooks included for each Section, print out the course slides and take notes as you go!

Some Topics Include:

Getting Started with Access

Working with Table Data

Querying a Database

Creating Advanced Queries

Generating Reports

Customizing the Access Environment

Instructor: Sandra Batakis

Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based training as well as online Boot Camps and Seminars across the United States.

What are the requirements?

  • Basic Computer Knowledge

What am I going to get from this course?

  • Learn the Basics of Microsoft Access 2013
  • Learn About the Changes Between 2010 and 2013
  • Learn About Access Databases
  • Review Quizzes for Each Section
  • Downloadable Workbooks

What is the target audience?

  • Anyone Seeking Training with Access 2013
  • Anyone Seeking to Advance Their Knowledge of Access 2013

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: Getting Started with Access 2013
Instructor Introduction
Preview
00:45
Course Introduction
Preview
01:17
Section 01 Introduction
Preview
00:21
Topic A: Orientation to Microsoft Access
Preview
00:40
Why Use a Database Application?
Preview
02:03
Transform Data into Knowledge
Preview
01:04
Using Access Instead of Excel
01:50
Using Access Instead of Other Databases
01:00
Demo 1-2: Launching Access and Opening a Database
Preview
05:38
Access 2013 Window Components
01:30
Demo 1-3: Navigating and Editing Data in Tables
08:21
Forms and Views
01:07
Record Navigation Bar
Preview
01:12
Demo 1-4: Navigating and Editing Data in a Form
Preview
04:06
The Capable Query
01:19
A Query Join
01:47
Demo 1-5: Using Queries
06:03
Demo 1-6: Using Reports
02:43
Demo 1-7: Exploring Access Ribbon Commands
05:18
Topic B: Create a Simple Access Database
00:25
Create a Simple Access Database (Part 1)
00:27
Create a Simple Access Database (Part 2)
01:22
Saving Options
00:37
Initial Views
01:12
Field Data Types (Part 1)
02:24
Field Data Types (Part 2)
01:36
Primary Key
Preview
01:08
Object Names
Preview
02:33
Demo 1-8: Creating a New Database
Preview
10:11
Demo 1-9: Creating and Testing a Form
Preview
05:55
Topic C: Get Help in Microsoft Access
00:06
Access Help Window
01:09
Demo 1-10: Getting Help in Access
03:13
Review
00:20
Getting Started with Access
5 questions
Workbook
25 pages
Section 2: Working with Table Data
Section 02 Introduction
00:14
Topic A: Modify Table Data
00:11
Modify Table Data
01:00
Demo 2-1: Undoing Record Modifications
03:34
Quick Search
00:23
Demo 2-2: Using Quick Search to Find and Modify Records
01:53
Demo 2-3: Using Find and Replace to Modify Records
03:20
Adding Calculations to the Totals Row
00:49
Demo 2-4: Adding a Totals Row to a Datasheet
02:14
Topic B: Sort and Filter Records
00:20
Records in Ascending Order by Dept
00:35
Filtering Records
01:07
Demo 2-5: Sorting and Filtering Records
04:14
Topic C: Create Lookups
00:11
Table Relationship
01:31
The Relationships View
00:43
Foreign Keys
00:48
Referential Integrity
00:33
Demo 2-6: Examining the Purpose of a Primary Key
02:34
The Property Sheet
01:02
Demo 2-7: Configuring a Form Lookup Field
07:44
Review
00:14
Working with Table Data
5 questions
Workbook
17 pages
Section 3: Querying a Database
Section 03 Introduction
00:16
Topic A: Join Data from Different Tables in a Query
00:18
Query Object Views
00:45
Simple Query Wizard
00:40
Types of Queries
00:54
Demo 3-1: Creating a Query by Using the Query Wizard
04:30
Using Query Design to Create a Query
02:11
Types of Queries
00:33
Demo 3-2: Creating a Query by Using Query Design
04:20
Topic B: Sort and Filter Data in a Query
00:16
Query Criteria
01:31
A Comparison Operator
00:42
Logical Operators
00:34
Wildcards
02:32
Like Operator Examples
01:31
Demo 3-3: Filtering a Query Using a Comparison Operator
03:08
Demo 3-4: Filtering a Query Using a Wildcard
03:17
Zoom Dialog Box
01:06
Demo 3-5: Filtering a Query Using a Date Range
04:23
Topic C: Perform Calculations in a Query
00:06
Calculations in a Query
00:55
Demo 3-6: Performing Calculations
09:55
Review
00:19
Querying a Database
5 questions
Workbook
19 pages
Section 4: Creating Advanced Queries
Section 04 Introduction
00:16
Topic A: Create Parameter Queries
00:10
Create Parameter Queries
00:57
Matching a Parameter Query
01:17
Using the Ampersand Operator
01:05
A Parameter Query Displays a Prompt
00:20
Demo 4-1: Creating a Parameter Query
03:40
Demo 4-2: Using Wildcards in a Parameter Query
02:08
Demo 4-3: Creating a Query with Multiple Parameters
01:43
Topic B: Create Action Queries
00:12
Action Queries
01:13

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Career Academy, Producing Quality Technical Training Videos Since 1999

Career Academy was established in 1999 to help people deal with changes and acquire the knowledge and skills they need to compete in the 21st Century. We are the global leader in self paced computer technology training solutions for the IT Professional, providing the most complete and up to date self-paced certification and job related training library available.

Career Academy blends technical know-how and a quality knowledge base and implements that blend throughout the four corners of the globe. It empowers you with complete control over the learning process. Learn via OnDemand Training whenever you want. We have recreated the classroom experience for students who are not able to fit a class schedule into their busy lifestyle. Career Academy provides you the finest instructor led lectures with the latest Technological trends in content development and delivery to help create your own unique learning. 

Ready to start learning?
Take This Course