Microsoft Access Database - Update and Configure

Avbrutt Lagt ut 6 år siden Betales ved levering
Avbrutt Betales ved levering

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

Database-utvikling Microsoft Access

Prosjekt-ID: #16324506

Om prosjektet

21 bud Eksternt prosjekt Aktiv 6 år siden

21 frilansere byr i gjennomsnitt $214 for denne jobben

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 Mer

$155 USD på 3 dager
(201 Omtaler)
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 Mer

$222 USD på 3 dager
(153 Omtaler)
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 Mer

$190 USD på 5 dager
(93 Omtaler)
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 Mer

$200 USD på 3 dager
(94 Omtaler)
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 Mer

$222 USD på 3 dager
(71 Omtaler)
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 Mer

$555 USD på 10 dager
(45 Omtaler)
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 Mer

$155 USD på 10 dager
(6 Omtaler)
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 på 6 dager
(4 Omtaler)
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 på 3 dager
(3 Omtaler)
2.9
bnrajumnc

A proposal has not yet been provided

$333 USD på 10 dager
(0 Omtaler)
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 på 3 dager
(0 Omtaler)
1.1
thecloudkernel

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

$500 USD på 5 dager
(0 Omtaler)
0.0
harishary

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

$155 USD på 3 dager
(0 Omtaler)
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 Mer

$250 USD på 3 dager
(0 Omtaler)
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 Mer

$277 USD på 5 dager
(0 Omtaler)
0.0