About This Course
Microsoft Access is the database management system that is included with the Microsoft Office Suite or Office 365. It is a program that helps you manage a large amount of data even better than Microsoft Excel can. Many people don’t know how to use Access, and may even be afraid of it. This course will really show you the ins and outs of using Microsoft Access Tables and Queries.
Even though Excel gives you some great ways to handle your data, with Access, you will be able to handle large amounts of data . If you handle large amounts of data, this course will help you tremendously.
What you’ll learn:
- Using Design view to create a table
- The Lookup Wizard
- Importing tables from other data sources
- Linking tables to other data sources
- Exporting data from Access into other data types
- Using Design view to create a table
- The Lookup Wizard
- Importing tables from other data sources
- Linking tables to other data sources
- Exporting data from Access into other data types
- Append, Make Table, Update, and Delete queries
- Showing a certain number of records in a query
Our Promise to You
By the end of this course, you will have learned to create tables and queries using Access.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Microsoft Access.
Course Curriculum
Section 1 - Access Database | |||
Course Resources | 00:00:00 | ||
Tour Of The Screen | 00:00:00 | ||
Using Design View To Create And Edible Tables | 00:00:00 | ||
Using The Lookup Wizard | 00:00:00 | ||
Importing Data From Other Data Sources Into Access | 00:00:00 | ||
Linking Tables From Other Data Sources Into Access | 00:00:00 | ||
Exporting Data From Access To Other Data Types | 00:00:00 | ||
Creating And Managing Table Relationships | 00:00:00 | ||
Database Tools | 00:00:00 | ||
Sort And Filter A Table | 00:00:00 | ||
Basic Queries | 00:00:00 | ||
Prompt The User For The Criteria | 00:00:00 | ||
Creating Calculated Fields In A Query | 00:00:00 | ||
Creating Totals Queries | 00:00:00 | ||
Multiple Table Queries | 00:00:00 | ||
Viewing The SQL Code For An Access Query | 00:00:00 | ||
Using The Query Wizards | 00:00:00 | ||
Creating Subqueries | 00:00:00 | ||
Creating Make Table, Append, Update And Delete Queries | 00:00:00 | ||
Displaying A Certaing Number Of Records | 00:00:00 |