Welcome to MS Access Tutorials!
Introduction to Access 2016
If you're running a business, there is a 100% certainty that you have to manage data. The data may be written on a piece of paper tucked into your back pocket but it has to exist. Every day you are collecting information about customers, products, sales, employees, suppliers, etc.
Software packages to manage large amounts of information (Database Management Systems - DBMS) for large corporations have been around since the 1960s.
But in 1992 Microsoft introduced Access, a DBMS that operates on a PC for small users. Ever since, that essential tool has been getting more and more flexible and useful.
In previous Access versions, until Access 2013, the focus was on “desktop databases” that were housed and run from a local computer. There were tools to work with the Web but they were accessed from within the local database.
With Access 2013, and now getting better with Access 2016, Microsoft has created two separate components for Access: the first is the “Desktop database”, the local version that we are all familiar with and that works the same has it always has; the second is called “Web apps” and that consists of a database stored in the Cloud.
The advantages of Web apps should be immediately obvious. With the growing popularity of mobile devices comes the need for mobile access to information storage and retrieval. Thus, the Cloud – your data available anytime, anywhere.
This course will start with a quick review of database design principles on a desktop DB with a few examples that should refresh the memory of those students who have been away from the subject for a while. This is important because a strong design is key to a powerful, flexible DB later on, whether the DB is local or Web-based.
Then we'll cover language concepts with SQL, the database language. We didn't have to do much of this before with Access because the SQL code was automatically generated by the interface. Now, with Web apps we'll have to interact more directly with the DB, thus the need to code in SQL.
Once the refreshers are done the main focus will be on building Web apps.