Microsoft Access Test
Tests Microsoft Access — designing tables, field types, keys and relationships with referential integrity, building select, parameter, totals, crosstab and action queries, creating forms and reports, and maintaining, splitting and automating Access databases with macros and VBA. Pass to earn Microsoft Access SOA-MIAC.
- Intermediate difficulty.Assumes hands-on experience in the role.
- 20 scenario questions
- 20 minutes, timed
- 70% to pass · 90% for distinction
- Free no sign-up needed
- LinkedIn-ready · add it to your profile in one clickSee how ↓
What is the Microsoft Access Test?
The Microsoft Access Test is a free intermediate-level, 20-minute skill test from Science of Apps. It tests Microsoft Access — designing tables, field types, keys and relationships with referential integrity, building select, parameter, totals, crosstab and action queries, creating forms and reports, and maintaining, splitting and automating Access databases with macros and VBA. Score 70% or more on its 20 questions to earn a verifiable Microsoft Access certificate (SOA-MIAC). Every question is based on published standards and research — including Microsoft Access help and learning (Microsoft) — and each answer is explained with its source.
Built for your job title
Database administrator, Data analyst, Office administrator, Business analyst and Operations coordinator — and anyone who wants quick, verifiable proof of Microsoft Access skills for a CV or LinkedIn.
- Database administrator
- Data analyst
- Office administrator
- Business analyst
- Operations coordinator
What the test covers
Four skill areas with 5 questions each, drawn from a bank of 10 per area, so a retake brings questions you haven't seen.
- 01
Tables, Fields and Relationships
25%- Table design
- Field properties
- Keys and relationships
- 02
Queries
25%- Select and parameter queries
- Totals and crosstab
- Action queries
- 03
Forms and Reports
25%- Form design
- Subforms
- Report design
- 04
Maintenance, Automation and Integration
25%- Database maintenance
- Macros and VBA
- Multi-user and data exchange
Independent skills test. Science of Apps is not affiliated with, endorsed by or sponsored by Microsoft. Product and exam names are trademarks of their owners. Passing earns a Science of Apps certificate, not a certification issued by Microsoft.
Based on published standards
The questions are original scenarios, and each one names the public standard, official guide or research it draws on — shown under the question while you answer, and linked in your review. These are the sources behind this test:
- Microsoft Access help and learningMicrosoft40 questions
Try a sample question
Enforcing referential integrity on a relationship in Access
- automatically deletes every duplicate record found in both of the tables
- makes all the fields in both tables required before saving any record
- allows any value in the foreign key field, even ones that don't exist
- prevents records in the related table that refer to a non-existent primary record
Show the answer
D. prevents records in the related table that refer to a non-existent primary record — Keeps relationships valid. The real test has 20 questions like this.
How the test works
20 minutes, 20 questions
One question per screen, with a progress bar and a countdown. Your progress is saved on this device if you need to pause.
Graded on our server
Answers reach the page only after you submit, so the certificate can only be earned by passing.
Every answer explained
Pass or not, you see every question with the right answer, why, and the source behind it. Pass mark 70%, distinction 90%.
Your certificate
Founder-signed, with a QR code and credential ID. Download PDF or PNG, add to LinkedIn, and it's emailed to you.
What you earn

Pass, then add it to LinkedIn in one click
No typing. The Add to LinkedIn button opens your profile’s Licenses & certifications form already filled in: the certificate name, Science of Apps as the issuer, the issue date, your credential ID and a link recruiters can use to verify it.
- 1Take the 20-minute test
- 2Score 70% or more
- 3Click Add to LinkedIn

