Custom Access and Excel Applications

Data Conversion Project - Salesforce to Access database

Worked with client to import large Salesforce export into newly designed and implemented Access database for managing client's operations and sales.

Database Engineer
Data Analyst
Database Specialist
Excel VBA
Microsoft Access
Microsoft Excel

Excel VBA programming to prepare data for import into SQL Server

Developed Excel VBA program to automate the import of data from 130 separate Excel files into one Excel file, formatted for import into SQL Server database.

Database Engineer
Data Analyst
Database Specialist
Excel VBA
Microsoft Access
Microsoft Excel

Import Excel data into Access Database

Developed Access VBA program to automate the import of multiple Excel workbooks into an Access database to improve client's operations.

Database Engineer
Data Analyst
Database Specialist
Excel VBA
Microsoft Access
Microsoft Excel

Microsoft Access, Excel, and VBA
Microsoft Access, Excel, and VBA

Developed custom Access and Excel applications for employers and freelance clients in multiple sectors (healthcare, manufacturing, education, retail operations)

Database Engineer
Data Analyst
Database Specialist
Excel VBA
Microsoft Access
Microsoft Excel