Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Business Analysts
  • Data Analysts
  • Those who want to increase their productivity by using office software to improve their work

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

Requirements: 

  • No prior knowledge is required to take 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.

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
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel