Archive

Posts Tagged ‘database with’

Access Database With Reports

November 22nd, 2009 Comments off

I have an access data file that I’d like it to output reports into Excel Spreadsheet. I’d like the report to be able to be able to use dropdowns to select up to 10 criteria.

this is for a voter list and I’d like to be able to sort out demographics easily, by report feature.

e.g. find every female over 25 in town x that that lives in x street and voted at least 5 times in last 5 years.

I have all of the data it’s the reporting I need.

Database With Members Login

June 10th, 2009 Comments off

I have previously created a website

Now i would like to link it to a database. Using mysql, php, xhtml.

First, i would like to create a mysql database for the student and tutor accounts. the information gathered from the existing form should flow into the 2 database. Everytime someone send information via the TUTOR and STUDENTS, he will also create an account using the email as user id which he can login on a separate occassion to adjust his details. Every time a new entry or an amendment comes into either database, it should also send the data by email as an excel sheet.

Next, it has to have an additional tab called COORDINATOR where coordinators can login to access the database on the TUTORS only. It should be able to search the database by latest data, nearest MRT. If possible I can adjust the search types.

Third, it should also has another additional separate staff login. A master login, where I am able to access both the STUDENT and TUTOR database online. I should be able to delete, amend STUDENTS, TUTORS and COOREDINATOR account details. I should be able to add Coordinator accounts. It should be able to search all the database by latest data, nearest MRT. If possible i can adjust the search details.
If you need more information. please pm me.

thx

Web Database With Search Mode

May 21st, 2009 Comments off

Hi

I need to create a web platform to store and retrieve notes from clients meetings. It needs to work on the following way:

- Sales people type online(or upload) a meeting note
- this meeting note is then sent by email (as a pdf attachement) to selected people (Authorized Users + selected email adresses)
- The meeting note is then stored (ideally in pdf) on the databasem stored online
- The meeting note is then available for Authorized Users
- the Administrator needs to be able to download everything in excel format

Authorized Users are invited to the site by email and are given a login and a password. The Administrator can select either the Sector (with an additional layer for subsector) or the Client Name to give access to a number of clients to the Authorized Users.

For example, if my list inlude Coca Cola, Pepsi, Evian and Fanta, the Administrator can give access only to Coca Cola or to Soda (Coca & Pepsi) or to Beverages (all of the examples). For each user, the Administrator should be able to modify the list of access right or to stop access and close the account. Each sales person should create its clients (with basic contact details) prior to create his meeting note.

thanks

Bear