Research Database Portfolio

The examples below are a sample of my FileMaker database designs across different research contexts. Each database was designed in close collaboration with a research team (whether my own or others) to fit specific recording protocols, field conditions, and objectives. FileMaker's visual interface enables researchers to make routine adjustments without a developer, turning a custom database into a long-term research asset. All databases are relational and can be used on iPads (including offline environments) and any PC or Mac computer.

Example 1: Archaeological Excavation

A comprehensive field database for archaeological excavation. The database links excavation units to context and material records in a structured relational system, with layouts for soil descriptions, stratigraphic matrices, artifact inventories, carbon samples, human remains, photo registries, and daily logs. Filtered record portals help you view relevant data with a single click. Standardized pop-up menus and visual analysis guides reduce data-entry errors across teams with varying experience levels. A completion checklist ensures all required tasks are documented.

Example 2: Sample Registry and Analysis

A laboratory database for systematic sample or material registry and attribute analysis. This example is a ceramic analysis database that can be used on its own or alongside a field database. Broad level analyses can be done for a bag of samples (number of diagnostics, rims, bowls, etc. in each bag), or detailed attribute analysis can be performed on individual samples. Attribute fields cover vessel form, fragment type, decoration, surface treatment, temper, color, and manufacturing method, supported throughout by visual reference guides embedded directly in the form.

Example 3: Comparative Studies & Collections Research

A researcher's tool to systematically collect, consolidate, and compare published or museographical data. Use cases include comparing published data across an archaeological category — such as burials, ceramics, or species — found in the literature or across a region. The example shown here collected data on Spondylous shells from archaeological contexts to discern patterns of ancient use by region, period, culture, and context. A similar database could be used to inventory and research museum collections (provenience information, related examples, etc.) or consolidate, track, and search text in historical documents.

Example 4: Field Survey

A field database for pedestrian surveys. The archaeological example here records surface site and feature locations, surface artifact distributions, architectural observations, and environmental conditions recorded during survey. The database includes fields for photographs and sketch maps linked directly to each record. Standardized value lists ensure consistent terminology across survey crews working simultaneously in different areas.