Buy Dideo Subscription
Downloads available at: http://www.accessallinone.com/access-2010-no-vba-downloads/ Please select DbVideo01 What is MS Access? MS Access is a tool used for effective data management. It's actually utilized by millions across the globe and it is an effective substitute for Excel in the event the levels of data gets too large to control effectively. It's got several components including: • Tables • Queries • Forms • Reports • Macros • Modules What is MS Access used for? MS Access is primarily utilized to store massive amounts of info making it readily accessible by means of sorting, filtering and totalling using queries. The data can then be shown to the user by the use of forms (for modification) and reports (for viewing and printing). How sophisticated is MS Access? Access has often been touted as the database system for departmental solutions.The nature of Access usually means that it is fast and simple to store, organise and retrieve data and consequently suited to a departmental environment. However, as a consequence of the changes made in Access 2007 and 2010, Access is now starting to punch its weight as a serious database solution with increased storage and seamless ODBC connectivity. Versions of Access The first version of Access was introduced in 1992. It was called Access 1.0. since then multiple versions of Access have been released. Listed below are the most notable ones: • Access 97 • Access 2000 • Access 2003 • Access 2007 • Access 2010 The original Access file was in the .mdb format. It was changed to the Accdb format in Access 2007 making sure that more complex data could be handled. Access 2007 was also the 1st time that the ribbon was introduced into Access and tables could be stored in Sharepoint. In 2010 Access acquired the ability to operate as a web application by way of being stored as a project in Sharepoint. This concept is named Access Services and means that one database may well support a client based file and a web based file. Connectivity Using ODBC Access can seamlessly connect with a multitude of documents from Excel files all the way through to basic text files. Access can even connect to other Access tables and databases thus ensuring the size of an Access database can be increased by using an archiving system. To summarise Access is an excellent departmental solution with ever increasing data handling capabilities. It is simple to learn and at the forefront of these modern web-application times we live in.
