Build Database in Microsoft Access

I've attached several Templates to aid the beginning of this project. Please review the components for the final project design.


1. Create Access Database Management System with "Administrative ID" and "Employee ID" login.

- Employee ID or Administrative ID

- Password

System Admin:

a. password change

b. settings

c. users

2. Database should consist of the following Project Management Components.

- "Administrative ID" Access to Distribute Projects based on "Employee ID"

- Generate Report for each project for "Administrative ID" review.

3. Fillable Forms for "Employee ID" to input project details based on daily tasks.

a. project name

b. project description

c. project begin date

d. project end date

e. project budget

f. project budget in days

g. Query Employee Comments

4. Fillable Forms for "Administrative ID" to report feedback to "Employee ID" based on project name.

a. project name

b. project owner (filter employee ID)

c. project description

d. project begin date

e. project end date

f. project budget

g. project budget in days

h. Query "Administrative ID" Feedback

5. Project folders to maintain project information

a. project name

b. project details

c. project documentation (upload attachments and filter attachments by project name)

d. project category

e. project priority

f. project status (show percent complete values)

6. Project Budget

a. generate report

b. budget documentation (upload attachments and filter attachments by project name)

7. Dashboard Buttons to include:

a. "New Project" button (fillable form)

b. "Collect Data" button (generate report)

c. "Email List" button (generate email link to outlook mail)

d. "Open Projects" (generates list of open projects)

e. "Completed & Deferred Projects" (generates list of completed and deferred projects)

f. "Queries" by contacts, open tasks, overdue tasks, priorities, status, assign tasks

g. "Exit" button (back to login screen)

8. Database should product the following:

a. Track multiple projects (time sensitive deliverables, owners, budgets)

b. Navigate by projects, tasks, and "Employee ID", project costs, priorities, project status

c. Time worked on project

d. Issue tracking and Reminders

9. Purchasing & Billing

a. Include billing invoices, and balance sheets (fillable form and upload documentation optional)

b. Purchase orders, goods received, product maintenance, non stock products, purchase requirements,

10. Inventory Management

a. search by item name, category, or location

b. retain important details (condition, acquired date, and value)

c. attach photos of items, packing slips (upload)

11. Generate Contacts from Outlook

a. company

b. job title

c. contact information

12. Event Management

a. customizable event navigation and filtering

b. track events by time (current events, events by week, todays events)

c. collect data in real time via email and generate and distribute report.

Lastly, lets make it visually appealing, but still easy to use.

The design should include the following:

- area for logo in top right & left hand corners

- display Users name next to left hand logo

Please see attachments for an idea of the design concept. Please keep colors simple and in blacks, whites, greys, yellows, and greens. Please keep in mind the major function is project management, therefore communication and admin and employee through project relations is very important for this database. Thank you.

Habilidades: Microsoft Access, SQL, Programação de Banco de Dados, Desenvolvimento de Banco de Dados, Programação C#

Veja mais: designing newspaper database microsoft access, video rental database microsoft access, online student registration database microsoft access, how to create a database in access 2007, microsoft access database, microsoft access tutorial, how to create a database in access 2016, how to create a database in access 2010 step by step, steps to create database in ms access, how to create database in access, how to create a database in access 2016 step by step, incoming mail database microsoft access samples, skills database microsoft access, build database csv access, simply accounting database microsoft access, database microsoft access, free work order database microsoft access, inventory counting database microsoft access, personal finance database microsoft access, telephone list database microsoft access

Acerca do Empregador:
( 0 comentários ) Abingdon, United States

ID do Projeto: #21850500

7 freelancers estão ofertando em média $36 para esse trabalho


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Mais

$120 USD in 4 dias
(19 Comentários)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Mais

$30 USD em 1 dia
(70 Comentários)

Why I don't allowed on chat with you? Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02? Mais

$26 USD in 7 dias
(48 Comentários)

Hi, I hope you are doing well.  Microsoft Access and Microsoft SQL Server in combination are extensively serving small businesses since 1997 in getting their business processes automated and staying ahead in this c Mais

$23 USD em 1 dia
(31 Comentários)

Thank u for posting your project. I'm a expert in C ++, C#, I 've taken part in the National ACM Contest in 2016(that was Algorithm contest with C++ ) and win a bronze medal. I have 8 years of experiences with C, C# a Mais

$20 USD in 3 dias
(2 Comentários)

Hi I'm an Access/VBA developer with over 25 years experience building database applications. From your detailed instructions, it looks like a project I'd really enjoy building. It's nicely laid out and quite easy to fo Mais

$25 USD in 7 dias
(1 Comentário)

I am a .Net professional and has been working on Microsoft technologies such as MSSQL, VB6, C#.NET and VB.NET. I have 5 year experience in the industry and I am in charge of developing and upgrading Pharmaceutical soft Mais

$10 USD in 15 dias
(0 Comentários)