Find Jobs
Hire Freelancers

Microsoft Access Project

$8-15 USD / hour

Zaprt
Objavljeno pred več kot 5 leti

$8-15 USD / hour

Using Microsoft Access, create the following traffic ticket database with its associated tables, fields (including appropriate data type), primary keys and foreign keys. A traffic ticket is a notice issued by a law enforcement official to a motorist accusing violation of traffic laws. Note: make sure to create the relationships between your tables before adding the records in your tables. (MS ACCESS) The motorist information includes driver license number, name, zipcode, state. The motorist is uniquely identified by his/her license number. Create at least 5 unique motorist records. The traffic offense type includes the offense description (i.e. red light) and its designed fine amount (i.e. $158). Each traffic offense type is uniquely identified by its offense description. Create at least 3 unique traffic offense type records. The law enforcement official information includes badge number, name, and year in service (i.e. 2). The law enforcement is uniquely identified by his/her badge number. Create at least 3 unique law enforcement official records. The traffic ticket includes the ticket number, date issued, the motorist’s driver license number, the traffic offense type’s description, and the law enforcement official’s badge number. The traffic ticket is uniquely identified by its ticket number. Create at least 8 traffic ticket records. One motorist may have more than one traffic ticket. A traffic ticket is issued by a specific law enforcement official to one and only motorist. A law enforcement official can issue many traffic tickets and a motorist can received many traffic tickets. Create one query named "Invoices" using "Query Design" that outputs the total (aka SUM function) amount of the traffic tickets due and total number (aka COUNT function) of traffic tickets received by each individual motorist's license number. The outputs should also display the name of the motorists. * Do not use "large number" as a data type for any of your fields *
ID projekta: 17313006

Več o projektu

