ms-access-ai-skill Agent工作流

Prerequisites

• Microsoft Windows with Microsoft Access installed
• Access Version Control System (VCS) — the add-in that exports/imports Access databases as text
• Claude Code — Anthropic's CLI-based AI coding agent

[!NOTE] OpenCode is also supported as an alternative AI agent. The skill format is compatible with both tools.

Getting Started

1. Install the Skill

Copy the .claude/skills/ms-access-vcs folder into your project:

your-project/
├── .claude/
│   └── skills/
│       └── ms-access-vcs/
│           ├── SKILL.md
│           └── LICENSE
├── YourDatabase.accdb.src/
│   ├── forms/
│   ├── queries/
│   ├── tables/
│   └── ...

Alternatively, install it globally at ~/.claude/skills/ms-access-vcs/ to make it available across all your projects.

4. Build the Database

After Claude Code finishes editing the source files:

1. Open Microsoft Access
2. Use the VCS add-in: Version Control → Build From Source
3. Navigate to your .accdb.src/ folder
4. The add-in rebuilds the complete database

Example

The included CustomerOrders.accdb.src/ directory is a complete working example generated from this prompt:

<details> <summary>View the full prompt</summary>

Let's use the ms-access-vcs skill to create a new microsoft access database to collect
customer details, with fields like name, address, phone number etc. and also create orders,
with parent fields like order number, order date, and child fields like item description,
unit price net, quantity, sub total net.

For the database we're going to need a startup screen with 3 buttons, customers, orders and
exit, that opens automatically on startup.

For customers we're going to need a list view by default with open, add and close buttons on
the bottom. Open and add will take us to a data entry/edit screen with buttons Save and Close
or Discard and Close.

For orders we're going to need a similar setup, list view by default showing parent fields,
with add, open and close buttons on the bottom. Open and add will take us to a data entry/edit
screen with buttons Save and Close or Discard and Close. The add/edit screen should show parent
order fields at the top and have a linked master-child subform for the order items below.

Let's also add a Preview Order button to the add/edit order screen that opens an order report
showing the customer details, order details and order items for the active order. We'll also
need to add a total net to the bottom summing the order item sub total net records. Then include
a line below for 10% GST, and a grand total inc. gst.

</details>

This single prompt generated 3 tables, 4 queries, 6 forms, 1 report, a VBA navigation module, and all supporting configuration — a fully functional order management application.