En cours

Access Database and Word Document with Macros

Access Project Management Database and Word Document (with Macros)

a. Description: This project is made up of two parts. We would like to create an interactive Input Form whereby our clients provide us with necessary information for our projects. Then we would like to be able to export certain portions of that completed word document into fields of an Access Database.

i. Part I – Word Document Portion – INPUT FORM/DOCUMENT

1. Need to create a word document (off of an already existing template) that will allow our clients to input information that we need to complete our project.

2. Upon opening the word document, the macro will start running and pop up windows will guide the user to enter certain types of information into the form (possibly in a specific format (i.e., “Oracle” Instead of “oracle”).

3. If the client does not answer a required field, either the next pop up window will not appear (i.e,. the client cannot go further in filling out the import form OR some other solution will be implemented here - TBD)

4. The types of answers entered in the fields (i.e., yes or no) will determine the next field or box that pops up.

a. Overall Requirements:

i. In addition to the above, the document:

1. Must allow certain fields in the form to be exported to an Access Database.

2. Must be able to be finalized and printed out by client before it is sent to COMPANY.

3. Must be able to be tweaked by us (pop up window instructions) and the template – for various projects.

ii. Part 2 – Access Database Portion – PROJECT MANAGEMENT DATABASE

1. Need to create a database that will house information and files of all projects COMPANY has completed

a. Overall requirements:

i. Must be able to import certain fields from Word INPUT FORM (above)

ii. Must be able to run reports regarding expiration date and alert when an agreement is going to expire

iii. Must be able to be automatically append itself when additional INPUT FORMS are IMPORTED

iv. Must be able to run reports re: Progress, etc.

v. Must be able to mail merge

vi. Produce a report that will alert Company of needed communication or follow up with client;

vii. Produce a report that shows notes re: last communication; and other fields including status, notes, etc.

viii. Must be able to have one or two input fields for project manager to enter information.

Compétences : Gestion de Projet, Administration Système, Visual Basic, Bureau Windows

en voir plus : word macro database, word document access database, macros create word document access database, word macro access database, access using macro import word document, word macro export access, word macros access database, create word document access, document control access database, export access form word using macro, word database macro, access database word, yes interactive, the parts house, status manager, project status manager, project agreement document, parts database access, oracle requirements management, oracle database company

Concernant l'employeur :
( 0 commentaires ) Chicago, United States

Nº du projet : #322592

20 freelance font une offre moyenne de $499 pour ce travail


Hello Please see PMB for details of my bid. Thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(114 Commentaires)

I am the most suitable person, and i am an expert in VBA/WORD/Macro/Access. Let me do this project. See pmb for more details.Thanks.-TUHIN

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(69 Commentaires)

Hello,Please refer your [login to view URL] you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(42 Commentaires)

Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(19 Commentaires)

Hello Please see your PMb for details. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)

This can certainly be done using Access Word VBA in which I have extensive experience. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(14 Commentaires)

Hi, Please refer [login to view URL] start....>

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(2 Commentaires)

Dear Sir/Madam , Please check my PMB for details . With Best Regards .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 11 jours
(2 Commentaires)

pls chk pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 18 jours
(1 Évaluation)

Greetings! I'm a full-time, US-based freelancer (native English speaker) with over five years of Microsoft Office development experience using VBA. See PBM for details and samples.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)

A day for the document and two days for Access part. Document template is easy, and template can control which fields are required and the format (no need for macro; which takes more processor time and memory). Inste Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Hi Pls refer my PMB for details. Regards Sirisha

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

Hi there I have all experience for this kind of job. have a great day

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

I have great DB skills and experience of working on Access..would do a perfect job.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

Hi, I am an Access veteran, Please see PM for detail of bid. Thanks, S Rao.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

We have very expereinced team in database and OLE. We are the suitable people for this project. Waiting for your response to start the project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

Have done similar projects before .. can be much more simplified..need to negotiate on the requirements

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)

I have around 10 years of experience in developing VB6 applications and word macros.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

I have done many projects integrating MS ACCESS ,VB, MSWORD. I just upload a demo project of using msaccess vb and ms word which calculate the arrears of pay. Just fill the fields in the form .plz invoke [login to view URL] a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

I can manage Access database creation from the scracth.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)