Database Wiz

Save to Favorites

Thank you for your interest! The Seattle Office of Emergency Management is looking for a volunteer stellar Microsoft Access skills.

The volunteer will develop a database using MS Access, that will assist with documenting and tracking corrective actions and improvement plans as part of the Training & Exercise program. This database may be required to complete complex queries, create forms and reports, and macros for automation of particular elements of the database.

Required technical skills in MS Access:

• Create parameter and action queries.
• Join tables, work with join properties, and create cross-tab queries.
• Organize field placement and use functions to control data entry.
• Use advanced form techniques.
• Create basic Macros to automate forms and data entry.
• Use Macros to provide user interaction and automate tasks.
• Customize the appearance and functionality of reports.
• Use hyperlinks and perform data integration.

Preferred technical skills in MS Access:

• Plan and examine an application, and develop a distributed application design.
• Use one form for two purposes: to add or to edit records.
• Automate a dialog-box form with a Macro group.
• Create a Switchboard or a Splash Screen form.
• Use Visual Basic to create a public function or event procedures, or add general procedures in a form module.
• Secure a database by using user-level security, document it and distribute the secured application.