Microsoft Access 2013: Beginner to Advanced

Name: Microsoft Access 2013: Beginner to Advanced
Rating: 4.5 (85 reviews)

Impress your colleagues and superiors with admirable skills in handling Microsoft Access 2013!

Created bySONIC Performance Support - E-Learning Experts

Last updated 9/2016

English

What you'll 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.

Course content

23 sections • 115 lectures • 7h 16m total length

Course Overview1:05
A short overview of what will be presented in this course.

Getting Started with Access 2013 - Lesson Introduction0:32
A brief introduction of what will be covered in this lesson.
Orientation to Microsoft Access4: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.
Edit Table and Rows5:04
Data is stored in tables. Learn the first steps to edit this data.
The Records Bar1:57
The Record navigation bar provides controls that you can use to navigate among records.
Use Forms for Data Entry4:15
Forms provide a graphical user interface (GUI) for entering and modifying table data.
Use Queries4: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.
Use Reports1:11
Reports provide a publish-ready view of data that you can output to various print or digital formats.
Explore Access Ribbon Commands1:13
The ribbon is a graphical menu panel that appears at the top of the application window.
Create a Simple Access Database12:59
It's time to roll up your sleeves and create your own database.
Create a Form6:13
Much data will have to be entered in databases. To facilitate data entry, you can create a form.
Get Help in Microsoft Access2:52
The Access Help feature provides you with instructive information on Access.
Getting Started with Access 2013 - Summary0:35
An end of lesson summary of what was covered in this lesson.
Getting Started with Access 2013 - Quiz

Working with Table Data - Lesson Introduction0:52
A brief introduction of what will be covered in this lesson.
Modify Table Data13: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.
Sort and Filter Records9: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.
Purpose of Primary Key3:34
The primary key is a unique identifier for records. You need primary keys to create relationships between tables.
Configuring Form Lookup Field9:12
Lookup fields enable you to establish a simple relationship between two tables and provide a first step toward developing more advanced table relationships.
Working with Table Data - Summary0:38
An end of lesson summary of what was covered in this lesson.
Working with Table Data - Quiz

Querying a Database - Lesson Introduction0:58
A brief introduction of what will be covered in this lesson.
Join Data from Different Tables in a Query12: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.
Sort and Filter Data in a Query14:44
Access queries can sort and filter results that are displayed.
Perform Calculations in a Query11:10
Access queries can perform calculations based on dynamic values in your database and display the results for further analysis.
Querying a Database - Summary0:24
An end of lesson summary of what was covered in this lesson.
Querying a Database - Quiz

Creating Advanced Queries - Lesson Introduction0:50
A brief introduction of what will be covered in this lesson.
Create Parameter Queries5:02
You may often find it necessary to make data retrieval interactive so that data is retrieved to meet the specific needs of users.
Use Wildcards in a Parameter Query3:31
A wildcard is a special character that is a substitute for a single character or string of text.
Create a Query with Multiple Parameters4:23
A query can identify more than one parameter and can limit the dataset to a specified range of data.
Create Action Queries7:53
If you want to make a mass update to multiple records based on a pattern, Action Queries can do that for you.
Create Unmatched and Duplicate Queries7: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.
Summarize Data5:25
A crosstab query displays data grouped by category to summarize results or reveal patterns in categories of data.
Creating Advanced Queries - Summary0:24
An end of lesson summary of what was covered in this lesson.
Creating Advanced Queries - Quiz

Generating Reports - Lesson Introduction0:58
A brief introduction of what will be covered in this lesson.
Create a Report5: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 Wizard4: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.
Add Controls to a Report8: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.
Enhance the Appearance of a Report7: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.
Prepare a Report for Print4:53
It is often necessary to adjust page setup and layout options when you first set up a report for printing.
Generating Reports - Summary0:26
An end of lesson summary of what was covered in this lesson.
Generating Reports - Quiz

Customizing the Access Environment - Lesson Introduction0:47
A brief introduction of what will be covered in this lesson.
The Access Options Dialog Box7: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.
Customizing the Access Enviroment - Summary0:22
An end of lesson summary of what was covered in this lesson.
Customizing the Access Enviroment - Quiz

Designing a Relational Database - Lesson Introduction0:40
A brief introduction of what will be covered in this lesson.
Analyzing the Relational Database Design Process0: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.
Create a Table8:12
To store data in a database, you need to create tables. Tables are the foundation of your database.
Create Table Relationships5:51
After you have tables for each subject in your database, define table relationships to connect the data in the tables.
Designing a Relational Database - Summary0:34
An end of lesson summary of what was covered in this lesson.
Designing a Relational Database - Quiz

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 this course is for:

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.

Microsoft Access 2013: Beginner to Advanced

What you'll learn

Explore related topics

Course content

Access 2013, Beginner - Course Overview1 lecture • 1min

Lesson One - Getting Started with Access 201312 lectures • 46min

Lesson Two - Working with Table Data6 lectures • 37min

Lesson Three - Querying a Database5 lectures • 40min

Lesson Four - Creating Advanced Queries8 lectures • 35min

Lesson Five - Generating Reports7 lectures • 32min

Lesson Six - Customizing the Access Environment3 lectures • 9min

Access 2013, Intermediate - Course Follow-Up1 lecture • 1min

Access 2013, Intermediate - Course Overview1 lecture • 1min

Lesson One - Designing a Relational Database5 lectures • 16min

Requirements

Description

Who this course is for: