Microsoft Access 2013: Beginner to Advanced

Impress your colleagues and superiors with admirable skills in handling Microsoft Access 2013!
4.2 (25 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.
125 students enrolled
$19
$35
46% off
Take This Course
  • Lectures 115
  • Length 7.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 4/2015 English

Course Description

Microsoft Office Access 2013 is a relational database management tool that helps you store information for reference, reporting, and analysis.

Our Access 2013 training videos shows how to store and track just about any kind of information - inventory, contacts, business processes - and you'll learn how to organize and manage your data.

In this course you will learn how to:

  • Create an Access database, including tables, forms, queries, and reports.
  • Create and work with various Access objects and relationships.
  • Discover how to maintain consistent data, customize database components, and share data with other applications.
  • Create form controls, macros, subforms and tab pages.
  • Manage a database including backup, compact and repair, documentation, database splitting, encrypting a database and adding a digital signature to a database.
  • Create a switchboard for your database application.

Our instructor will explain all of the features and functionalities the application offers in an easy to understand, step-by-step method. The videos have been designed for both first-time users with fundamental Access 2013 problems and advanced users with specific Access 2013 problems. Quizzes are available at the end of each lesson to validate your knowledge.

What are the requirements?

  • Make sure to have a working copy of Access 2013 available before taking this course.

What am I going to get from this course?

  • Jump right in to Access 2013 and create clean, sharp looking Databases.
  • Create an Access database, including tables, forms, queries, and reports.
  • Create and work with various Access objects and relationships.
  • Discover how to maintain consistent data, customize database components, and share data with other applications.
  • Create form controls, macros, subforms and tab pages.
  • Manage a database including backup, compact and repair, documentation, database splitting, encrypting a database and adding a digital signature to a database.
  • Create a switchboard for your database application.

What is the target audience?

  • This course is meant for both basic and advanced students of Access 2013.
  • If you're confident in your execution of Access 2013 task, this course may not be for you.

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: Access 2013, Beginner - Course Overview
01:05
A short overview of what will be presented in this course.
Section 2: Lesson One - Getting Started with Access 2013
00:32

A brief introduction of what will be covered in this lesson.

04:35
Microsoft Office Access 2013 provides tools to structure and organize your data. The first step in mastering Access is to get comfortable working with the Access user interface.
05:04
Data is stored in tables. Learn the first steps to edit this data.
01:57

The Record navigation bar provides controls that you can use to navigate among records.

04:15

Forms provide a graphical user interface (GUI) for entering and modifying table data.

04:13

Queries transform raw table data from multiple tables to produce a new, combined data set, sorting results by one or more fields, filtering results based on given criteria and more.

01:11

Reports provide a publish-ready view of data that you can output to various print or digital formats.

01:13

The ribbon is a graphical menu panel that appears at the top of the application window.

12:59

It's time to roll up your sleeves and create your own database.

06:13

Much data will have to be entered in databases. To facilitate data entry, you can create a form.

02:52
The Access Help feature provides you with instructive information on Access.
00:35

An end of lesson summary of what was covered in this lesson.

Getting Started with Access 2013 - Quiz
3 questions
Section 3: Lesson Two - Working with Table Data
00:52
A brief introduction of what will be covered in this lesson.
13:54

You created the basic table structure within a database. To keep data in these tables current, you need to know how to add, delete, and update data in a table.

09:04

As you work with a database, it can be helpful to temporarily sort or filter a table to show only records that match certain criteria.

03:34
The primary key is a unique identifier for records. You need primary keys to create relationships between tables.
09:12

Lookup fields enable you to establish a simple relationship between two tables and provide a first step toward developing more advanced table relationships.

00:38

An end of lesson summary of what was covered in this lesson.

Working with Table Data - Quiz
3 questions
Section 4: Lesson Three - Querying a Database
00:58

A brief introduction of what will be covered in this lesson.

12:28

Often you need to display data from multiple tables in a single view. Joining data from multiple tables is one of the significant tasks that you can accomplish using a query.

14:44

Access queries can sort and filter results that are displayed.

11:10

Access queries can perform calculations based on dynamic values in your database and display the results for further analysis.

00:24

An end of lesson summary of what was covered in this lesson.

Querying a Database - Quiz
3 questions
Section 5: Lesson Four - Creating Advanced Queries
00:50
A brief introduction of what will be covered in this lesson.
05:02

You may often find it necessary to make data retrieval interactive so that data is retrieved to meet the specific needs of users.

03:31
A wildcard is a special character that is a substitute for a single character or string of text.
04:23

A query can identify more than one parameter and can limit the dataset to a specified range of data.

07:53

If you want to make a mass update to multiple records based on a pattern, Action Queries can do that for you.

07:20

Part of the process of managing a database is simply keeping the database clean and efficient. There are two types of action queries help you automate the process of finding and correcting unmatched and duplicate records.

05:25

A crosstab query displays data grouped by category to summarize results or reveal patterns in categories of data.

00:24

An end of lesson summary of what was covered in this lesson.

Creating Advanced Queries - Quiz
4 questions
Section 6: Lesson Five - Generating Reports
00:58

A brief introduction of what will be covered in this lesson.

05:47
Your database holds useful information, you want to produce reports that you can use for analysis and subsequent publishing to print or digital form.
04:48

Your database holds useful information, you want to produce reports that you can use for analysis and subsequent publishing to print or digital form.

08:07

The various tools to generate a report are often able to create most or all of the controls and layout for you. However, there are times when you will need to add controls manually.

07:28
Access provides numerous options to enhance the appearance of a report. For example, you can apply color themes and font styles, and add graphics to any band in a report design.
04:53

It is often necessary to adjust page setup and layout options when you first set up a report for printing.

00:26

An end of lesson summary of what was covered in this lesson.

Generating Reports - Quiz
4 questions
Section 7: Lesson Six - Customizing the Access Environment
00:47

A brief introduction of what will be covered in this lesson.

07:28

The Access Options dialog box provides a variety of configuration settings that enable you to customize database behavior and the Access user interface to meet your needs.

00:22
An end of lesson summary of what was covered in this lesson.
Customizing the Access Enviroment - Quiz
1 question
Section 8: Access 2013, Intermediate - Course Follow-Up
Course Follow-Up
Preview
00:58
Section 9: Access 2013, Intermediate - Course Overview
01:15
A short overview of what will be presented in this course.
Section 10: Lesson One - Designing a Relational Database
00:40

A brief introduction of what will be covered in this lesson.

00:25

A relational database organizes data into related tables stored in the same file. It is important to take time to understand the principles of good design so that you end up with an effective, accurate, and efficient database.

08:12

To store data in a database, you need to create tables. Tables are the foundation of your database.

05:51

After you have tables for each subject in your database, define table relationships to connect the data in the tables.

00:34

An end of lesson summary of what was covered in this lesson.

Designing a Relational Database - Quiz
3 questions
Section 11: Lesson Two - Joining Tables
00:50

A brief introduction of what will be covered in this lesson.

08:05

You can join queries in the same way that you join tables. A query join is similar to a relationship, but it is temporary.

04:04

To join tables that have no common fields, you do this by including a table that contains fields that are common to both tables. This will enable you to retrieve data from tables that are indirectly related to each other.

03:47

Sometimes you need to join a table with itself - a Self-Join - to create meaningful queries.

06:19

Sometimes you may need to view data in related tables simultaneously. A subdatasheet is a datasheet within another datasheet.

05:50

Creating advanced queries expands your ability to get exactly the data you need.

00:36

An end of lesson summary of what was covered in this lesson.

Joining Tables - Quiz
5 questions
Section 12: Lesson Three - Organizing a Database for Efficiency
00:45

A brief introduction of what will be covered in this lesson.

07:59

The Table Analyzer Wizard is an analysis tool that scans a table's structure for duplicate data, helps to fix this and helps the database perform more efficiently.

04:47

A junction table is used to create a many-to-many relationship between two tables.

06:11

You may want to expand your database or revamp it to fix or improve it. In this topic, you will improve table structure to meet a target design.

00:25

An end of lesson summary of what was covered in this lesson.

Organizing a Database for Efficiency - Quiz
3 questions
Section 13: Lesson Four - Sharing Data Across Applications
01:27

A brief introduction of what will be covered in this lesson.

06:27

When you create a database, you can type the records into Access tables directly, or you can get the data from another source or application.

04:34

When you create a database, you can type the records into Access tables directly, or you can get the data from another source or application.

06:34

In this topic, you will export Access data to text files. If you need to export your data to a program that Access does not support directly, converting it to text should enable the other program to open it.

03:58
In this topic, you will export Access data to Excel so you can share data with someone unfamiliar with Access. It's probably better to send someone a spreadsheet containing exactly the data they need, rather than to send them the entire database.
07:12
By combining Word with an Access table or query, you can create personalized documents quickly and easily.
00:52

An end of lesson summary of what was covered in this lesson.

Sharing Data Across Applications - Quiz
4 questions
Section 14: Lesson Five - Advanced Reporting
00:47
A brief introduction of what will be covered in this lesson.
17:08
It´s time to expand upon simple report designs to create attractive, informative printouts.
07:35

In this topic, you will format reports as well as control pagination. This results in a professional-looking report that captures the reader's attention.

03:49

In this topic, you will add data bars to a report. Using control formatting and depicting data graphically can be easier to understand. This will help you tell the story of your data with a quick glance.

05:51

In this topic, you will insert a calculated field so you can provide valuable information to the users of the report.

05:59

A subreport is a report embedded within a main report and allows you to view information from different tables, queries, and reports on the same report.

00:27
An end of lesson summary of what was covered in this lesson.
Advanced Reporting - Quiz
5 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.

Ready to start learning?
Take This Course