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

3h 31m

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

Course Reviews

5

5
1 ratings
  1. Excellent introduction to MS Access

    5

    I heartly recommend this course as an excellent introduction to MS Access. It is equally appropriate for someone entirely new to databases and Access, or for someone like myself who has worked with Access before but can benefit greatly from a systematic exposition of the program’s capabilities and features. Assuming no previous knowledge on the student’s part, the course begins with the design of simple tables, moves through creating relationships between tables and concludes with constructing queries. The instructor has a very straightforward and clear expository style and is thoroughly prepared in the presentation of the material, with his next example or point of clarification always readily at hand. The course files are available for the student to download and practice with, which is an added plus. I’ll be looking for additional and more advanced courses from this instructor.

top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel

3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!