Access_Tutorials
You can access the Microsoft Access 2013 Tutorial Videos at
- 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)
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.
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.
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)
.
.