Ready to prove your skills with our free MS Access exam quiz? If you're brushing up on Access 101 basics or tackling advanced queries, this challenge is for you. Dive into a hands-on access exam that doubles as an access practice test, gauging your grasp of tables, relationships and SQL. Whether you're prepping for a formal database exam or curious about your proficiency, this ms access quiz will illuminate strengths and gaps. Explore insights in access database application and jump straight into the access exam now. Let's get started and boost your confidence!
Which file extension identifies an Access database in versions 2007 and later?
.accdb
.mdb
.xlsx
.docx
Microsoft Access 2007 and later use the .accdb file format to support newer features like multimodal data and attachments. Earlier versions used .mdb. The .accdb format replaced it to improve security and performance. For details see Microsoft File Format Reference.
What is the purpose of a primary key in an Access table?
Uniquely identify each record
Store large text fields
Validate data input
Link two databases
A primary key enforces uniqueness so each record can be identified unambiguously. It also improves indexing and relationship integrity. Without a primary key, duplicate records could occur. Learn more at Access Primary Keys.
In Access, which view lets you enter and edit table data directly?
Datasheet View
Design View
Layout View
Form View
Datasheet View displays table records in a grid, allowing direct data entry and editing. Design View is for structure changes, not data editing. Form View presents a custom form for data. See Use Design View.
Which data type should you choose for storing currency values in Access?
Currency
Number
Text
Memo
The Currency data type stores monetary values with fixed decimal precision and prevents rounding errors. Number can store numbers but lacks currency formatting. Text and Memo store strings. More at Data Types and Field Properties.
What does referential integrity enforce in relationships?
Consistency between related tables
Faster queries
Encryption of data
Automatic backups
Referential integrity ensures that foreign keys in a child table match primary keys in the parent, preventing orphan records. It also can cascade updates or deletes. This maintains consistency across related tables. More info at Overview of Referential Integrity.
Which object type would you use to enter, display, and view data in Access?
Form
Table
Query
Report
Forms provide a user-friendly interface for data entry and display in Access. Tables store data, queries retrieve it, and reports format it for printing. Forms can include controls like text boxes and buttons. See Introduction to Forms.
Which view lets you define fields, data types, and properties for a table?
Design View
Datasheet View
Form View
Layout View
Design View lets you add or modify field names, data types, and field properties. Datasheet View is for data entry, not structure. Form and Layout Views apply to forms and reports. Learn about design view at Create and modify tables.
What kind of relationship connects one record in Table A to many in Table B?
One-to-Many
One-to-One
Many-to-Many
Self-Join
A one-to-many relationship links a single record in the primary table to multiple related records in the secondary table. One-to-one links single records both ways. Many-to-many requires a junction table. See Create table relationships.
Which feature would you use to import data from an Excel spreadsheet?
External Data > Excel
Database Tools > Relationships
Create > Table
File > Compact & Repair
Use the External Data tab and select Excel to import or link spreadsheets. Relationships and Create Table do not import data. Compact & Repair maintains the database. More at Import or link to Excel.
Which Access object should you use to generate printable summaries of data?
Report
Query
Form
Macro
Reports format and summarize data for printing or PDF. Queries retrieve and filter data. Forms are for entry and navigation. Macros automate tasks. See Introduction to Reports.
In Access, where do you set the properties such as Input Mask and Caption for a field?
Field Properties in Design View
Table Datasheet View
Query Design Grid
Form Layout View
Field properties like Input Mask and Caption are configured under Field Properties in Design View. Datasheet, Query, and Form views don’t provide detailed field property settings. More details at Specify Field Properties.
Which command removes unused space and repairs a corrupted Access database?
Compact and Repair Database
Backup Database
Encrypt with Password
Save Object As
Compact and Repair reclaims storage space and fixes minor corruption. Backup simply copies the file. Encrypt protects with a password. Save Object As duplicates an object. See Compact and Repair.
Which pane lists all tables, queries, forms, and reports in an Access database?
Navigation Pane
Property Sheet
Field List
VBA Editor
The Navigation Pane shows every database object. The Property Sheet displays properties of controls. The Field List appears in forms and reports. VBA Editor opens code modules. More at Navigation Pane.
What is a lookup field used for in Access?
Allow selection of a value from another table
Encrypt field data
Store binary objects
Automatically back up data
A lookup field lets users pick a value from a related table or value list. It simplifies data entry but can hide relationships. It does not encrypt or store binary objects. More at Create a lookup field.
Which view in Query Design lets you see the SQL statement generated?
SQL View
Datasheet View
Design View
Layout View
SQL View displays the underlying SQL code of a query. Datasheet shows results, Design shows a graphical grid, and Layout adjusts formatting. For details see SQL View.
Which type of join includes all records from the left table and matching ones from the right?
Left Outer Join
Inner Join
Right Outer Join
Full Outer Join
A left outer join returns all rows from the left table and matched rows from the right. Inner joins return only matches. Right outer joins return all from the right. Full outer joins return all from both. See Join Types.
What does a Parameter Query prompt you to do?
Enter criteria when query runs
Group records
Sort records
Join tables
A parameter query prompts the user for input to use as criteria each time it runs. It doesn’t group or sort by itself. Joins link tables but aren’t prompted. Learn more at Parameter Queries.
Which macro action opens a form when a database starts?
OpenForm
RunForm
ShowForm
LoadForm
The OpenForm macro action opens a specified form. There is no RunForm or ShowForm action. LoadForm loads it without displaying. Use OpenForm in an AutoExec macro. See OpenForm Action.
Which property would you set to make a form always open in a specific size?
AutoResize = No
BorderStyle = Sizable
PopUp = Yes
Modal = Yes
Turning AutoResize off prevents Access from adjusting the form to fit data. BorderStyle, PopUp, and Modal control window chrome and behavior but not automatic sizing. More at Form Properties.
What is normalization in database design intended to do?
Reduce data redundancy
Increase file size
Encrypt data
Improve graphics rendering
Normalization organizes tables to minimize duplicate data and dependency anomalies. It does not encrypt or affect file size directly. It improves data integrity. See Normalization Overview.
Which function would you use in a query to convert text to uppercase?
UCase()
Upper()
ToUpper()
Caps()
UCase() converts strings to uppercase in Access expressions. Upper() is used in other systems but not Access. ToUpper and Caps are not valid here. See UCase Function.
In VBA, which object library is used for Data Access Objects?
DAO
ADO
OLEDB
OLEDBDB
DAO stands for Data Access Objects, the native library for Access tables. ADO is a more generic interface. OLEDB and OLEDBDB aren’t VBA libraries. More at DAO and ADO.
What does the Switchboard Manager create in Access?
A navigation form
A lookup table
A data macro
A report wizard
The Switchboard Manager builds a front-end menu form for navigation. It does not create tables or data macros. Reports are separate. See Switchboard Manager.
Which query type is used to summarize data into groups?
Crosstab Query
Select Query
Delete Query
Pass-Through Query
A crosstab query summarizes and groups data in a matrix format by rows and columns. Select queries retrieve rows. Delete removes records. Pass-through sends SQL to a server. For details see Crosstab Queries.
Which feature allows you to run SQL directly on a linked server?
Pass-Through Query
Union Query
Parameter Query
Make-Table Query
Pass-through queries send SQL to an external database engine, bypassing the Jet engine. Union combines datasets. Parameter prompts input. Make-Table creates tables. See Pass-Through Queries.
What is the purpose of an Append Query?
Add records to another table
Update existing records
Delete records
Create a new form
Append queries add selected records to another table. Update queries modify values. Delete queries remove records. Forms are separate objects. Learn more at Append Queries.
Which property of a control in a report sets visible text color?
Fore Color
Back Color
Border Color
Caption
Fore Color sets the text color of controls. Back Color sets background. Border Color defines border lines. Caption is the text label. See Control Properties.
Which SQL clause filters grouped records in a Totals query?
HAVING
WHERE
GROUP BY
ORDER BY
The HAVING clause filters results after GROUP BY has aggregated them. WHERE filters rows before aggregation. GROUP BY groups records. ORDER BY sorts the final output. Info at SQL HAVING.
Which method creates a duplicate table including data in SQL?
SELECT INTO
INSERT INTO
CREATE TABLE AS
COPY TABLE
SELECT INTO creates a new table populated with query results. INSERT INTO adds data to an existing table. CREATE TABLE AS isn’t supported in Jet SQL. COPY TABLE is not a SQL command. See SELECT INTO.
In VBA, which object represents a set of records from a query or table?
Recordset
RecordGroup
DataList
ResultSet
A Recordset object holds rows from a table or query and allows navigation and editing. There is no RecordGroup or DataList in DAO. ResultSet is ADO terminology. More at Recordset Object.
Which action query changes field values in selected records?
Update Query
Append Query
Delete Query
Make-Table Query
Update queries modify existing records based on criteria. Append adds new records, delete removes them, and make-table creates a new table. See Update Queries.
What is the effect of setting TempVars in VBA?
Store temporary global variables
Define table variables
Encrypt macro code
Lock forms
TempVars let you store values globally during a session for use in macros, queries, and VBA. They aren’t table variables and don’t encrypt or lock. Read more at Using TempVars.
Which Windows-registered OLEDB provider does Access use for ACE engine?
Microsoft.ACE.OLEDB.12.0
Microsoft.Jet.OLEDB.4.0
SQLNCLI11
MSDAORA
ACE engine uses Microsoft.ACE.OLEDB.12.0 or higher. Jet.OLEDB.4.0 is the old Jet engine. SQLNCLI11 is SQL Server, MSDAORA Oracle. See OLEDB Providers.
What does splitting a database do?
Separates data and application objects
Encrypts front-end
Creates a backup
Compresses files
Splitting places tables in a back-end and queries, forms, reports in a front-end for multiuser performance. It doesn’t encrypt, backup, or compress. Read Split a Database.
Which Access feature lets you audit changes at the table level?
Data Macros
VBA Events
User-Level Security
Record-Level Encryption
Data Macros can run on insert, update, and delete at the table level, enabling auditing. VBA events work on forms. User-level security was removed in Acc 2007. No record-level encryption feature exists. See Data Macros.
Which analysis tool helps identify performance bottlenecks in queries?
Performance Analyzer
Table Analyzer
SQL Profiler
Macro Debugger
The Performance Analyzer reviews objects for speed issues and suggests changes. Table Analyzer helps normalize tables. SQL Profiler is for SQL Server. Macro Debugger steps through VBA. For details see Performance Analyzer.
Which SQL construct combines results from multiple SELECTs with the same column count?
UNION
INTERSECT
EXCEPT
JOIN
UNION merges result sets from two SELECT statements with identical columns. INTERSECT and EXCEPT aren’t supported in Access SQL. JOIN relates tables. More at Union Queries.
What is a pass-through query primarily used for?
Run server-side SQL directly
Join local tables
Make a temporary table
Filter a form
Pass-through queries send SQL to the connected database server without local parsing, improving performance for complex operations. They don’t join local tables or filter forms. See Pass-Through Queries.
Which command line utility can compact an Access database?
MSACCESS.exe /compact
ACCESS.exe /repair
JETCOMP.exe /compact
DBCC COMPACT
MSACCESS.exe /compact runs compact and repair at startup. ACCESS.exe is same executable name. JETCOMP.exe is separate but without /compact switch. DBCC is SQL Server. More at Command-Line Compact.
Which VBA error-handling statement ensures cleanup code runs regardless of errors?
On Error GoTo Cleanup
On Error Resume Next
On Error GoTo 0
On Error Stop
Redirecting errors to a Cleanup label lets you run cleanup routines before exiting. Resume Next skips the error. GoTo 0 disables error handling. There is no On Error Stop. See On Error Statement.
How do you encrypt an Access database with a password programmatically?
DBEngine.CompactDatabase with a new connection string
CurrentDb.SetPassword
Application.EncryptDatabase
FileSystemObject.Encrypt
Use DBEngine.CompactDatabase specifying the EncryptDatabase parameter in the destination connection string. There’s no SetPassword method. Application.EncryptDatabase and FSO.Encrypt don’t exist. More at Secure an Access database.
Which XML mapping feature integrates Access data with SharePoint lists?
Export as SharePoint List
Save as XML Schema
Link OLEDB XML
Publish via VBA
Access can export or link tables to SharePoint lists directly. Saving XML schema alone doesn’t push to SharePoint. There’s no OLEDB XML link. Publishing via VBA still uses SharePoint integration. See Link to SharePoint.
Which technique secures front-end code from design changes?
Convert to ACCDE
Enable VBA project password only
Hide Navigation Pane
Mark database read-only
ACCDE compiles code and prevents design view or VBA editing. VBA password alone can be cracked. Hiding the pane and read-only flags don’t block design changes. See Create an ACCDE.
What is the purpose of Record-Level Locking in Access 2010+?
Prevent conflicts on individual records
Lock entire table
Encrypt records
Audit changes
Record-Level Locking locks only the record being edited to avoid multiuser conflicts while keeping others accessible. It does not lock tables, encrypt, or audit changes. More at Record-Level Locking.
Which CData macro event triggers when data is updated in a linked table?
After Update Data Macro
On Change Macro
DataChanged Event
LinkedTable Refresh
After Update Data Macros run when linked or local data is modified in a table. On Change is form-based. There’s no DataChanged event or LinkedTable Refresh macro. See Data Macros Overview.
0
{"name":"Which file extension identifies an Access database in versions 2007 and later?", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Which file extension identifies an Access database in versions 2007 and later?, What is the purpose of a primary key in an Access table?, In Access, which view lets you enter and edit table data directly?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Study Outcomes
Understand Core Access 101 Concepts -
Identify and explain the fundamental components of an Access database - including tables, fields, records, and relationships - to build a strong foundational knowledge.
Construct and Optimize Queries -
Design both basic Select queries and advanced multi-table joins, and apply optimization techniques to retrieve accurate data efficiently.
Manage Tables and Relationships -
Create, modify, and link tables using primary and foreign keys to enforce data organization and maintain relational integrity.
Apply Data Validation and Integrity Rules -
Implement input masks, validation rules, and referential integrity constraints to ensure the accuracy and consistency of your database.
Evaluate Query Results for Performance -
Analyze query execution plans and performance metrics to identify bottlenecks and enhance overall database responsiveness.
Prepare Confidently for the Access Exam -
Assess your proficiency gaps with targeted practice questions and realistic scenarios to boost your readiness for the official database exam.
Cheat Sheet
Relational Table Design -
Understanding tables, primary keys, and relationships is foundational for any database exam, especially your access exam. According to Microsoft Docs, a one-to-many relationship is created by matching a primary key in one table (e.g., CustomerID) to a foreign key in another, ensuring referential integrity. Remember the mnemonic "P2R = Primary key to Related key" when designing Access 101 tables.
Query Basics & SQL Syntax -
Mastering the SELECT-FROM-WHERE pattern is vital for the ms access quiz and any access practice test. For example: SELECT LastName, FirstName FROM Employees WHERE Department='Sales'; As per University research, visual query design in Access helps beginners link SQL concepts to GUI actions.
Normalization Principles -
Review 1NF, 2NF, and 3NF rules to eliminate redundancy and ensure data integrity - key topics in your database exam. In 2NF, for instance, all non-key attributes must fully depend on the primary key (no partial dependencies). Industry journals note that proper normalization reduces update anomalies by up to 50%.
Aggregate & Domain Functions -
Familiarity with SUM, AVG, COUNT, and domain functions like DSum is crucial for the access practice test. Example: SELECT AVG(Salary) AS AvgPay FROM Staff; Microsoft's official institution guidelines emphasize using domain aggregates to calculate across related tables without complex joins.
Performance Tuning & Indexing -
Optimizing Access performance by creating indexes on foreign and search fields can slash query times dramatically - a must-know for the access exam. Best practices from the Microsoft Access Team recommend compacting and repairing your database regularly to maintain index efficiency. Tip: Index fields you use in WHERE clauses, but avoid over-indexing small tables.
