In Progress

Microsoft Access User Interface

Objective: to create a user interface on an existing MS Access database that will allow lookup, delete, add and delete functionalities, as well as report generation and email sending.

Problem:

Our client is manually looking up and updating data on the Access database. As the DB has grown the amount of time required to maintain the DB has grown exponentially.

Details:

1. The user interface will need lookup tools, i.e. entering a client number, or surname, or address to bring up full record details - where several records are found, a list needs to appear allowing user to select the record.

2. Once full details appear, this can then be updated or deleted.

3. Functionality to add new records.

4. Functionality to send emails to given records, based on information in given fields.

5. Some fields may need to be calculated, i.e. where there is a commission rate of 10%, then box x shows this in £.

6. Automated tools:

- Automatically include a sequential client number for new records.

- Auto update of fields - i.e. remove a flag in field 30, from 30 days of the date in field 28.

7. Access to DB will be restricted - access should only be via UI.

8. Report generation on given field(s), i.e. maintenance due in the next 30 days (using field x).

Other information:

- There are templates available in the latest versions of Access - we are happy to use and update a given template for this project.

- Project needs to be functional by 29/04 - exactly what is delivered on this date can be arranged up-front.

- A copy of the database is attached - it has been created using Office 2016.

- Please state the programming language you intend on using.

- We will provide grouping information for the UI once the project has been awarded.

- Evidence of work with UIs would be beneficial.

- DB is in .mdb format, this can be updated.

- This is our first UI project, therefore, we would appreciate feedback and input on the above requirements, as we may have missed simple requirements that should have been included!

Thank you in advance, and please let me know if you require further information.

Mike

Update 1 - we will need project coding to be delivered once given steps have been completed. From our side, we will deliver milestones at these points also,

Skills: Database Development, Microsoft Access, Software Architecture, User Interface / IA

See more: what is an interface in programming, sequential programming, programming in access database, programming access database, ms project it templates, ms office programming, ms lookup, ms access programming, microsoft project template, microsoft programming software, microsoft programming language, microsoft number, microsoft access programming, latest programming language, generation of programming language, first generation programming language, user access form pdf template, microsoft access crm database template, inventory management access microsoft template, microsoft access 2007 inventory template, microsoft access student fees template, microsoft access contract system template, microsoft access child care template, use java access microsoft exchange, template access microsoft

About the Employer:
( 33 reviews ) Swindon, Guernsey

Project ID: #10209471

Awarded to:

florinserban

Hello, My name is Florin, I am from Romania and I am a database applications developer. After going through the project description, I can provide a simple and user friendly solution for your needs. You will not re More

$250 USD in 5 days
(17 Reviews)
4.9

36 freelancers are bidding on average $492 for this job

Prashantskin

[url removed, login to view] I have gone through your project requirements. I will do all the things mentioned in your project description. My reviews will give you confidence in me I will do the job well in advance of the stipu More

$388 USD in 5 days
(544 Reviews)
7.2
timid

hi, I have 8+ years of experience in the field. Within this period, I have worked with well established small businesses, non-profit organizations and growing experience helped me develop a good design perception wh More

$750 USD in 10 days
(134 Reviews)
7.1
torajiv

Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by go More

$300 USD in 10 days
(138 Reviews)
6.8
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$500 USD in 10 days
(60 Reviews)
6.0
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to pin More

$555 USD in 10 days
(24 Reviews)
6.2
$526 USD in 10 days
(5 Reviews)
5.2
$555 USD in 10 days
(17 Reviews)
5.4
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 a More

$555 USD in 10 days
(65 Reviews)
5.5
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

$555 USD in 10 days
(24 Reviews)
5.6
pawanjangirjpr

Hi, Thanks for the opportunity. I specialize in website design, mobile app design, landing page design,Info graphic design logo design, Infographic design, Stationary design and Responsive html5/css3. I read through th More

$555 USD in 10 days
(34 Reviews)
5.5
havit

Dear Client, I am interested in your MS-Access User Interface (UI) development project. Please visit my Profile>Portfolio for review of UI design screen shots. I design custom Ribbon Menu for navigation on the appli More

$560 USD in 10 days
(6 Reviews)
5.1
Vasilchenko

Hello I can make user interface using delphi. This will desctop application to connect, manage, input data etc. into/using database. If payment is acceptable for you , please write me a message, I will make presenta More

$350 USD in 10 days
(8 Reviews)
4.7
ganganimaulik

Evidence of work: checkout last review on my profile for access database (it was a contest). I use access 2016 so no conflicts :) Database will be created in new .accdb format. I will use vba (visual basic for a More

$555 USD in 30 days
(7 Reviews)
4.7
prprojectsl

Hi Mike, You are absolutely right on your update #1. I think we should have a discussion on this. I have read and understood your concept regarding this system. I have planned to design using .NET c#. I am comfor More

$515 USD in 13 days
(14 Reviews)
4.9
prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$444 USD in 10 days
(19 Reviews)
4.4
MarcoAGarcia

Hi, I’m a database developer with more than 30 years experience. The past 20 years I have worked (full-time, in-situ) for two international organizations (Inter-American Tropical Tuna Commission, in San Diego, CA, USA, More

$777 USD in 7 days
(1 Review)
4.5
cgullapalli

Hi, I am good at MS access and programming. I would like to discuss the user interface part. Looking forward to work on this project.

$550 USD in 10 days
(17 Reviews)
4.4
nblsoft

Hi sir, I am very interested in your project and offer my services. The project you posted is my type and I do this job for you if you let me. If we create UI in Access then only programming language we can use More

$333 USD in 7 days
(6 Reviews)
4.3
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$250 USD in 4 days
(13 Reviews)
3.6
$555 USD in 10 days
(3 Reviews)
3.3