Microsoft Access is a part of Microsoft Office Suite and is available in the professional and higher editions of Office. The latest version of Microsoft Access is Access 2010 and this was released as an application in the new Office 2010 Suit in May 2010. Access has been the first choice for keeping databases and information for quite some time now and it serves as the backend of many database applications. Access has its own set of commands and queries which can be implemented in any application to edit, add, or delete information from the database. Another reason for Access gains such acceptance is its flexibility and it can create files and data which can be used and accessed from other applications like MS Excel. Microsoft Access stores data in its own format based on the Access Jet Database engine. It can even import data or can be linked directly to data stored in other applications and databases. Another feature of Microsoft Access being a success is the reporting feature it has. It can create simple as well as complex reports in no time. It has its own inbuilt reporting manager and the same can be accessed by the custom built applications for reporting purposes. Microsoft Access is used within many businesses to store and access information. The new term that is associated is Microsoft Office Access which earlier was known as Microsoft Access. It is a pseudo relational database management system from Microsoft that combines the relational Microsoft Jet Date base Engine with the new Graphical User interface and the software development tools. In this post I will discuss simple steps for creating reports in MS Access by selecting INDV Records.
Steps to create reports by selecting individual records in MS Excel are as follows:
First and foremost you need to bring up your database. A data base consists of an organized collection of data for one or more than one users, especially in digital form. Database involves the type of their contents such as bibliographic, document-text, statistical.
Now if you are planning to bring a particular record, you need to perform your query by searching the primary key for a certain value. For Example if you have 12 records with IDs 1-12 and you are looking for the record withID6 then set the query ID=”6”
The single record that you were searching of will automatically come up and then you can simply generate your report accordingly.
These above mentioned steps are too simple that can be followed without any difficulty and in no time a Microsoft Access report is also made using an individual report.