36 Microsoft Access Interview Questions & Answers

I recently had one of my Developer students email me asking if I could help him prepare for a job interview he has coming up for a position as an Access developer. I know he's completed most of my Access Developer series, and based on the types of questions he's asked me in the past, I know he's more than qualified. But it got me to thinking about the questions I would ask if I were hiring someone as an Access Developer. 

So here's my list of things to make sure you know if you want a job as an Access Developer. Note that if you're taking a Microsoft Access class in school (college, high school, etc.) then you may find these questions on your exams.

If you can think of any more good interview / test questions let me know. Also if you'd like to see me make a video like this about VBA, Excel, or anything else I teach, post them in the commments below.

Links

• What is Microsoft Access?: https://599cd.com/WhatIsMicrosoftAccess
• Parts of an Access Database: https://599cd.com/Parts
• Relationships: https://599cd.com/Relationships
• SQL with Access: https://599cd.com/SQLwithAccess
• Normalizing Data: https://599cd.com/Normalizing
• Referential Integrity: https://599cd.com/Referential
• Many-to-Many: https://599cd.com/ManyToMany
• Split Your Database: https://599cd.com/Split
• Simple Security: https://599cd.com/SimpleSecurity
• Access Security Seminar: https://599cd.com/Security
• Database Password: https://599cd.com/DatabasePassword
• Access Data Encryption Seminar: https://599cd.com/Encrypt
• Access SQL Server Online: https://599cd.com/SQLOnline
• Evil Access Stuff: https://599cd.com/EvilAccessStuff
• Images: https://599cd.com/Image
• Calculated Fields: https://599cd.com/Calculated
• Concatenation: https://599cd.com/Concat
• Reserved Words: https://599cd.com/ReservedWords
• Continuous Forms: https://599cd.com/Continuous
• DateAdd: https://599cd.com/DateAdd
• Date Math: https://599cd.com/DateMath
• Default Value: https://599cd.com/Default
• Update Queries: https://599cd.com/UpdateQ
• Enter Parameter Value: https://599cd.com/EPV
• Parameter Query: https://599cd.com/Parameter
• Query Criteria: https://599cd.com/Criteria
• Select Multiple Records: https://599cd.com/SelectRecords
• Input Mask: https://599cd.com/InputMask
• DLookup: https://599cd.com/DLookup
• Value From a Form: https://599cd.com/FormName
• Open Report: https://599cd.com/OpenReport
• Optimizing Short Text Field Sizes: https://599cd.com/TextFieldSizes
• Between Wrong: https://599cd.com/Between
• ISO Date Format: https://599cd.com/ISO
• AutoNumbers Are NOT For You: https://599cd.com/AANFY
• Sequential Numbers: https://599cd.com/Counter
• Compact & Repair: https://599cd.com/Compact
• Append Query: https://599cd.com/Append
• Restore Deleted AutoNumber: https://599cd.com/RestoreAutoNumber
• Access Updater: https://599cd.com/Updater
• Subforms: https://599cd.com/Subform
• Tab Stop, Order, Cycle: https://599cd.com/TabOrder
• Trusted Location: https://599cd.com/Trusted
• Import Data: https://599cd.com/Import
• Link to Excel: https://599cd.com/LinkToExcel
• Indexing: https://599cd.com/Indexing
• Validation Rules: https://599cd.com/Validation
• Benefits of Access: https://599cd.com/Benefits

Written Version

• Here's a written version of the interview questions.

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, exam questions, test questions, quiz, practical questions, interview questions