Access_Tutorials

You can access the Microsoft Access 2013 Tutorial Videos at

@ https://support.office.com/en-us/article/Access-2013-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce

- Beginner

--- Design and build tables for a database (AB-1; Access Basic part 1) - 20 min

--- Create table relationships (AB-2; Access Basic part 2) - 15 min

--- Create your first Access database - 5 min

--- Introduction to queries (AB-3) - 20 min

--- Webinar: Intro to Access 2013 - 15 min (optional)

..

Unless the video links above work, please access the tutorial videos via the individual links below.

..

Design and build tables for a database (Access basics, part 1)

Key concepts and terms (4:35)

The basics of table design and what makes a database relational.

Start a new database from a blank template (4:09)

How to create a new database file, and the types of databases you can create.

Build the first table and set data types (4:20)

How to create a table and set the correct data types for each field.

Build tables with the Table Designer (4:17)

Create a table in Table Design view.

Use the Calculated data type to combine fields (1:51)

Use the Calculated data type to combine first and last names.

.

Create table relationships (Access basics, part 2)

Creating relationships between your tables (5:07)

An introduction to relationships and the 3 types of relationships.

Create a relationship with the Lookup Wizard (3:19)

How to create a one-to-many relationship with the Lookup Wizard.

Create relationships with the Relationships Pane (1:31)

Creating a one-to-many relationship with the Relationships pane.

Create a many-to-many relationship (3:25)

When and how you create a many-to-many relationship.

Create a one-to-one relationship (3:06)

How to build a one-to-one relationship.

.

Create your first Access 2013 database

Create a desktop database (2:04)

Use a desktop template to create a database that runs on your computer.

Create an Access app (2:29)

Access Apps are databases that run in the cloud. Templates make them faster and easier.

.

Introduction to queries (Access basics, part 3)

Introduction to queries (5:24)

The types of queries you can build; using the Query Wizard.

Building queries with the Query Designer (4:45)

Using the Query Designer to build select queries.

Build queries that use more than one data source (4:45)

How to query multiple data sources; the basics of joins.

Using outer joins (2:50)

More about using left and right outer joins.

Query unrelated data sources (4:45)

How to use intermediate tables and add joins.

.

Webinar: A gentle, human intro to Access 2013 (15 min, optional)

.

.