Access Database
- or -
Post a project like this1627
$200
- Posted:
- Proposals: 12
- Remote
- #2588521
- Completed
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Excel Expert | Data Analysis | Business Plan | Research | Presentations Specialist
Jaipur
32817404815195745270269548700723760119279813899761750041252655829928943206833
Description
Experience Level: Intermediate
1. Build database in Access
2. Implement macros that will take the provided excel spreadsheet and apply formatting to support a seamless import into the Access database. (I will send 4-5 versions of dummy data)
3. Implement queries that will take descriptive statistics from SQL from certain columns: Mean, Median, Mode, Variance, Standard Deviation
4. Implement macros that will take the data to provide reports with a simple click of a button
5. Implement a VBA coded procedure that allows the user to compare annual data
These numbers are the different parts. I would need the access database file after each part is done. You can move the different parts around if that works better for you.
2. Implement macros that will take the provided excel spreadsheet and apply formatting to support a seamless import into the Access database. (I will send 4-5 versions of dummy data)
3. Implement queries that will take descriptive statistics from SQL from certain columns: Mean, Median, Mode, Variance, Standard Deviation
4. Implement macros that will take the data to provide reports with a simple click of a button
5. Implement a VBA coded procedure that allows the user to compare annual data
These numbers are the different parts. I would need the access database file after each part is done. You can move the different parts around if that works better for you.
Salman S.
100% (40)Projects Completed
17
Freelancers worked with
18
Projects awarded
38%
Last project
15 Jan 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies