Lukket

MS Access Application - Visually Appealing

Hi!

I need a database to capture Vendor info, contract compliance and data from PDF forms.

Vendors:

=======

- Regular contact database information (name, address, phone, url, website, federal id, etc.

- Multiple subcategories (Category A, Category B, Category C...)

PDF Forms:

==========

- Vendors complete forms in PDF format and email them to me.

- There are many PDF forms - I need to easily import the data. Initially, I will start with one form (see attachment)

Access Forms:

===========

- Add/Edit Vendor contact info (standard info like name, address, email, website, phone, fax, Federal ID No., etc.)

- Input data from PDF form (E.g. See attachment)

Sample Reports:

============

- List of vendors/contractors and subcontractors

- List of vendors based on features selected (e.g Category, State, etc.)

- Which vendors submitted documents by deadline? (based on type of form submission and selected quarters (Q1, Q2, etc)

- Which vendors did not submit documents by deadline? (based on type of form submission...)

- Which vendors have incomplete submissions?

- Which vendors are not reaching their 10% target based on "Total Payments Made-to-Date?"

Tables

=====

Below is an initial list of tables that will need to be created:

- Company Contacts (contacts from my company. These contacts may be contract managers of the Vendors/Contractors and would be linked to that table)

- Vendors/Contractors (demographic info)

- Vendors/Contractors Contacts (Employees) (this table lists employees of the “Subcontractor” table)

- Subcontractors (demographic info. Subcontractors can be associated with many Vendors/Contractors)

- Contractor_Sub (connects Vendors/Contractors and Subcontractors. 3 columns – primary key, Vendors/Contractors primary key, subcontractor primary key)

- Subcontractors Contacts (Employees) (this table lists employees of the “Subcontractor” table)

- Forms (list of all forms and deadlines)

- Quarterly Report (captures data from quarterly report form)

- Compliance Status (2 columns – primary key and status - Submitted, Incomplete Submission, Goal Met)

- Contract Type (2 columns – primary key and contract type)

- Communication (This table will show the communication instances that my company initiated with the Vendors/Subcontractors. E.g. 5/1/14 – Called vedors to remind to submit invoices” and 6/3/14 - Sent an email blast to remind vendors to submit invoices.)

- Compliance Communication (this table will join the “Vendors/Contractors” table with the “Communication” table to show the number of times and types of communication that my company sent.)

-

It would also be nice to have an Excel interface into the Access Database.

A key portion of this project is design and usability. I want a modern looking database and nothing that resembles basic MS Access. I want this to look like a professional standalone application.

Færdigheder: Database Administration, Programmering af database, Microsoft Access, SQL, Visual Basic

Se mere: vendor database ms access, project based contract sample, i need a professional looking email address, import ms project, federal times, edit pdf form, design access database, data access interface, b&c compliance, access vendor database, ms access sql, forms of communication, ms access email, excel to my sql, e blast, capture invoices, application lists, project database design pdf, excel access table, visual basic goal database, access data input forms, visual basic access application, sample visual basic excel, modern excel report design, look company number employees

Om arbejdsgiveren:
( 1 bedømmelse ) Brooklyn, United States

Projekt-ID: #6030353

19 freelancere byder i gennemsnit $476 for dette job

finecodervw

Hi, I will be happy to discuss further on this with you. Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small Mere

$400 USD in 12 dage
(103 bedømmelser)
6.0
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mere

$526 USD in 10 dage
(14 bedømmelser)
5.1
KellogITSolution

Hello I am working with MS-Access database and VBA for the past 14 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Mere

$155 USD in 7 dage
(33 bedømmelser)
4.9
paris2785

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Lollipop (video demonstration) [url removed, login to view] and feedback a Mere

$250 USD in 7 dage
(22 bedømmelser)
4.6
jawadaman

Hi, I am interested in this project. i can do the job for you. I am a proficient MS-Access database application developer. if interested in hiring me then please let me know so that we can discuss the scope, timelines Mere

$138 USD in 3 dage
(16 bedømmelser)
4.3
pnjadhav

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli Mere

$277 USD in 5 dage
(4 bedømmelser)
4.1
farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data Mere

$122 USD in 6 dage
(16 bedømmelser)
4.0
acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a DBA at CMM5 Level company since August 2009.I am working on MySql,SQL ,MS Access,Oracle database, I can do your job confidently. I am very much In Mere

$333 USD in 10 dage
(10 bedømmelser)
4.1
pkcyber

see one of my sample application [url removed, login to view] i am willing to do work for you. you will get great product in final. Keenly looking forward your response.

$250 USD in 5 dage
(4 bedømmelser)
3.3
fazeelatmazhar

Sir/Madam, Greetings. This is an IT person and an experienced database developer .I have checked the attachment .I am presuming you would need basic CURD (create record , update , retrieve and delete record) opera Mere

$150 USD in 3 dage
(5 bedømmelser)
3.2
joseluiselp

Hello i think i can do this, let me know if you are interested i have exprience with this,. Jose Luis Mendoza Software Ing.

$180 USD in 7 dage
(2 bedømmelser)
3.0
Subburaj01

Hi There, How are you doing? I can finish this project within a few days and my price is negotiable. have 8+ years of experience in IT programming and good knowledge in VBA, Access , SQL tools. Moreover hav Mere

$210 USD in 7 dage
(1 bedømmelse)
2.6
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a Mere

$30 USD på 1 dag
(4 bedømmelser)
1.1
rlpenn

Your budget is way off. The company I do most of my contracting work for would entertain the possibility of doing this work for you for $4600. Pay in advance. It can be in two payments. I write databases for small t Mere

$5111 USD in 45 dage
(1 bedømmelse)
0.9
KarelPdiaz

Lic. Matematica - Computacion, con mas de 12 años de experiencia en diseño y desarrollo de software, experiencia den C#, Delphi, C++, gestores de bases de datos como MSSQL, InterBase, MySql, FireBird contact me

$155 USD in 3 dage
(0 bedømmelser)
0.0
garfchong

I have built a similar but much more complex system for my customer. I can make a web form for you to store, manipulate and edit your vendor's data in web form + ms access database. you don't even need you vendor to Mere

$66 USD in 3 dage
(0 bedømmelser)
0.0
BeautiCG

i can do it. i am a c++c#/java super programmer and database, sql , pdf expert. i have many developing experience of various projects during five years. thanks.

$250 USD in 3 dage
(0 bedømmelser)
0.0
andyborrero

2 years ago I developed a module that reads information from PDF files, this is the most complicated of your project. Concerning to the management of the database in Access does not have any kind of complication, altho Mere

$155 USD in 3 dage
(0 bedømmelser)
0.0
linguangsui

Hello sir, I have a highly capable team of developers with 15+ years of experience in different programming areas. We've developed several large scale applications such as: - Program Deactivator (clone of Tuneup Util Mere

$157 USD in 7 dage
(0 bedømmelser)
0.0
sobuj

Hi there I am ready to work with you. 5 years experience in database programming. MS SQL, MY SQL, MS Access Thank you

$155 USD in 3 dage
(0 bedømmelser)
0.0