Microsoft Access activity tracking database (linked to multiple internal/external contributors, external companies)

Job Description:

A MS Access database (table relationship design, forms, macros/vba) with functioning logic (but no nice formatting needed):

- Activities tracking (activity description, internal-contributors, external-contributors, external-companies)

- Activities can have multiple "internal-contributors" and multiple "external-contributors"

- "external contributors" work for "external-companies"

- Database user can create/edit activities and add/remove multiple "internal-contributors" and multiple "external-contributors"

- Database user can also create/edit activities and add/remove multiple "internal-contributors" and multiple "external-companies" (without specifying which "external-contributors").

- Database user can also search and open an individual contact (e.g. internal-contributor, external-contributor, external-company) to see what activities are linked to them and add further activities.

So it includes multiple many-to-many relationships around activities, where data can be searched / entered from different angles. Sometimes activities are linked only to internal-contributors and external-companies, sometimes they are linked to internal-contributors and external-contributors (and therefore also linked to their external-companies they work for).

Forms to open/edit should include some kind of comboboxes to search/add/remove contributors or companies or activities as there will be for example 2000 contributors.

This is just a prototype to compare the logic/code/approach with an existing database. So no nice formatting is required. But best practice for such a database design should be applied (e.g. no multi-value fields...)

Beceriler: Microsoft Access, Uygulamalar için Visual Basic, Database Design

Müşteri Hakkında:
( 12 değerlendirme ) Singapore, Indonesia

Proje NO: #34778166


(273 Değerlendirme)

Bu iş için 9 freelancer ortalamada $170 teklif veriyor


Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Daha Fazla

$200 USD in 5 gün içinde
(49 Değerlendirme)

Hi, how are you? I go through the description and read it carefully, I know exactly what you are looking for. I have 5+ years’ experience in these skills Database Design, Visual Basic for Apps and Microsoft Access. I Daha Fazla

$200 USD in 9 gün içinde
(0 Değerlendirme)