MS Access for Absolute Beginners

Name: MS Access for Absolute Beginners
Rating: 4.3 (209 reviews)

Last updated 11/2017

English

What you'll learn

5 sections • 23 lectures • 1h 49m total length

Creating a Table5:49
• Create your first table
• Explore table design and create data labels
Creating a Table using Table Design5:15
• Create a Table using Table Design
Import External Data into Access5:52
• Learn how to import external data into MS Access
• Explore external data examples using MS Excel format and CSV/TXT format
Import External Data in CSV/TXT6:04
Export MS Access tables to an external format2:49
Learn how to export data from MS Access to an external source

Select Query10:57
Learn how to select specific data from MS Access tables using the select query
Select specific fields only, and produce and output
Calculate within the Select Query5:36
Learn how to perform calculations using the Select Query
Make Table Query4:58
Learn how to make a new MS Access Table using Make Table Query
Append Query4:48
Learn how to add data/new records to an existing table using the Append Query
Update Query6:23
Update data in an existing table using the Update Query
No new records added
CrossTab Query9:56
Summarize data from one of the tables using the CrossTab Query
Delete Query3:55
Delete records from a table using the Delete Query
Start using the Query Wizard: Select Query4:51
create a Select Query using the Query Wizard option
Query Wizard: CrossTab2:36
use the Query Wizard to create a CrossTab Query
Find duplicate records in a Database3:46
Learn how to find duplicate records in your databases
Remove duplicate records from a Database6:49
Learn how to remove duplicate records from a database
Unmatched Query Wizard3:51
Learn to compare two tables: find records in one table that do not exist in another table

Relate two tables together2:31
Learn how to relate two tables together so information from one table is available together with information in the second table
Change Table Join Relationships5:47
Relate two tables together and adjust the relationship between these two tables
Show records that are available in both tables only, or choose to show all records that are available in one table, and only those records in another table that match the records in the former

This course introduces students to MS Access

Learn how to start using MS Access from scratch
Learn how to create tables
Learn how to import and export data using MS Access
Learn how to use queries to select data, perform calculations, modify tables, delete data, update databases, as well as other functions

The course is suitable for beginners, as well as anyone who would like to learn a new skill.

***Course Instructor Revenue will be donated to charity