Closed

Access Database

I need someone who can program an access database for me here is a layout of the general project below. I have drawings and more detail I can give to the person who wins the bid. I need this done asap so don't bid if you can't focus on the project soon. Thank you.

I need a form designed that will work a incident tracking software. It's very simple it will have a login form, a main form (with a new button, report button, and search/edit button), then there will be a form that has a tab section. I will explain in more detail below. There will need to be a users table (access to buttons and certian features is based off account type), there will be about 8 other tables that will hold data. Most of those tables are static, the rest are for when data is entered or edited.

Form 1 - Login

The login form is simple it will be a username and password. If the user info is correct is goes to the main form if not then it loops back.

Form 2 - Main Form

This form again is simple. It will have a logo then 3 buttons. 1 button will say new which will lead to the new form, the next is search will will lead to the search form and finally is edit which will also lead to the search form. Based on user privileges some buttons will be grayed out. Only admin and modify users will use the new button and edit button. All others can only search

Form 3 - New Form

Once the user clicks on the new form a pop up box appears the user has 4 check boxes each check box they select will become an open tab in the next form.

Form 4 - Info Form

Once the user has selected the boxes from the new form a form opens that has up to 4 tabs those tabs are based off which boxes they selected. For example lets say they select 1 and 3 on the new form screen then there are tabs 1 and 3 on this new form. They enter information here and click save and that info is put into the database.

The search forms are realively simple they will link to reports. The edit button will let them search for a certian incident and the let them edit the incident in the info form.

Again I am looking to get this done asap and would like to some time lines along with the bids. Let me know if your interested.

Due to the number of request I have received and the questions I have decided to post this addition. If you are still interested in the project please let me know.

Basic Login Form and Table

See the attachment called login.png This will tie to a table. This table will have 5 columns, username, password (plain text), employee id, email, and access. There will be 3 access levels admin, modify, and read.


Main Form

This is the main form. Here is where access rights come in to play. If they are an admin all buttons are open to them. If they are modify only new, edit, and search are open to them. If they are read then only the search button is open to them. See the main form.png attached There is no table attached to this form.

New Button/Form

When the new button is clicked then two things happen. 1 a master number is created. How you do this is up to you. But basically it will in the following format. YY.XXXX yy is the last 2 digits of the current year so 2012 is 12. and XXXX is the next number in the sequence so if the last master number was 12.0100 then the next one will be 12.01011 if the year changes between projects it doesn't matter so it can go 12.0555 to 13.0556. I don't know if you will make a table that will keep the the last master number used or how it will be done but the master number is how we track incidents. A new form pops up in that form it has 4 check boxes. ERP, PPAP, 8D, and Dev. Each one has a check box by it the user can select all 4 or 1 or whatever they want. Once they click okay then a new form pops up. This form is a tab based form (see attachment newform.png) This form shows the current master number and also has 4 tabs below. The tabs are ERP, PPAP, 8D, and DEV. If they didn't select the checkbox in the previous screen then the n/a box is checked for that tab and everything is grayed out. They can uncheck that box and everything becomes available and vice versa. I will give more information about what information will be under each tab but basically it will be a bunch of checkboxes and stuff like that. There will need to be a save button and all the information in each tab will need to be saved into a table. So the table will have master number then the information from each tab in it.

Edit Button

Edit button works by letting them search by master number and then edit the information in each form. So basically edit works like the new button but instead it searches based off a master number they put in.

Read Button

It works like the edit button they can search by master number but when they pull up the tabs they can't edit anything.


So let me know what you think and if you can get this done. I have a 2 week time frame but I need progress on regular basis. Thank you.

Skills: Microsoft Access

See more: pop up search box, i need an access database, give me a username and password, access database software, access data, microsoft access logo, incident, c# with access database, c with access database, access database, project tracking access database, access project program, database privileges, tracking database access, check box select, database rest, microsoft access project tracking, modify access, pop tab, simple access example, access database form reports, admin access, asap database, microsoft account, microsoft access check

About the Employer:
( 0 reviews ) Anderson, United States

Project ID: #2569368

34 freelancers are bidding on average $302 for this job

Prashantskin

[url removed, login to view] I have gone through your project requirements regarding approx 4 forms in access.. and related tables. Please see PMB for details Regards Prashant

$300 USD in 3 days
(460 Reviews)
6.9
rhomeu

MS Access expert here. I can build the database you wanted. Please my profile. Thanks!

$350 USD in 2 days
(49 Reviews)
6.7
jhaynes75

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

$400 USD in 7 days
(30 Reviews)
6.1
kulhanekd

I have 15 years exp in access and I can build the database you need. Donna

$400 USD in 710 days
(34 Reviews)
5.8
torajiv

Access and VBA expert here - can complete in this week - more details in PM - Thanks - Rajiv

$250 USD in 5 days
(60 Reviews)
5.6
winghei

HI, I see your needs and I want to help.

$250 USD in 2 days
(29 Reviews)
5.3
Krusche

Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. We assume high quality work both in terms of technical background and time frame issues. Please check your More

$400 USD in 9 days
(7 Reviews)
4.9
diegogarcia0531

Hi, I can do that, I will deliver the database asap

$250 USD in 5 days
(15 Reviews)
4.8
piyushdpatel

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

$250 USD in 7 days
(8 Reviews)
4.7
winnet21

Hi, I have experience with this project Please check PM Best Regards winnet21

$250 USD in 2 days
(11 Reviews)
4.8
amnmttl

Hello, I have carefully read you requirements and understand you need a management solution for your data in a simple and efficient format. I propose a form based .NET solution with access database. Please check PM More

$300 USD in 7 days
(15 Reviews)
4.3
braghunath

I have been developing applications in MS Access since 2003. I can take up this project immediately.

$360 USD in 15 days
(3 Reviews)
4.1
AccessAuthority

hi, We are Sydney based access expert and working in commercial environment for 8 years. We are very interested abt ur project. pls see our profile, our 100% completion rate proves our reliability. We can deliver the More

$250 USD in 4 days
(5 Reviews)
3.1
amfuries

############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############

$250 USD in 3 days
(2 Reviews)
3.1
AccuPro

Hello, I can help.

$250 USD in 2 days
(1 Review)
2.5
skctechno

I can deliver it for you.

$250 USD in 15 days
(1 Review)
2.4
adim

Hello there, I'm a software engineer with more than 10 years experience in Excel, Access, VBA, VB6 and .NET. I'm sure I can help you with your task. I can do it for 230 USD. Best regards, Adrian

$250 USD in 3 days
(2 Reviews)
2.4
mukulsinha25

Greetings Client, I have read your project details and can help you in successfull completion of this project. I have worked on similar project as you can have a look at my portfolio.I have over 7 years of experience More

$250 USD in 5 days
(1 Review)
2.0
raman2012

I can build the access database check my PM

$300 USD in 5 days
(0 Reviews)
0.0
CroweSoft

Over 16 years professional working experience for large UK firms

$750 USD in 10 days
(0 Reviews)
0.0