This is the first Access Database I have ever built. I have (4) tables, (6) forms, and (2) Sub Forms. I want the forms and tables cleaned up…spacing and appearance, any obvious issues, or improved ways of doing what I already did to make the database function better.
I want you to learn the database, how it functions, and understand what I was trying to accomplish.
Attached are some screenshots to show you what you will be working with. Once hired I will send you the file to work on the database. The screenshots should give you an idea of what you will be working with.
We will have about 6 users who will be accessing this database immediately and more in the future. I want to know how we need to setup the Access database so that when users’ login and make updates to the designated fields other users will see the changes so that we are all working in one database with the same up to date content. Also, I don’t want users to see or have access to make change to the structure of the database. All they see are the fields that they can have access to for making updates, running reports, and entering data.
I want the “frmUserLoginScreen” to be the first screen that users will access, automatically, so that they must start there. Once they successfully enter the credentials…they will then be taken to the “frmMainScreen”. From there they can navigate the rest of the database.
I want another form and table (new) for a module called “Pipe Tracker”. It will have a dropdown menu with the following options (28 options for different pipe)
2" inside 3" Pipe Over Pipe
3" Inside 4" Pipe Over Pipe
2" LCX Pipe
3" LCX Pipe
1.5" Flexworks Pipe
2" Flexworks Pipe
2" Single Wall Pipe
3" Single Wall Pipe
4” Single Wall Pipe
1.5” UPP Pipe
2” UPP Pipe
3” UPP Pipe
4” UPP Pipe
1” XP Pipe
1.5” XP Pipe
2” XP Pipe
1.5” Black Steel Pipe
2” Black Steel Pipe
3” Black Steel Pipe
4” Black Steel Pipe
1.5” Galvanized Pipe
2” Galvanized Pipe
3” Galvanized Pipe
4” Galvanized Pipe
1.5” Stainless Pipe
2” Stainless Pipe
3” Stainless Pipe
4” Stainless Pipe
I also want the options to be ”Job Name” (as a user text), “Estimated Number of Feet” (as a number), “Estimated Number of Hours” (as a number), be ”Job Name”, “Actual Number of Feet” (as a number), “Actual Number of Hours”. I want another field that shows the variance (difference) between what was estimated and what was actually used. I want a form that displays the results by Job Name displaying the data from the tables and forms.
The table that contains the user names and passwords needs to be protected so that only one person will have access to update users and passwords.
I want to ensure that all the buttons are configured correctly
This should be an easy project for someone who knows how to build and work on Access Databases.
Please let me know if you have any questions.
22 freelancers are bidding on average $211 for this job
We have successfully finished over 520 projects in last 18 years. ID : 16324506 Greetings, We are interested to work on this project, please find my comments inline with yours, 1. Microsoft Access Database - Up Daha Fazla
[url removed, login to view] I have gone through your project requirements and the three screenshots. I will do all the things mentioned in your description for the pipes tracking I will do the job within 3 days only My ratings and r Daha Fazla
Hi! Yes, those are more-or-less standard requests, to have a login screen, protected user's table, fully customized user interface and to make it work in local network (simple file-sharing can work, but the database Daha Fazla
Went over the descriptions and the screen shots - Adding user login with user based rights should be straight forward. We can also add a audit trail if it is required where you will be able to track which user has mad Daha Fazla
Hi, my name's Paris. I'm a proficient Access database developer. I've completed over 200 projects successfully on this site only as you can see for yourself on this platform. My clients are happy and this is strongly Daha Fazla
Let me review the existing database. I can do the User management system for your application and all requirements. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with Daha Fazla
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the shortest possible time and with the highest Daha Fazla
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines Daha Fazla
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects I've developed for Ms Access/Excel/VBA projects. Here need to build a split Ms Access Daha Fazla
Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications I'm also available 24 x 7 Regard Daha Fazla
Hi, I read your descriptions, it is quite detailed. I can provide you with the modifications and user access/restrictions based on your description.
I am very able to create this Access database to cater all your requirement. I am ready to start regsrds
What version of MS access you are using? You want to work in local network, right? Thanks, Alexander TheCloudKernel
I am ms access specialist. Relevant Skills and Experience Ms access specialist work fast and low price.
SABA IT Solutions specialized technology startup in Data Engineering providing Solutions and Services focused on enriching data value. We provide customized services for giving you competitive advantage and help you im Daha Fazla
I am an IT student and a leader of a small team formed of programmers,database experts and eeb [url removed, login to view] are eager to work and are very professional and passionate at what we do. We would be proud to work ob this p Daha Fazla
Greeting, I have understood your Microsoft Access Database - Update and Configure task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Dat Daha Fazla