SQLConfiguration SQLConfiguration


Access Features   «Prev  Next»
Lesson 2 Prerequisites
Objective Verify that you have the Background and Software required for this Course.

Verify that you have the Background and Software

Background

This course assumes that you understand the basics such as using the Access wizards, as well as how to create simple tables, queries, forms, and reports. You should also know how to switch among the various objects by using the main database window.
It would be helpful to have completed Microsoft Access 2013 Series: Building a Database, Working with Data, and Advanced Tables, Queries, Forms, and Reports courses or to have equivalent knowledge and experience.


Platform support

This course is designed for the Windows, Linux, and Mac computer platforms.
Microsoft Access can help you manage your data in ways that no other application can. Even the king of applications, Microsoft Excel, can�t do what Access can. Now, it may seem silly to compare Access (a database management application) with Excel (a spreadsheet application), but there is no doubt that Excel is being used every day to manage and analyze large amounts of data in all kinds of organizations. You may be studying this course because you need to get past the limitations of Excel. Access is an excellent and logical next step for the analyst who faces an ever-increasing data pool. Access takes very few performance hits with larger datasets. It has no predetermined row limitations. And it can effectively manage the relationships between disparate data tables. In addition, Access comes with tools that help you build your own distributable applications. Today, when we have more data than ever and more demands for complex data analysis, power analysts need to add some tools to their repertoire in order to get away from being simply spreadsheet mechanics. That is why this course is such an important step in the evolution of your skillset. Throughout this course, not only will you get an introduction to Access, but you will also learn various ways in which you can use Access to improve your daily data management and analysis.
In the next lesson, we will take a look at what you need to get the most from this course.