ACCESS DATABASE

1. Write a set of queries in SUBSCRIBER database that delete existing records in local tables

2. Write a new set of queries that append data from LINKED database

3. Write new database tables to new database based on table options in a customer’s record.

After customers database has been written .ZIP database named [CustomerName]+ 4 date

Example MIDWEST1006 this is the customers name “ MIDWEST?? and MONTH YEAR

FTP to specified FTP site

Send automatic email to customers email address.

Email will be sent by outlook

IN the SUBSCRIBERS database there is a SUBSCRIBERS table it has a list of

Contact & 2 email address which will be used for sending the email to the customer

Also in the subscribers table is several YES/NO fileds that if checked that is the table that the subscriber is to receve.

FTP access and FTP DIRECTORY to be set in a table by me.

Please test this on your own FTP before sending.

I will supply a sample set of data and the empty tables for both databases.

Thank you.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Access 2003 Windows

Ingeniería Microsoft Access MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3770764

Sobre el proyecto