MIS Project with Microsoft Excel and Access

$30-250 USD

Tildelt

Slået op

cirka 9 år siden

$30-250 USD

Betales ved levering

In Attached File Directions: 1. Complete the case that you are trying to solve 2. The starting Excel file that needs to be converted to a database 3. A video explaining how to import data and create a swtichboard, optional - but might help in finishing the case. [login to view URL] - Alternate link 4. A link that might be useful - [login to view URL] 5. A link to how to create the customer form - [login to view URL] 6. For Query 6 - I will accept a list of customers who are late (uniquely identified) I will accept if you can give me a list of customers who are late (uniquely identified). 7. When you get to the Excel portion, I expect you to 'link' access to excel, see [login to view URL] on how to do it. 8. To understand database functions in Excel, see [login to view URL] Note: The case mentions that Mr. Scott charges a deposit. Please use 50% of rental price as the deposit amount. ------------------------- Submission 1. Access database 2. Excel Database 3. A word document containing answers to the following questions. a. A written report discussing any assumptions you have made about the case and the key elements of the case. Additionally, what features did you add to make the database and work funk more functional? User Friendly? (Please note that these assumptions cannot violate any of the requirements specified above and must be approved by Dr. Gupta) b. Screenshots - Please provide a screenshot for each of the elements associated with the rubric. For example- One of the grading criteria is Access: relationships - in this case, you will provide me with a screenshot of the relationship screen in Access. These screenshots are the basis of grading. We only look at access and Excel document to verify non-plagrism and to see if we don't understand something. c. Discuss the key features of your database and workbook. Also, discuss how the database and workbook are beneficial for Ms. Scott. What additional information should be included in the database and workbook to make it more useful?

Excel

Microsoft Access

Projekt-ID: 7473396

Om projektet

11 forslag

Projekt på afstand

Aktiv 9 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

11 freelancere byder i gennemsnit $184 USD på dette job

@Neno585

Hello, I am employed MS Access developer and I can do your project, I went through the requirements and everything is doable to me, even switchboard is not a problem as I have done it before. I would do my best as the reviews are very important to me and I want to make sure that you get the highest possible grade. I would also explain everything I did to you so you can defend your project properly. If you are interested, feel free to contact me. In any case, thank you for the consideration and I wish you best of luck with your project

$155 USD på 4 dage

5,0

(24 anmeldelser)

7,4

@shikhamehta

Hey, I am an Expert in Excel and Access based solutions. I read through the Case study description and can certainly create the required database with all the reports etc. Since this may take 7-10 days to complete, was curious to know when is this due? Do let me know if you would like me to work on this project for you and we may discuss the details and next steps. Thank You for considering my bid. Shikha

$277 USD på 7 dage

4,8

(99 anmeldelser)

6,4

@jawadaman

Hi I am interested in this project. I am an experienced MS-Access, MS-Excel and vba developer. I can do this job for you. If interested in hiring me then please let me know so that we can discuss the scope, timelines and budget accordingly. Thanks. Regards, Jawad

$222 USD på 3 dage

5,0

(83 anmeldelser)

5,7

@mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several case studies and build required database using MS Excel and MS Access and thus can help you in giving appropriate solution. As I can see, you need database with table structure with writing 15 queries as given in pdf file. Along with that spreadsheet which require analysis on data and testing design. Waiting for your response to talk further in detail and start project work. Thanks.

$94 USD på 3 dage

4,7

(150 anmeldelser)

6,2

@bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL, MYSQL,SQL server and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.

$200 USD på 3 dage

4,9

(24 anmeldelser)

5,9

@farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data operations and also other functions like selecting the data criteria for generation of the reports, the user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. I can offer you with a very dynamic access reports, dynamic in terms of their structure i.e. the structure of a single report can change depending on the data to be displayed on it each time for e.g. access reports can be used to generate invoices on them, now as structure of the invoice is dynamic i.e. there may be any number of items billed, so in such scenarios I can offer you reports which can handle this dynamic nature of such data. Criteria for the data to be displayed on the report can be set on user forms and they can be generated on button clicks. I want to send you an access DEMO application to give you an idea of the functionality that I can offer you, if you could reply me on this message I will be able to send you the demo app. Regards.

$74 USD på 3 dage

5,0

(44 anmeldelser)

5,5

@Raafatadly23

Dear sir, Am Raafat Mekhaeil am computer science Graduated 2009 am an ICDL instructor and web developer and designer I would like to be a part of your business all what i need is a good review please not more thank you hope you choose me

$250 USD på 2 dage

0,0

(0 anmeldelser)

0,0

@jrkw

I am pleased to address you . In order to participate in the selection of professionals in your prestigious institution. As BSc in Information Systems and Management with experience in more than fifteen years in software implementation projects , also with extensive experience in the regulatory financial sector ( Banking , Insurance , Finance Companies , OPDF , Cooperatives, Brokerage ) of the Republic of Honduras . As a person with a high level of commitment that has excellent social , interpersonal and professional behavior . Among the ethical principles that accompany my actions is honesty and respect in all circumstances. My management in the area of Research and Development , under the Technology Management and Communications Division CNBS systems, financial indicators , early warning, statistical bulletins online , such schemes are implemented Business Intelligence . As the second step of the INTERCONEXION FINANCIAL , which is developing tools that exploit the information received from supervised financial system . Getting extensive knowledge in CENTRAL RISK , MONEY LAUNDERING , as in developing FINANCIAL INDICATORS aimed at REGULATORY FRAMEWORK , give the Republic of Honduras .

$250 USD på 5 dage

0,0

(0 anmeldelser)

0,0

@agounder

A proposal has not yet been provided

$222 USD på 4 dage

0,0

(0 anmeldelser)

0,0

@vimalbvyas

I want to work on this project, I will do my best to complete this in time. Please give me a chanse........................

$111 USD på 3 dage

0,0

(0 anmeldelser)

0,0

@albahi

1- I have a good experience of developing database and applications using access for private and government clients 2- in my attached portfolio there is some success project i did it

$166 USD på 5 dage