Talk with Database!
Excel is a program that bears very strong properties. One of these properties is the ability to use different databases. You can draw data from databases such as MS SQL Server, MS Access, Oracle, MYSQL using SQL codes, process this data and carry it to our reports in Excel pages.

Database Programming
The example below shows how data kept in MS Access is taken to Excel pages. Data comprising of hundreds and millions of lines kept in the relevant tables in MS Access, are taken to Excel pages through OLEDB (Object Linking and Embedding Database) ve ADO (ActiveX Data Objects) methods. In this process carried out with Excel VBA codes, data is processed and brought to the reports on the Excel page as meaningful information.

Let the Reports You Use Constantly be Prepared Automatically!

Excel has many instruments to prepare visual and functional reports. However, these instruments remain limited from time to time. We can create much more functional reports that go beyond their limits and render these automatic through Excel VBA programming.

Below are shown three automatic reporting examples. In the first example, the report consisting of information which was summarized by using raw data comprising of millions of lines are used and became meaningful. The report sample which shows the results formed depending on the value you will chose for each parameter immediately. The third one is the report sample prepared for the purpose of consolidating more than one report and demonstrating the collective result in one report.

Automatic Reporting Sample 1
In this sample, data of 1.5 million lines recorded at Ms. Access was used. The data that is created by choosing the desired filtering criteria are brought to the report page in Excel. The criteria that is selected here are Year, Region, Term, City, Product, Production Unit, etc. which are created according to wishes and requirements of users and they can be selected in different categories.  By choosing a combination of them, you can make multi-dimensional reports.

Automatic Reporting Sample 2
In this sample, in situations which contain many parameters, the result is shown automatically and report is prepared for each instance different values are entered.

Automatic Reporting Sample 3
This sample is about consolidating the reports with same subject which are prepared in different regions at the headquarters. Many prepared reports are prepared again in the desired format and without allowing a human error.

Data Entry Sample
Programs and forms can be created which allow connecting to database which is held in a single source in Ms. Access and consist of related tables and making data entries.