Microsoft Access Database - Update and Configure

Törölve Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Törölve Kiszállításkor fizetve

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.

Thank you

Adatbázis-fejlesztés Microsoft Access

Projektazonosító: #16324506

A projektről

21 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

21 szabadúszó tett átlagosan 214$ összegű árajánlatot erre a munkára

branislavm

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 Továbbiak

$155 USD 3 napon belül
(201 vélemény)
6.9
torajiv

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 Továbbiak

$222 USD 3 napon belül
(153 vélemény)
6.8
paris2785

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 Továbbiak

$190 USD 5 napon belül
(93 vélemény)
6.6
VladimirLilenko

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 Továbbiak

$200 USD 3 napon belül
(94 vélemény)
6.0
jawadaman

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 Továbbiak

$222 USD 3 napon belül
(71 vélemény)
5.6
zu02

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 Továbbiak

$555 USD 10 napon belül
(45 vélemény)
6.1
carlosperezit

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 Továbbiak

$155 USD 10 napon belül
(6 vélemény)
3.8
reedsystems

Hi, I read your descriptions, it is quite detailed. I can provide you with the modifications and user access/restrictions based on your description.

$200 USD 6 napon belül
(4 vélemény)
3.3
sonarkaushik

I am very able to create this Access database to cater all your requirement. I am ready to start regsrds

$194 USD 3 napon belül
(3 vélemény)
2.9
bnrajumnc

A proposal has not yet been provided

$333 USD 10 napon belül
(0 vélemény)
0.0
bahaado

im programmer with few years of xp, also know all it things, have 75 wpm typing speed, have faculty bachelor degree. write me for details

$100 USD 3 napon belül
(0 vélemény)
1.1
thecloudkernel

What version of MS access you are using? You want to work in local network, right? Thanks, Alexander TheCloudKernel

$500 USD 5 napon belül
(0 vélemény)
0.0
harishary

I am ms access specialist. Relevant Skills and Experience Ms access specialist work fast and low price.

$155 USD 3 napon belül
(0 vélemény)
0.0
whitehorsetechn

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 Továbbiak

$250 USD 3 napon belül
(0 vélemény)
0.0
JHButler

The fact that I sense an element of training implicit in the program's specifications let's me know that this makes me the ideal freelancer for the job. Remembering that a lot of what I do for our clients involves teac Továbbiak

$277 USD 5 napon belül
(0 vélemény)
0.0