?
Solved

Tools to Output documents from DB based on selections

Posted on 2016-09-23
8
Medium Priority
?
179 Views
Last Modified: 2016-09-26
Any advice or tool suggestion is helpful and will get points!

I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. For example, installing a firewall, configuring content filtering, installing a switch.

My existing process is a word doc template and a one note full of steps that I paste in as needed. The problem with this is that it's too manual, has no time formulas, and I also need to corollate work instructions with each step. For example installing the switch is on the SOW but the work instructions are more detailed: update current firmware, configure client snmp string, etc...

To solve these problems, I shoved it all into excel and also got some nice math time estimating features. It's still alpha but looks like it could work, abit clunky, hard to manage and version, hard to share with a team, etc...

I've got a sql background and I know I could use something like access to make the forms and output report docs but I know that adp is dead and I'd prefer something web based.

I do not want to pay for a giant document management or proposal generation application which probably doesn't event have the key feature of tying the sow lines to the work instruction steps. I also don't really want to do the DB work and then have a custom program written just for the forms and document generation.

Ideally this would be a webapp (saas or hosted) where I can check some boxes, select the steps I want, enter some numbers and have the two documents generated.

Does anyone know of anything like this for any industry? I'd imagine there are other uses for a tool like this besides IT services. I'm also very open to a saas something like access/adp/sql where I could create the logic myself drag and drop, I just don't want to make custom web forms from scratch in .net or similar.
0
Comment
Question by:Aaron Tomosky
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 40

Assisted Solution

by:als315
als315 earned 1000 total points
ID: 41813628
Your task looks not very complicated from the first view. You can use MS Access. Look at sample DB which was prepared in 10 minutes.
Access can be converted to web app, but there are some limits.
DbIT.accdb
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 41813699
I would create a database in sql server express, then created a webpage in Visual Studio.
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 1000 total points
ID: 41814264
Access is a rapid application development tool (RAD).  It's power is that it can connect to any database engine that supports ODBC so using SQL Server as the BE is no problem The ADP was deprecated because it did not give sufficient advantage over simply linking a standard Access app to SQL Server and provided many limitations.

Unless you need the app to be outward facing, there is no advantage to having it be a Web app and making a Web app will be more labor intensive and expensive.  I would not under any condition recommend attempting to create an Access Web App.  They are severely limited due to not supporting any programming language.  Macros will get you only so far and most people run quickly into a brick wall.

Design the schema  in SQL Server.  Link an Access FE to the SQL Server database and use the wizards to create forms and reports.  As you get better definition of what you need, add code into the form and control events to validate data.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 39

Author Comment

by:Aaron Tomosky
ID: 41815283
Alright so access is a viable route, good to know. If I go that way, what's the best method of keeping data in sql, linked tables?

What about lightswitch or these alternatives, worth a look?
https://www.quora.com/What-are-some-free-alternatives-to-Microsoft-Visual-Studio-LightSwitch
0
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 1000 total points
ID: 41815298
What database you use to store the data depends on three things.
1. How secure do you need the BE to be?
2. How many concurrent users do you need to support?
3. How large is the set of data?

Depending on the answers to the questions, you may decide to use SQL Server, ACE, or any other database engine.
0
 
LVL 39

Author Comment

by:Aaron Tomosky
ID: 41815301
I'm very comfortable with sql and express is free. 4 users to start and may grow to 10 or so, nothing large. Data set is tiny.
0
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 1000 total points
ID: 41815308
Then that leaves you with security.  If there is no special security required, ACE will perform very well as the BE so the choice is yours.

I develop with Access as the FE and mostly SQL Server as the BE (but occasionally DB2, Oracle, Pervasive, and even Jet/ACE) because I find it to be a powerful client/server tool.  All the bad press you read about "Access" is actually directed to the native database engine which is Jet (.mdb) or ACE (.accdb).  People who compare "Access" to SQL Server have no clue what they are talking about.  A client/server app developed with an Access FE and a SQL Server BE is infinitely scaleable.  You are limited only by your SQL Server implementation.  Each user gets his own personal copy of the FE (I use a shortcut that runs a bat file to ensure that each user is always using the most recent version of the FE) and the FE links to the shared BE.  To switch from test to QA to production is simply a matter of relinking the tables.  NOTHING else needs to change.

If you elect to use Access, try to understand how its event model works.  The worst applications I have had the misfortune of having to fix have been developed by experienced developers who thought Access was inferior and tried to remake Access in the image of their favorite tool.
0
 
LVL 39

Author Closing Comment

by:Aaron Tomosky
ID: 41816406
Thanks Pat and others. If there are any other RAD tools I should check out, please let me know.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question