Microsoft Access
Databases: tables, queries, forms, reports, SQL, macros.
Before starting, we run a 1-minute tech check — microphone, ambient noise, connection. If your setup isn't good enough, the test is fully refunded.
Databases: tables, queries, forms, reports, SQL, macros.
Before starting, we run a 1-minute tech check — microphone, ambient noise, connection. If your setup isn't good enough, the test is fully refunded.
Prove your Microsoft Access skills in 15 minutes: relational tables, SQL queries, forms, reports, and VBA — not just a checkbox on your resume.
The Plume Microsoft Access badge measures your real ability to design and operate a relational database in Access. In a 15-minute AI-conducted oral exam, you're questioned on table modeling, relationships and referential integrity, SELECT/UPDATE/DELETE and action queries, bound forms and subforms, parameterized reports, and automation through macros and Access VBA. The full session is transcribed and scored by Claude Opus, which produces a 0-to-100 score and a certified proficiency level: Novice, Proficient, Advanced, or Expert.
A line that says "Microsoft Access" on your LinkedIn profile tells a recruiter nothing about whether you can write a TRANSFORM query or architect a front-end/back-end split database. The Plume badge changes that. The AI examiner doesn't run you through a multiple-choice quiz — it adapts its difficulty in real time, follows up on your answers, and measures the precision of your technical reasoning, not just whether you know the right buzzwords. Anyone viewing your badge gets a detailed breakdown of what you actually know how to do in Access and where your gaps are.
This badge is built for administrative assistants, operations analysts, VBA developers, logistics managers, and anyone who works with Access daily to manage structured data. Whether you want to validate your skills before a contract, back up a career change into data roles, or simply stand out among candidates who have never opened the Relationships window, this badge gives you a concrete and verifiable edge.
Here are the concrete dimensions the AI examines during the 15-minute oral.
Design tables with appropriate field types (Short Text, Number, Date/Time, Memo, OLE Object), define primary and foreign keys, and set up relationships with referential integrity, cascading updates, and cascading deletes.
Write and optimize SELECT queries with JOIN, WHERE, GROUP BY, HAVING, and subqueries. Build action queries (Update, Append, Delete, Make-Table) and crosstab queries using the TRANSFORM / PIVOT syntax native to Access SQL.
Build bound forms tied to tables or queries, embed continuous-view subforms, work with controls (combo boxes, list boxes, command buttons, checkboxes), and use event properties to trigger macros or VBA procedures on user interaction.
Create grouped reports with totals, subtotals, and page breaks. Work with Group Header/Footer sections, conditional formatting expressions, and parameter queries to filter printed or PDF-exported data dynamically at runtime.
Build Access macros (OpenForm, RunQuery, MessageBox, CloseWindow, SetValue) and conditional macros with If/Else blocks. Know when a macro is the right tool versus a VBA module, and how to wire them together in a complete Access application.
Write event procedures in VBA to loop through DAO or ADO Recordsets, control form behavior programmatically, handle errors with On Error GoTo, and automate imports and exports to Excel spreadsheets or CSV files.
Apply field-level and table-level validation rules, set default values, use input masks, and understand the front-end/back-end split architecture that makes multi-user Access databases stable and maintainable over time.
Diagnose slow queries with the Access Performance Analyzer, index tables strategically, understand the volumetric limits of .accdb files, and know when to link Access to SQL Server tables via ODBC or migrate the back-end entirely.
Final scoring is performed by Claude (Anthropic), which reads back the full transcript and applies this weighted criteria grid.
Ability to write complex queries — multi-table JOINs, subqueries, action queries, and TRANSFORM/PIVOT crosstabs — and explain the execution logic behind them. This is the core of daily Access work and the most reliable differentiator between skill levels.
Quality of the relational design: normalization (1NF, 2NF, 3NF), data type choices, relationship definitions, and referential integrity with cascading rules. A poorly modeled schema makes every Access application brittle, no matter how good the queries are.
Command of bound forms, subforms, advanced controls, and grouped parameterized reports. Includes the ability to explain event properties and to build an interface that a non-developer can actually use without breaking things.
Skill in designing Access macros and VBA modules to automate repetitive tasks, handle errors gracefully, and manipulate Recordsets. Assessed on code clarity, correct use of DAO vs ADO, and practical judgment about when to automate.
Knowledge of front-end/back-end splitting, multi-user strategies, database compaction and repair, understanding of Access's size and concurrency limits, and awareness of when to escalate to SQL Server or transition reporting to Power BI.
A Plume session takes about 20 minutes, from tech check to badge delivery.
The AI confirms your microphone works, that you can hear it clearly, and that you're in a quiet space. No software to install — everything runs in your browser. Have Access open on a second screen or window if you'd like to reference it during the exam.
The AI asks you to describe in a few sentences a real Access project you've worked on: what the database tracked, how many tables it had, who used it, and what your specific role was. Your answer is used to calibrate the difficulty of the technical questions that follow.
The core of the exam. The AI alternates between design questions (how would you model a many-to-many relationship between Orders and Products?), SQL questions (walk me through a query that calculates revenue by customer for the past 12 months), and questions on forms, reports, macros, and VBA. It follows up on every answer to measure the actual depth of your understanding.
You're given a concrete problem to solve on the spot — for example, an Access database that slows down past 40,000 records, or a form that needs to prevent duplicate entries in real time. You propose a solution and justify your technical choices under light pushback from the AI.
As soon as the oral ends, Claude Opus analyzes the full transcript and produces your score (0-100), your certified Access proficiency level, a skill-by-skill breakdown report, and a shareable badge URL. You get everything by email within minutes.
Your score out of 100 translates into a level a recruiter can grasp at a glance.
You can open Access, create a simple single-table database, and enter data using a datasheet or basic form. You may have used the Query Wizard or Form Wizard without understanding relationships between tables or the SQL Access generates behind the scenes. Access feels complex the moment a second table is involved.
You build multi-table databases with defined relationships, write SELECT queries with joins and filter criteria using QBE or SQL view, create functional forms and printable reports, and use macros to automate basic actions. You can work independently on modest-sized Access projects without constant external help.
You're comfortable with action queries, TRANSFORM/PIVOT crosstabs, nested subforms, grouped reports with complex expressions, and you write VBA Access code to automate workflows and loop through DAO Recordsets. You can design and deliver a complete Access application to non-technical end users.
You architect front-end/back-end split databases for multi-user environments, tune query performance with indexes and the Performance Analyzer, link SQL Server tables via ODBC into an Access front-end, automate cross-application workflows with VBA Automation to Excel or Outlook, and know precisely when Access has hit its limits and what to do next. You're the go-to Access person in your team or organization.
No degree or years of experience required to take the badge. Here are the profiles it makes the most sense for.
You maintain inherited Access databases to track contacts, inventory, or orders, and you want proof that you can actually query and maintain them — not just enter data. The badge signals real database competence, not just familiarity.
You use Access to consolidate and pre-process data before pulling it into Excel. This badge validates your ability to write reliable aggregation queries and automate data extraction for recurring financial reports.
You deliver Access applications to clients or internal users. The badge differentiates your profile on freelance platforms and in consulting firms where demand for Access expertise remains high but verified talent is genuinely scarce.
Access is part of your curriculum and you want an objective signal of your skill level for internship or entry-level job applications — something more credible than a grade from your own program.
You run a homegrown Access database to manage SKUs, suppliers, and stock movements. Validating your level helps you justify your technical judgment to management or during ERP evaluation projects.
Where and how your Microsoft Access badge will help you day to day.
A hiring manager asks if you're comfortable with Access. You share your badge URL with your score and the detailed report. They instantly see you can write JOIN queries, build forms, and work in VBA — without having to design their own in-house test.
A client needs someone to take over and improve an existing Access application. Your Advanced or Expert badge gives them the confidence to hand you the project without a long trial period, getting things started faster for both sides.
You come from a non-technical background but taught yourself Access to manage your department's data. The Plume badge turns that informal skill into a certified credential you can highlight when moving into a data analyst or operations analyst role.
You just completed an Access course and want to objectively measure what you actually retained. The badge's detailed report pinpoints exactly which areas need more work — TRANSFORM queries, VBA error handling, front-end/back-end architecture — so you can focus your practice.
An HR or IT manager needs to map the Access proficiency of a team before a Power BI migration project. Each team member takes the Plume badge, and the manager gets comparable, objective scores without having to run internal tests themselves.
As an independent consultant, you include your Access badge link in a proposal for a client who's skeptical of your claimed expertise. A certified score replaces a list of references that the client would have to chase down and verify anyway.
A few minutes to check you have everything you need.
At the end of your session you don't just get a score — here's everything that awaits you.
A precise score and a certified level (Novice, Proficient, Advanced, or Expert) that honestly reflects what you can do in Access: table design, SQL queries, forms, reports, macros, and VBA.
A structured report that breaks your score down by dimension: SQL and queries, database modeling, forms and reports, automation, and best practices. You know exactly where you shine and what to work on next.
Your oral session is securely stored and accessible only to you. Re-listen to your answers to analyze your phrasing, spot hesitations, and prepare more confidently for your next badge or a live technical interview.
A public page showing your score, your level, and the highlights of your report — ready to drop into your LinkedIn profile, portfolio, or resume. Recruiters can verify the badge's authenticity in one click.
Discover related skills you can validate with Plume.
A 15-min oral exam with an AI, a shareable badge for your recruiters.
Choose this badge · €19.99