Francis G. Williams
Email: [Send email using form at bottom]

SKILLS AND EXPERIENCE SUMMARY
More than 10 years of experience in database management for a non-profit
association utilizing an association management system (Pinnacle from gomembers)
with Microsoft Access 2003 as the back end. Very strong skills in development of
MS Access 2003 separate databases with complete menu systems, and in
creation/maintenance of macros, forms, queries, reports; and use of MS Word 2003
and MS Excel 2003 in extracting/outputting data. 

SKILLS AND EXPERIENCE DETAILS
Management and coordination of multiple relational databases, including
maintenance of existing databases and creation of new relational databases to
adapt to changing data needs; database management support to evolving web based
data programs; development of relational database tools such as queries, macros,
and reports, for efficient and timely output of data to all publics served;
coordination of the operation of the association management system (AMS).

Creation of new, and revision to existing, MS Access 2003 tables, queries,
forms, reports, and macros to meet the demands of user generated data output
requests (and then production of the desired data ouput), including updates of
data for membership directory; data and reports for web sites; data, confirmation
letters, reports, and badges for conventions/meetings.

Development in Access of stand-alone auxiliary databases with related tables,
menus, input forms, reports, queries and macros.

Coordination of association management system (AMS) operation with development
of reports, queries and macros for the AMS reports menu; and liaison with the AMS
vendor of software operation problems.

Import/Export and manipulation of internal/external data into and out of
Excel/Access formats; and merging of Excel/Access files with Microsoft Word for
output of letters and labels.

Development of utilities for maintenance of main database, such as automated and
semi-automated changes in certain field content; and automated updates of sets of
data.

EDUCATION
B.A., Trinity College, Hartford, CT