Microsoft Access 2013: Beginner to Advanced
4.1 (30 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.
153 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2013: Beginner to Advanced to your Wishlist.

Add to Wishlist

Microsoft Access 2013: Beginner to Advanced

Impress your colleagues and superiors with admirable skills in handling Microsoft Access 2013!
4.1 (30 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.
153 students enrolled
Last updated 9/2016
English
Current price: $10 Original price: $35 Discount: 71% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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.
View Curriculum
Requirements
  • Make sure to have a working copy of Access 2013 available before taking this 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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 115 Lectures Collapse All 115 Lectures 07:17:00
+
Access 2013, Beginner - Course Overview
1 Lecture 01:05
A short overview of what will be presented in this course.
Preview 01:05
+
Lesson One - Getting Started with Access 2013
12 Lectures 45:39

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

Preview 00:32

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.
Orientation to Microsoft Access
04:35

Data is stored in tables. Learn the first steps to edit this data.
Edit Table and Rows
05:04

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

The Records Bar
01:57

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

Use Forms for Data Entry
04:15

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.

Use Queries
04:13

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

Use Reports
01:11

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

Explore Access Ribbon Commands
01:13

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

Create a Simple Access Database
12:59

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

Create a Form
06:13

The Access Help feature provides you with instructive information on Access.
Get Help in Microsoft Access
02:52

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

Getting Started with Access 2013 - Summary
00:35

Getting Started with Access 2013 - Quiz
3 questions
+
Lesson Two - Working with Table Data
6 Lectures 37:14
A brief introduction of what will be covered in this lesson.
Preview 00:52

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.

Modify Table Data
13:54

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.

Sort and Filter Records
09:04

The primary key is a unique identifier for records. You need primary keys to create relationships between tables.
Purpose of Primary Key
03:34

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

Configuring Form Lookup Field
09:12

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

Working with Table Data - Summary
00:38

Working with Table Data - Quiz
3 questions
+
Lesson Three - Querying a Database
5 Lectures 39:44

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

Preview 00:58

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.

Join Data from Different Tables in a Query
12:28

Access queries can sort and filter results that are displayed.

Sort and Filter Data in a Query
14:44

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

Preview 11:10

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

Querying a Database - Summary
00:24

Querying a Database - Quiz
3 questions
+
Lesson Four - Creating Advanced Queries
8 Lectures 34:48
A brief introduction of what will be covered in this lesson.
Preview 00:50

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

Create Parameter Queries
05:02

A wildcard is a special character that is a substitute for a single character or string of text.
Use Wildcards in a Parameter Query
03:31

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

Create a Query with Multiple Parameters
04:23

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

Create Action Queries
07:53

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.

Create Unmatched and Duplicate Queries
07:20

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

Summarize Data
05:25

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

Creating Advanced Queries - Summary
00:24

Creating Advanced Queries - Quiz
4 questions
+
Lesson Five - Generating Reports
7 Lectures 32:27

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

Preview 00:58

Your database holds useful information, you want to produce reports that you can use for analysis and subsequent publishing to print or digital form.
Create a Report
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.

Use the Report Wizard
04:48

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.

Add Controls to a Report
08:07

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.
Preview 07:28

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

Prepare a Report for Print
04:53

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

Generating Reports - Summary
00:26

Generating Reports - Quiz
4 questions
+
Lesson Six - Customizing the Access Environment
3 Lectures 08:37

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

Preview 00:47

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.

The Access Options Dialog Box
07:28

An end of lesson summary of what was covered in this lesson.
Customizing the Access Enviroment - Summary
00:22

Customizing the Access Enviroment - Quiz
1 question
+
Access 2013, Intermediate - Course Follow-Up
1 Lecture 00:58
+
Access 2013, Intermediate - Course Overview
1 Lecture 01:15
A short overview of what will be presented in this course.
Preview 01:15
+
Lesson One - Designing a Relational Database
5 Lectures 15:42

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

Preview 00:40

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.

Analyzing the Relational Database Design Process
00:25

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

Create a Table
08:12

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

Create Table Relationships
05:51

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

Designing a Relational Database - Summary
00:34

Designing a Relational Database - Quiz
3 questions
13 More Sections
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.2 Average rating
244 Reviews
4,709 Students
45 Courses

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.