- Have very good expertise in Database designing and programming in MS Access.
- Design the database to cater to the complete accounting needs including
Journal Entries,
Invoices,
Accounts payable, Receivable
Balance Sheet
P&L
...
Entriy screen for - Customer, Vendor, Contractor employee
- Print Reports based on the pending payments, Invoice, PO, Entries into a report.
- 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
- Data camparision using formulas, lookups and bringing up summaries.,
+...