This tutorial should take approximately 2 hours to complete.
This tutorial is broken down into the following practical sessions:
Your organization uses one or more databases, which contain information that users frequently need to query and filter, and in some cases to create and save reports. There is therefore a need to create a dedicated web application which authorized users may access from any location or device.
However, simply creating a web application to filter the database is not sufficient – users need to be able to export the results to an existing reporting tool, in this case a Microsoft® Excel spreadsheet. The web application must therefore automate the process, ensure error-free usage, and enable users to share results with their colleagues.
You will develop an EASA application, or EASAP, that interacts with both a Microsoft® Access database and a Microsoft® Excel spreadsheet. The EASAP will be a Stock Screening tool, which allows the user to search a database of stocks. A snapshot of the EASAP that you will build is shown below:
The EASAP user interface will include filters and queries to let users refine their stock searches within the Access database. Users will then have the option to store the results of their searches in an Excel report. This tutorial provides step- by-step instructions to guide you from start to finish.
As you build your application, think about how this could be applied to databases and processes which exist within your organization.
Note: This tutorial is designed for use with an EASA Server computer that is running under Windows. If your EASA Server is running under Linux, then please contact our support personnel at email@example.com to make arrangements for receiving a Linux server compatible version of the tutorial.
The files that you need to complete the tutorial are listed below. Copy them to a location on your computer for use later in the tutorial.
| ||MS Access database containing the stock data to be accessed|
| ||MS Excel spreadsheet in which to store search results generated|
| ||Selection image or “thumbnail” for EASAP|
| ||Template HTML file for report generated by EASAP|
| ||Banner image located within report_body.html|
| ||Text file containing an SQL query to read data from the database|