What is Microsoft Access?
Microsoft Access is a database application developed by Microsoft. It allows the user to store and use data to meet their needs. Microsoft Access is the most popular database application for the PC environment because it is relatively easy to use and is highly customizable using its settings, called properties, built in macro capabilities and/or Visual Basic for Applications. Access databases can store up to 2 gigabytes of data and if that is not enough, Access data can be converted to Microsoft SQL Server. Access forms part of Microsoft Office, though it is not automatically included in all combinations of Office products.
Access allows users to create structured “tables” to store data and applies rules to regulate what data is entered and where it is entered. Access tables have no limit to the number of rows or “records”. Access also allows users to create data entry screens, called “forms”; saved views of data, called “queries”, that select information based upon criteria, perform calculations, and/or sort the data in a particular way; and customized printouts, called “reports”.
Over the years many people have over relied on Microsoft Excel, because that is a product they use all the time and feel comfortable with. But Excel is unstructured in that anything can be typed in any cell of the workbook. Also, the amount of data you can store in a sheet is limited by the number of rows that the sheet contains. In most cases, Access can store more data than Excel, so if your want to maintain historical data for your company, Access can be a good tool.
Who uses Microsoft Access?
Microsoft Access is used by people in all types of businesses to store and use data in a structured environment. It is commonly used in any type of business that needs to maintain lists.
Often large companies have corporate data bases maintained by IT. If a department needs particular data or a particular report, fulfilling that request may take IT more time than is acceptable in today’s fast paced environment. Access can link to or import data from many sources, allowing the user,with permission from IT, to get the data into an Access database and work with the data however the department needs to while still maintaining the integrity of the data in the corporate database.
What Microsoft Access training does Systemetrics offer?
Systemetrics offers the following Microsoft Access seminars:
Introduction to Microsoft Access 2007 – 2016 (6 hours) View Outline
Intermediate Microsoft Access 2010 – 2016 (6 hours) View Outline
Advanced Microsoft Access 2010 – 2016 (6 hours) View Outline
These Microsoft Access classes are scheduled on a regular basis in our classroom. Private sessions may be scheduled in our classroom or yours.
To view the current schedule of Microsoft Access classes, click here.
Is additional Microsoft Access training available?
While we do not offer any other Microsoft Access seminars, individual and small group assistance is available through our mentoring services, where our Access instructor can assist you with training and development specific to your needs.
What support is available after you complete a Microsoft Access seminar?
As with all of our seminars, students who complete either of of Microsoft Access seminars can call or e-mail us with any questions they have relating to Microsoft Access. Forever!
Need help determining if Systemetrics can help you?
Contact Leo Mansi, Systemetrics Training Manager, by calling (401) 275-2200, ext. 102, or by e-mail.
Microsoft Access is a registered trademark of Microsoft Corporation.