Thursday, March 31, 2011

Uses of Microsoft Access

Microsoft Access is a database software program that makes manipulating data manageable for users of many skill levels. You can input data and sort, filter or group information according to your needs. It's particularly useful when there are thousands of records and sorting through them individually would take hours. Access allows you to obtain the information quicker by providing a few commands to tell the program what is being sought. Reports can be created, too, that pull information out of the database according to the project parameters.


  • Microsoft Access is used to create databases. It is used with other products but as front end application only. MS SQL Server, Oracle programs that can be used as back end applications and Access tables support a variety of standard field types, indices and referential integrity.
  • The underlying Jet database, which contains a query interface, forms to display and enter data, and reports for printing, is multiuser-aware and handles record-locking and referential integrity including cascading, updates and deletes.
  •  Repetitive tasks can be automated through macros with point-and-click options.
  • Data in Microsoft Access is locked at the record level which is significantly different from Excel which locks the entire spreadsheet. 
  • Microsoft Access also offers the ability for programmers to create solutions using the programming language Visual Basic for Applications (VBA), which is similar to Visual Basic 6.0 (VB6) and used throughout theMicrosoft Office programs such as ExcelWordOutlook and PowerPoint
  • Microsoft Access is designed to scale to support more data and users by linking to multiple Access databases or using a back-end database like Microsoft SQL Server. With the latter design, the amount of data and users can scale to enterprise-level solutions. 
  • Access 2010 allows databases to be published to Share Point 2010 web sites running Access Services. The resulting web forms and reports, when accessed via a web browser, don't require any add-ins or extensions and can be run in any browser. 
  • The capability of Microsoft Access that is easy enough for  end users to create their own queries, forms and reports, laying out fields and groupings, setting formats,  allows professional developers, as well as end users, to develop a wide range of applications to fulfill the needs of an organization or commercial purpose.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More