Ακυρώθηκε

Microsoft Access Database - Update and Configure

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

Ικανότητες: Κατασκευή Βάσης Δεδομένων, Microsoft Access

Περισσότερα: how to check odbc connection in access, how to create odbc connection for ms access in windows 7, ms access odbc connection to sql server, ms access change odbc connection linked table, add/modify connection (microsoft access), access change data source, ms access change linked table path, ms access odbc connection, microsoft access database search function, microsoft access database students attendance, microsoft access database website, print receipts microsoft access database, php microsoft access database connectivity dsn, executeable file microsoft access database, convert microsoft access database exe, calendar schedules microsoft access database, microsoft access database project timeline, microsoft access database exe, convert microsoft access database java database, airline reservation system using microsoft access database

Σχετικά με τον Εργοδότη:
( 65 αξιολογήσεις ) Oxnard, United States

Ταυτότητα Εργασίας: #16324506

21 freelancers κάνουν προσφορές κατά μέσο όρο $214 για αυτή τη δουλειά

illuminesoft

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 Περισσότερα

$155 USD σε 3 μέρες
(224 Αξιολογήσεις)
7.3
Prashantskin

[login to view URL] 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 Περισσότερα

$194 USD σε 3 μέρες
(477 Αξιολογήσεις)
7.2
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 Περισσότερα

$155 USD σε 3 μέρες
(201 Αξιολογήσεις)
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 Περισσότερα

$222 USD σε 3 μέρες
(153 Αξιολογήσεις)
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 Περισσότερα

$190 USD σε 5 μέρες
(93 Αξιολογήσεις)
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 Περισσότερα

$200 USD σε 3 μέρες
(94 Αξιολογήσεις)
6.0
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 Περισσότερα

$555 USD σε 10 μέρες
(45 Αξιολογήσεις)
6.1
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 Περισσότερα

$222 USD σε 3 μέρες
(71 Αξιολογήσεις)
5.6
royalcalif

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 Περισσότερα

$30 USD σε 1 μέρα
(56 Αξιολογήσεις)
5.6
$155 USD σε 3 μέρες
(5 Αξιολογήσεις)
4.2
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 Περισσότερα

$155 USD σε 10 μέρες
(6 Αξιολογήσεις)
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 μέρες
(4 Αξιολογήσεις)
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 μέρες
(3 Αξιολογήσεις)
2.9
$30 USD σε 5 μέρες
(2 Αξιολογήσεις)
2.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 μέρες
(0 Αξιολογήσεις)
1.1
AZbabyface

I am an IT student and a leader of a small team formed of programmers,database experts and eeb [login to view URL] are eager to work and are very professional and passionate at what we do. We would be proud to work ob this p Περισσότερα

$222 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
thecloudkernel

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

$500 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
harishary

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

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
bnrajumnc

A proposal has not yet been provided

$333 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0