In this tutorial you will learn how to use MS Access to create a powerful, flexible, business database.
The first question is:
What is Microsoft Access?
MSAccess is a Database Management System that handles data management tasks with the same way MS Word handles document management and MS Excel handles statistics ...
A database is a collection of objects that allow you to store data, organize it and retrieve them in any of your choice
What this means is that, with MSAccess you can create structures called tables that allows you to organize the data so that it can be find later, you can also create forms that let you input the data into the tables and then you create reports that print selected information from that tables.
For example, if you run a store, you would create a Customers table, a Products table and an Invoices table. Then, when you open an account for a new customer you would have a Customer form to input a customer's data into the Customers table and an Order form to input the purchase information.
Later, you could print any number of Sales reports, grouping and arranging all the information from the Invoices, Customers and Products tables to analyze daily or weekly or monthly sales in all kinds of combinations.
To help you along, Access contains a whole series of Wizards to guide you through the process.
Next step:
Course description
This MSAccess tutorial follows a step-by-step approach to the creation and development of a commercial database application.
I'll start with database modeling. That means that you have to design the database before you actually start to write it. There are several basic techniques that must be learned to ensure that the database structure will be solid. Design is an absolutely essential part of creating a database.
If you're already past the rookie stage and you want to delve deeper into the database modeling aspect, In a normal sequence of courses, SQL would be the next database subject you would learn after Access. Whereas MS Access is meant for the smaller user, SQL with MySQL or Microsoft SQL Server, lets you into the domain of the power-user.
Once am done with the design we'll develop an objects one by one and learn how to use them.
As we go along we'll use a simple application to illustrate the power of a Microsoft Access database in business. The application is a Video Rental Store and it's well suited to showing how a small businees could put into practice all these notions of management with databases.
What's next?
After this Microsoft Access tutorial, you may want to go on to bigger and better databases such as Oracle, SQL Server or MySQL. The training you get from this tutorial will qualify you for the more advanced stuff.
You may also want to look at connecting your Microsoft Access database to a Visual Basic application.
By the end of this Microsoft Access database course, you will have made a good start towards becoming a full-fledged business
Posted on Utopian.io - Rewarding Open Source Contributors