29 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
29 freelancerjev je oddalo ponudbo s povprečno vrednostjo $11 USD/uro za to delo
Avatar uporabnika
Hi there..... Warm Greetings We came along with your request for Microsoft Access and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Administration, Database Programming, Excel, Microsoft Access, SQL We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$10 USD v 40 dneh
5,0 (287 ocen)
7,7
7,7
Avatar uporabnika
Plz respond to this message so I can send attachment files....we created 1)Microsoft Access Project =>OK What version of MS Access you want to use ? Access 2013/2016 ? We can use MS Access as backend or SQL Server Express as backend. Let me know your preference. If it is desktop database with 1-2 users we can use MS Access as backend. 2)Using Microsoft Access, create the following traffic ticket database with its associated tables, fields (including appropriate data type), primary keys and foreign keys. A traffic ticket is a notice issued by a law enforcement official to a motorist accusing violation of traffic laws. =>Ok Note: make sure to create the relationships between your tables before adding the records in your tables. (MS ACCESS) Above relationship diagram shows relationship between tables of TrafficTicketDBAccess. There will be one or more tickets in tblTrafficTicket for each motorist in tblMotorist There will be one law enforcement official can issue many traffic tickets There will be one Offensedescription for one or many traffic ticket   4)After finalizing commencement we will go forward for inserting records to a table and quering to database 5) The motorist information includes driver license number, name, zipcode, state. The motorist is uniquely identified by his/her license number. Create at least 5 unique motorist records.  =>Ok ,I have created table tblMotorist to database. for adding records to table refer point no.5
$8 USD v 40 dneh
5,0 (285 ocen)
7,6
7,6
Avatar uporabnika
Hello! My name is Paris Pallas and just had the chance to read your project's description. I was very excited that you mention Microsoft Access because this is my favorite field and database projects are among the tasks I work with regularly and know exactly how to handle them. I'm a very experienced and skilled MS Access developer as you can easily check for yourself at my portfolio. You mention that you need somebody to develop a database that will track traffic tickets. Your description is very thorough and detailed and I don't need more details for the moment. I can start working immediately and if I need anything clarified I can always call you. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$15 USD v 40 dneh
4,9 (210 ocen)
7,1
7,1
Avatar uporabnika
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 reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$8 USD v 6 dneh
4,9 (120 ocen)
6,2
6,2
Avatar uporabnika
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. I'll do your current project via Ms Access very professionally and on time. Thank you for your consideration. Zura
$12 USD v 40 dneh
4,5 (50 ocen)
6,2
6,2
Avatar uporabnika
INTRODUCTION I have 4+ years’ experience with database architecture and strategy; exhibiting excellent technical skills, and a keen sense of innovation. I am skilled in microsoft access vba programming and development with experience in designing, developing and understanding analytics. I am also skilled in database administration, building reports and customized dashboards and the ability to turn ideas into functional solutions. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/database-administration/customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/convert-data-word-table-access/ • https://www.freelancer.com/jobs/project-15444898/ • https://www.freelancer.com/projects/sql/human-resources-database-creation/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$10 USD v 40 dneh
4,8 (22 ocen)
5,9
5,9
Avatar uporabnika
- Can get the Traffic Ticket Database designed - I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings. - Worked on projects Database designing from business proposal, ER diagram, creating Entity relationship, normalization, constraints, indexes. - MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation. Based on the table/Entities: Motorist Information Traffic Offense information Law Enforcement Official information Traffic Ticket Based on the one-to-one or one to many relationships as described for Law enforcement officer and tickets issued to a person Ticekts issued to multiple person, the relationship can be designed. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$10 USD v 40 dneh
4,6 (50 ocen)
6,1
6,1
Avatar uporabnika
Greetings for the Day!!! I have 8 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 have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details . Thank you :)
$16 USD v 40 dneh
5,0 (51 ocen)
4,7
4,7
Avatar uporabnika
Hi Thanks for your posting. I have read your post very carefully. As I am a Database designer, if you hire me, I can work perfectly. Also I will give you ERD for this project before starting this project and if you are ok for it, then I will start project. Don't worry about the quality of the project. I guarantee the best quality of my working. I wanna discuss more in detail Best regards. Chengzhe.
$22 USD v 40 dneh
5,0 (2 ocen)
3,8
3,8
Avatar uporabnika
Dear Sir, Over all 15 years of IT industry experience. Development of Web Application and Windows based Application using Microsoft Technologies. My experience on MS Access and VBA will definitely resolve your issues. My expertise on following tools are hereunder: - VBA and Macros using Excel and Access - VB.Net, VB6.0 - Report designs with Crystal Reports, data report and excel - Back end SQL Server or MS Access EDUCATION: MCA (Master in Computer Application). Looking forward to work with you. Thanks and Regards
$8 USD v 40 dneh
4,8 (13 ocen)
3,7
3,7
Avatar uporabnika
Hi, I am interested in this project. I have considerable expertise in the design and development of MS Access Databases. I would be happy to discuss about your specific requirements. Regards
$9 USD v 40 dneh
5,0 (5 ocen)
3,2
3,2
Avatar uporabnika
Dear Sir/Madam: I will mkae your Access ystems in 15 hr fixed, delivery in 3 to 5 days. Full services: programming, PM, technical translation/writing. Expertise since 90s. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. Kind regards.
$8 USD v 20 dneh
5,0 (2 ocen)
2,2
2,2
Avatar uporabnika
I would like to take part in this bid. My work strategy is to give regular status update and intermediate version whenever required. Let me know if you are OK with my bid.
$8 USD v 18 dneh
4,7 (9 ocen)
1,9
1,9
Avatar uporabnika
Good evening, I have been working with MS Access for many years and I have created many DBs for my companies and for various clients. I like to solve the needs of the employer and I am very flexible in the changes to be made. The work you require is simple enough to accomplish. Do you need it in a short time? I prefer to work calmly, to put the maximum attention to all the details. See you soon
$13 USD v 40 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hello, based on your project, I am capable of doing a good job for you since I did my Final Computer project back in 2015 and got an A- If you hire me I guaranteed you perfect results and delivery will be in time.
$8 USD v 50 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Ing. In computer systems, person with a proactive attitude, always with desire to overcome. I can help you in your application, if taken into account I hope you contact me. I use desktop platforms such as Visual Studio (C #), Java, Micrsoft Access, SQL, as indicated in their requirements, I can execute it. I await your contact. Greetings.
$8 USD v 40 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I am ready to finish your work alone within the time-frame you specify and be sure you will be satisfied as I am look for perfection in whatever I do, whether the job was for myself or others... Relevant Skills and Experience I have a good experience in working with data in excel and access, and I am now taking data-analysis courses which will be a great help in the future..
$16 USD v 25 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
i Already design the database like your requirement, completed with primary key, freign key and all the table and query
$8 USD v 40 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
murfreesboro, United States
4,9
13
Plačilna metoda je verificirana
Član(ica) od feb. 5, 2018

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.