Access DB - Store Project Info & Create File Directories

Completado Publicado Nov 10, 2010 Pagado a la entrega
Completado Pagado a la entrega

Hi

I wish to have an Access 2007 Access Database designed and created. This should work from a central drive location so two people on seperate machines can share it. One machine is WindowsXP running Office 2007 while the other machine is Windows7 running Office 2010.

Ability to create file directories:

I need an MS Access database for managing Projects and Directories. When I create a New Project I want to be able to choose a Category and this will determine the directory where the new Project Directory is to be created and stored. Once the project has been created, I want a Shortcut created on the users desktop.

I will need to be able to create directories on my portable hard drive so there will need to be the option of creating the directory there or on our server P: (portable hard drive) or S: (file server)

You will need to confirm that you understand the requirements by providing a database design. You will need to be proficient at designing Relational Databases and should be comfortable with normalisation. I may want to add onto this in the future so it is important that you design it correctly at the beginning before building it.

I should be able to store and create Categories, every new Project should be applied to a certain Category. Everytime a Category is created it chould create a folder in my root project directory with the category as the name, any Projects created under a category should create a folder in the category directoy and the folder name should be the same as the project name.

All project directories should be JobNumber + ProjectName e.g RD0001 Business Powerpoint

The project I create are usually jobs I am doing for other staff members so I need to be able to store names and select which one I need when I create a new project. The Staff member should have a reference number or a name as the Job Reference.

Project Number

Project Name

Server or Remote

Staff Member

Job Reference

Project Category

Project Description

Tags

Each Project will be given a unique id - Database generates job numbers e.g. RD0001 - RD being the prefix and 5 digits as the suffix minimum.

Cannot have a project without a project name

What is the project name?

Must choose root drive – server or portable hard-drive

Root Directory: Server or Remote? (Mirror directory structure but not files)

Cannot have a project name without a staff request

Who in office am I doing it for? (ability to store names)

Cannot have a project without a staff request reference number

Who is he doing it for or what is his reference number?

Cannot have a project without a project category

What project type/category does it come under?

Cannot have a project without a project description

How can it be best described?

Cannot have a project without at least three tags

Add or Select Tags that are closest to the type of project it is.

Tags should be able to be added to database and applied to new projects

I can provide some graphics to illustrate the user interface but it will be up to you to make it as tidy as possible.

I will need a search page and I will want the options of what fields I search as well as the ability to search the whole database.

I would like a page where I can view all of the tags and see search results when I click on them.

If you are familiar with this type of work please bid $80, we can discuss details in the PMB

Thank you.

Attached are some images I thought might help.

Microsoft Access SQL Visual Basic

Nº del proyecto: #850145

Sobre el proyecto

3 propuestas Proyecto remoto Activo Nov 10, 2010

Adjudicado a:

jhaynes75

Professional software developer with over 10 years experience. Please see PM.

$80 USD en 3 días
(29 comentarios)
6.1

3 freelancers están ofertando un promedio de $80 por este trabajo

piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$80 USD en 2 días
(12 comentarios)
4.2
AccessAuthority

We have the skills and experience to complete your project. Please check your PM for details.

$80 USD en 6 días
(5 comentarios)
3.1