Microsoft Access
Science of Apps
Show credential ↗Try another skill test
- 15 minSOA-MSW
Microsoft Word Skills Certification
Tests practical Microsoft Word skills for work — document formatting and styles, long documents and references, and collaboration, review and accessibility — as used in offices, schools and admin roles.
Difficulty: IntermediateTake the 15-minute test → - 15 minSOA-MSPP
Microsoft PowerPoint Skills Certification
Tests practical Microsoft PowerPoint skills — slide design with masters and layouts, content, media and animation, and delivering, sharing and making presentations accessible.
Difficulty: IntermediateTake the 15-minute test → - 10 minSOA-MSO
Microsoft Outlook Skills Certification
Tests practical Microsoft Outlook skills — managing email efficiently with folders, rules and search, and scheduling meetings and sharing calendars — for office and admin work.
Difficulty: BeginnerTake the 10-minute test →
Frequently asked questions
What is the Microsoft Access Test?
The Microsoft Access Test is a free intermediate-level, 20-minute skill test from Science of Apps. It tests Microsoft Access — designing tables, field types, keys and relationships with referential integrity, building select, parameter, totals, crosstab and action queries, creating forms and reports, and maintaining, splitting and automating Access databases with macros and VBA. Score 70% or more on its 20 questions to earn a verifiable Microsoft Access certificate (SOA-MIAC). Every question is based on published standards and research — including Microsoft Access help and learning (Microsoft) — and each answer is explained with its source.
How do I take the Microsoft Access Test for free?
Read the four skill areas on this page, then take the 20-minute test online — no fee, course or sign-up. You see every answer explained when you finish. Score 70% or more and you get a Microsoft Access certificate straight away, on screen, as a PDF and by email, with a credential ID anyone can verify.
Are the Microsoft Access Test questions based on real standards?
Yes. The questions are original scenarios written by Science of Apps, and each one is based on a public source you can read: Microsoft Access help and learning (Microsoft). The source is shown under each question and linked in the answer review. Science of Apps doesn't copy questions from other tests.
What does the Microsoft Access Test cover?
Four skill areas with five questions each, drawn from a bank of 10 per area so a retake brings new questions: Tables, Fields and Relationships (Table design, Field properties and Keys and relationships); Queries (Select and parameter queries, Totals and crosstab and Action queries); Forms and Reports (Form design, Subforms and Report design); Maintenance, Automation and Integration (Database maintenance, Macros and VBA and Multi-user and data exchange). Every question is an original scenario based on a published standard, official documentation or research, named under the question.
Who should take the Microsoft Access Test?
Database administrator, Data analyst, Office administrator, Business analyst and Operations coordinator. It suits anyone who wants a quick, verifiable way to show Microsoft Access skills, from students and career switchers to experienced professionals.
Can I use this for MS Access quiz, Access database skills test or Microsoft Access interview questions?
Yes. The Microsoft Access Test is free and covers all of these: 20 scenario questions in 20 minutes, each answer explained with the source it comes from, so it works as interview and exam practice. It isn't a full course, so use the areas you miss as your study list. Scoring 70% or more earns a verifiable certificate.
Can I take the Microsoft Access Test from any country?
Yes. The test is online, in English and free everywhere — people take it from India, the US, the UK, Europe, Africa, Latin America and Asia-Pacific. Your certificate is dated with your own local date and can be verified from anywhere at scienceofapps.com/certification/verify/.
How long is the Microsoft Access Test?
20 questions — 5 from each of 4 skill areas — with a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.
How hard is the Microsoft Access Test?
We rate it Intermediate: assumes hands-on experience in the role. It has 20 scenario questions — 5 from each of 4 skill areas — and a 20-minute limit. You need 70% (14 of 20) to pass and 90% for distinction.
How much do Science of Apps certifications cost?
Nothing. There is no fee to take a test, to receive the certificate, to have it emailed or to verify it, and no sign-up.
How are the tests graded?
On our server, not in your browser. The answers never reach the page until you submit, so a certificate can only be earned by passing. Each certificate gets a unique credential ID stored by Science of Apps.
What happens if I don't pass?
You see your score for each area and every question with the correct answer and why, with the published source behind it. You can retake after 30 minutes, and the retake draws questions you haven't seen yet.
Do the certificates expire?
No. Every certificate is dated, so it always shows when you passed. Retake a test any time for a newer date or a higher score.
Can I add the certificate to LinkedIn?
Yes. After you pass, Add to LinkedIn opens the Licenses & certifications form with the certificate name, Science of Apps as the issuer, the issue date, your credential ID and the verification link filled in. You can also download it as a PDF or PNG, and it's emailed to you as a PDF.
How can an employer verify my certificate?
Every certificate has a credential ID and a QR code. Scanning it, or entering the ID at scienceofapps.com/certification/verify/, shows the holder's name, the certification, the score and the issue date from our records.
Are these accredited qualifications?
No. They are Science of Apps' own assessments of applied skill. They aren't issued by a university or standards body, and they work best alongside a portfolio that shows the skills in real work.
741 more certifications to collect
Office & Productivity Software
- Microsoft Word Skills Certification15 min · Intermediate
- Microsoft PowerPoint Skills Certification15 min · Intermediate
- Microsoft Outlook Skills Certification10 min · Beginner
- Microsoft 365 Skills Certification15 min · Intermediate
- Microsoft Teams Skills Certification10 min · Beginner
- SharePoint Skills Certification15 min · Intermediate
- Power Automate Certification Practice15 min · Intermediate
- Power Apps Certification Practice15 min · Intermediate
- Google Workspace Skills Certification15 min · Intermediate
- Google Slides Skills Certification10 min · Beginner
- Google Docs Skills Certification10 min · Beginner
- Google Apps Script Certification15 min · Intermediate
- Power Platform Fundamentals PL-900 Practice Test15 min · Intermediate
- Notion Test15 min · Beginner
- Zapier Automation Test15 min · Beginner
- Airtable Test15 min · Beginner
- HubSpot Certification Test20 min · Intermediate
- SAP Fundamentals Test15 min · Beginner
- Microsoft Access TestYou're here
- Microsoft 365 Copilot Certification15 min · Beginner
- Virtual Assistant Test15 min · Beginner
- Administrative Assistant Test15 min · Beginner
Foundation
AI & Generative AI
- AI UX Design Certification30 min · Advanced
- Prompt Engineering Certification30 min · Intermediate
- AI Product Manager Certification30 min · Advanced
Software Engineering & Web Development
- HTML and CSS Fundamentals Certification10 min · Beginner
- JavaScript Fundamentals Certification10 min · Beginner
- TypeScript Fundamentals Certification15 min · Intermediate
Data Analytics & Business Intelligence
- Product Analytics Certification30 min · Advanced
- Data Literacy Certification10 min · Beginner
- Microsoft Excel Fundamentals Certification10 min · Beginner
Digital Marketing, SEO, AEO & Growth
- Conversion Rate Optimization (CRO) Certification30 min · Advanced
- App Store Optimization (ASO) Certification30 min · Intermediate
- Growth Marketing Certification30 min · Intermediate
UX/UI, Design, Research & Creative
- UX Design Certification30 min · Intermediate
- UI Design Certification30 min · Intermediate
- Product Design Certification30 min · Intermediate
Product, Project Management & Business Analysis
- Product Manager Certification30 min · Intermediate
- Design Leadership Certification30 min · Advanced
- Agile Product Owner Certification30 min · Intermediate
Cybersecurity, IT, Cloud & DevOps
- Cybersecurity Fundamentals Certification10 min · Beginner
- Security Awareness and Phishing Detection Certification10 min · Beginner
- Network Security Fundamentals Certification15 min · Intermediate
Sales, Customer Success & Support
- Sales Fundamentals Certification10 min · Beginner
- Consultative Selling Certification15 min · Intermediate
- B2B Sales Development Representative Certification10 min · Beginner
Human Resources & People Management
- Human Resources Fundamentals Certification10 min · Beginner
- Talent Acquisition and Recruitment Certification10 min · Beginner
- Technical Recruitment Certification15 min · Intermediate
Finance, Accounting, Operations & Entrepreneurship
- Financial Literacy for Professionals Certification10 min · Beginner
- Accounting Fundamentals Certification10 min · Beginner
- Bookkeeping Fundamentals Certification10 min · Beginner
Communication, Leadership & Transferable Skills
- Critical Thinking Test10 min · Beginner
- Attention to Detail Test10 min · Beginner
- Cognitive Bias Test10 min · Beginner
Languages
- English Level Test30 min · Beginner
- American Sign Language (ASL) Foundations Test25 min · Intermediate
- App & Software Localization Test25 min · Intermediate
Healthcare, Education, Legal Operations & Sustainability
- Healthcare Administration Fundamentals Certification10 min · Beginner
- Medical Office Administration Certification10 min · Beginner
- Healthcare Data Privacy Awareness Certification10 min · Beginner
Test Prep, Academics & Aptitude
- SAT Math Practice Test20 min · Advanced
- SAT Reading and Writing Practice Test20 min · Advanced
- ACT Practice Test (English, Math, Reading & Science)20 min · Advanced
Language Exam Prep
- IELTS Academic Practice Test with Band Score20 min · Advanced
- IELTS General Training Practice Test20 min · Advanced
- TOEFL iBT Practice Test20 min · Advanced
Engineering, Architecture, Construction & Safety
- Mechanical Engineering Practice Test (FE-Style)20 min · Advanced
- Electrical Engineering Practice Test (FE-Style)20 min · Advanced
- Civil Engineering Practice Test (FE-Style)20 min · Advanced
Hospitality, Travel & Retail
- Hospitality Management Certification10 min · Beginner
- Food Safety Certification10 min · Beginner
- Hotel Revenue Management Certification15 min · Intermediate
Read before you test
- Career guidesGoogle Analytics 4 skills employers want in 2027: events and conversions, reports and explorations, consent, attribution and trustworthy trackingGA4 skills employers want in 2027: events and key events, tracking plans, reports and explorations, consent mode, attribution and data quality checks.
- Career guidesExcel skills for jobs in 2027: what employers actually test, the questions they ask and how to prove itExcel skills for jobs in 2027: which roles need them, how employers test Excel in interviews, real test questions with answers, common traps and a plan.
- Tech stackHow to choose a database for your app: a six-question decision guide with recommendationsHow to choose a database for your app: six questions on data shape, queries, consistency, scale, team and compliance — with clear picks for common app types.
- Career guidesHow to get a Power BI developer job in 2027: data models, DAX and the report that wins the interviewHow to get a Power BI developer job in 2027: the data modelling and DAX skills employers test, PL-300, the interview loop, India pay and a 12-week plan.
- Career guidesKeyword research and search intent skills employers want in 2027: finding demand, judging intent and value, and choosing what to target when AI answers more queriesKeyword research skills employers want in 2027: demand, search intent, difficulty, business value, clustering and choosing targets in AI-era search.
- Career guidesHow to get a BI analyst job in 2027: warehouses, KPIs and the trust that makes reports get usedHow to get a BI analyst job in 2027: the warehouse, modelling and KPI skills employers test, the interview loop, pay in India and a 12-week plan.
Get the ideas, not the noise.
Sign up with Google and we’ll send you short UX psychology tips by email — why people tap, stall and leave, and what to do about it. Unsubscribe anytime. Prefer something to keep? Get the free Laws of UX guide as a PDF.
Founder, Science of Apps




