Access DB - Store Project Info & Create File Directories
$30-250 USD
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.
Nº del proyecto: #850145
Sobre el proyecto
Adjudicado a:
3 freelancers están ofertando un promedio de $80 por este trabajo
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
We have the skills and experience to complete your project. Please check your PM for details.