01
Strategy Consulting
Strategy consulting for small businesses that want to make sense of their data.
Structured Databases
Excel to Access
Scalable to Oracle Apex
Tutorial Included
Relational Schema Design
Query-Ready Data
Structured Databases
Excel to Access
Scalable to Oracle Apex
Tutorial Included
Relational Schema Design
Query-Ready Data
About
About Duncan Tech
At Duncan Tech, I transform messy Excel spreadsheets into clean, organized, and efficient databases built in Microsoft Access. My goal is to help businesses replace scattered data with structured systems that are easier to manage, search, and maintain. As your business grows and your data needs become more complex, I can also help transition your database to Oracle Apex, providing a scalable solution for larger, enterprise-level workloads.
Every project is handled personally from start to finish. I intentionally work with only two clients at a time, allowing me to give each database the attention it deserves—from planning and data organization to development, testing, and refinement. Throughout the process, you'll receive regular progress updates, and once your database is complete, I'll provide both the finished solution and a practical tutorial so you can use it with confidence.
- Step 1
Excel
Messy spreadsheets, mixed formats, duplicated rows.
- Step 2
Microsoft Access
Normalized tables, keys, queries, forms, reports.
- Step 3
Oracle Apex
Scalable enterprise database when you're ready.
Services
End-to-end database services
From the first conversation to the delivered database, every step is handled personally.
02
Information Gathering
Gather information of a person, place, and company — organized into structured records.
03
Database Development
A tailored Microsoft Access database, built and delivered in about two weeks.
04
Progress Updates
Regular email updates on the status of your database throughout the build.
05
Delivery & Testing
Receive the database and a written tutorial, then share feedback after you test it.
Portfolio
Examples of database development expertise
Using regular database skills on Microsoft Access and SQL on Oracle Apex — delivered as polished tables, forms, reports, and dashboards.
Relational Schema
Normalized tables & keys
Reports Dashboard
KPIs & trend visualizations
Data Entry Form
Guided input & validation
Structured Records
Clean, queryable data
Process
A clear path from chaos to clarity
Eight predictable steps — you always know what's happening next.
- 1
Receive Spreadsheet
You email your messy Excel file.
- 2
Analyze Data
I audit fields, types, and duplicates.
- 3
Design Structure
Entities, keys, and relationships mapped.
- 4
Build in Access
Tables, queries, forms, and reports.
- 5
Progress Updates
Status emails throughout the build.
- 6
Deliver Database
You receive the finished .accdb file.
- 7
Include Tutorial
A written guide for daily use.
- 8
Client Feedback
You test, share notes, we refine.
Limited Client Availability
I only take two clients at a time.
Schedule an appointment 3 to 4 weeks in advance to secure your spot. Boutique attention, no shortcuts.
Future Vision
Built Today. Ready for Tomorrow.
If successful, then transition to Oracle Apex to manage big data. Your database starts nimble on Access and grows into an enterprise-grade platform when you're ready — without starting over.
- Start lean with Microsoft Access
- Migrate cleanly when volume grows
- Scale to Oracle Apex for big data
Independent · Owner-operated
Organize your data. Scale with confidence.
A short conversation is enough to map your spreadsheets and outline the Microsoft Access database that will replace them.
Contact
Let's Organize Your Data
Send your messy Excel spreadsheets for evaluation. I'll review the data, sketch a database structure, and reply with next steps.
- dnickolas@ymail.com
- Response window
- Within 2 business days. Only two clients at a time — reserve 3–4 weeks ahead.