This tutorial should take approximately 2 hours to complete.

• This tutorial is broken down into eight practical sessions,
  • Session 1, EASA Server Configuration → 20 min
  • Session 2, Getting Started with the EASAP → 10 min
  • Session 3, Building the User Interface → 20 min
  • Session 4, Processing Object Data → 10 min
  • Session 5, Processing Events and Performing Actions → 30 min
  • Session 6, Putting Results in an Excel Spreadsheet → 10 min
  • Session 7, Generating a Report → 15 min
  • Session 8, Testing and Publishing the EASAP → 10 min

An organization maintains one or more databases that contain information that a User frequently filters and queries; the User will eventually create and save a report.

Suppose have an additional requirement for a dedicated web application that allows an authorized User access from a phone, laptop or tablet in any location.

We further specify that a User be able to export his or her results to an existing reporting tool, in this example we use a Microsoft® Excel spreadsheet.

• Our web application must therefore,
  • Automate the process of database interaction
  • Ensure error-free usage
  • Enable a User the ability to share results with his or her colleagues

Let's develop an EASA application, or EASAP, that interacts with a database and a Microsoft® Excel spreadsheet.

The Stock Screening Tool EASAP allows a User to search a database of stocks.

A snapshot of the completed EASAP interface is shown below,

The EASAP user interface will include filters and queries to let a User refine a stock search within the database.

A User may store the results of a search in an Excel report.

This tutorial provides step-by-step instructions to Author the EASAP from start to finish.

As we build the application, think about how this could be applied to databases and processes which exist within your organization.

This tutorial is designed for use with an EASA Server that is running Windows. For a linux EASA Server contact our support personnel at support@easasoftware.com to receive a Linux version of the tutorial.

• With a browser download the following archive,
  • http://help.myeasa.com/6_0/resources/Database_Tutorial_Files.zip
• Unzip the archive and save the files to a local folder

Below is a brief description of each file.

We are ready to begin Session 1.

Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8