AccessDatabaseSpecialist.com
A service of PCC
P. O. Box 830683
Stone Mountain, GA 30083
PHONE: (770) 498-7333 [voice mail]
|
Relevant Project Summaries
Project Summary 1 - Financial Services Firm
Project Goal:
Develop an Access database to import information from Excel, translate it into meaningful information, and generate reports in both Excel and Access. The users wanted to click on a button in Access and not only export data to Excel, but also apply the appropriate formats to the Excel report (column widths, word wrap, fonts, etcetera).
Skills Used:
SQL, VBA, Excel Automation, Relational database design, Importing and extracting data, Comparing both data sources to check for integrity, Form and report coding.
Project Summary 2 - Mortgage Brokerage
Project Goal:
Allow users to be able to enter information from various sources (pre qualification form, HUD-1 settlement statement, etc.) and use the information to prepare reports required by the Georgia Department of Banking and Finance.
Skills Used:
Relational database design, SQL, VBA, Excel Automation, Outlook Automation, Form and report coding.
Project Summary 3 - Real Estate
Project Goal:
Create networking and client follow up database for top producing real estate broker.
This database became the cornerstone in her customer-for-life program.
Skills used:
Relational database design, SQL, Form and report coding.
Project Summary 4 - Industry Association
Project Goal:
Modify national association's database.
Skills used:
Relational database design, SQL, VBA, Excel Automation, Outlook Automation, Word Automation, Form and report coding.
|
|
|
