- Can create the database and the application to manage the Event, Food Items, and its ingredients.
- Have expertise in MS Access to design database, create keys, user entry screens and finally get the reports out of the existing data.
- Have done a similar on in Excel for an Event Management Company wherein the services offerered including Services, Food&Beverarage and other items once the event is done, would calculate the total cost to be invoiced including the sales tax percentage.
• 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.
• Please review my portfolio on the recent projects in Excel and MS Access.
• MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation.
Sample complicated projects completed via Freelancer using Macros
- Canada based Heating Design Soln: Have implemented a very complex heating model, selection of wires based on Amp, Volt, Resistance, and the total amps for the rooms not exceeding a certain threshold. If so reiterate the solution with the next available wire model.
-For a Canadian firm Tax firm - based on employee, wage, hours, resideing province based on the reference tables calculate the Provincial and the Fed tax. Each Province having its own reference.