- Can build the Access database,
To get the new products added including the SKU, Price, Dimension, Color or any paramters required.
Get the price by SKU id and modify the details.
Based on the present Markup the Selling price can be calcuated and modified based on user.
Calcuations of COS% or any paramter can be done and shown as a report layout.
Printing in PDF format.
- Have done similar Stock, Inventory, Contracts, Sports solutions in MS Access.
- How it works:
Understand the full database needs, and the flow of requirements.
- Design the database (with relationship, Keys, Constraints, Normalisation)
- Design the GUI for each functionality
- Development per the functionality and the reporting needs.
Access Skills:
- 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.
Excel Skills:
- 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
+...