GET STARTED
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
Related Courses
Excellent introduction to MS Access
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.