Unlock hundreds more features
Save your Quiz to the Dashboard
View and Export Results
Use AI to Create Quizzes and Analyse Results

OR
Sign inSign in with Facebook
Sign inSign in with Google
Quizzes > Computers & Technology > Programming & Software

Ultimate MS Access Exam Quiz - Test Your Skills

Ready for a challenge? Dive into our MS Access quiz and ace your exam!

Difficulty: Moderate
2-5mins
Learning OutcomesCheat Sheet
Paper art style quiz banner for MS Access exam featuring database icons question marks check marks on coral background

This MS Access exam quiz helps you practice core skills like tables, queries, forms, and reports, and see what to review before test day. Get instant feedback on each question, then build on it with more Access practice or explore database management scenarios to strengthen your real-world database work.

What is the default file extension for an Access database created in Access 2007 or later?
.accdb
.mdb
.xlsx
.docx
The .accdb extension was introduced in Access 2007 and is the default format for new databases in later versions. It supports enhanced features such as multivalued fields and data macros, which are not available in .mdb format. Using .accdb ensures compatibility with modern Access features. .
Which view in Access allows you to enter, edit, and delete data directly?
Layout View
Form View
Design View
Datasheet View
Datasheet View displays records in a tabular grid similar to a spreadsheet, allowing you to enter, edit, and delete data directly in the table. It's ideal for quickly viewing and modifying data without designing a form. Other views like Design View are used to modify structure instead of data. .
In Access, what term describes a field that uniquely identifies each record in a table?
Primary key
Index
Data type
Foreign key
A primary key is a field or combination of fields that uniquely identifies each record in a table. It cannot contain nulls and must contain unique values. Defining a primary key helps enforce entity integrity and improves performance. .
Which object in Access is used to store VBA code and advanced logic?
Query
Module
Report
Table
Modules store VBA code that can automate tasks, create custom functions, and handle events in Access. You write procedures in modules that can be called from macros or object event properties. Modules allow advanced customization beyond what macros can achieve. .
What property would you set to require that a field cannot be left empty?
Default Value
Required
Allow Zero Length
Indexed
The Required property, when set to Yes, ensures that a user must enter a value in the field before saving the record. This prevents null entries and enforces data completeness. It is commonly used for key fields where data integrity is critical. .
What wildcard character matches any single character in an Access query?
#
*
%
?
In Access wildcard searches with the '*' and '?' characters, the '?' matches any single character while '*' matches a string of characters. This is used in criteria like LIKE "A?C" to find records such as "ABC". .
Which object is used to format and print data in Access?
Module
Form
Macro
Report
Reports are designed for formatting, summarizing, and printing data from your database. They allow grouping, sorting, and custom layout for presentation. Unlike forms, reports are optimized for printed output and read-only viewing. .
What is the purpose of a lookup field in Access?
To set default values
To store images
To perform calculations
To link records to another table
A lookup field displays values from another table or a value list to ensure consistency and enforce referential integrity. It lets users pick from pre-defined options rather than typing manually. This can simplify data entry and prevent errors. .
Which feature prevents simultaneous editing conflicts by multiple users?
Data macros
Record locking
Compact and repair
Referential integrity
Record locking locks a record when one user is editing it to prevent others from making simultaneous changes. This avoids write conflicts in multi-user environments. You can choose optimistic or pessimistic locking strategies in Access. .
Which view allows you to create and modify queries visually?
SQL View
Datasheet View
Layout View
Design View
Design View for queries provides a graphical interface to add tables, select fields, set criteria, and define joins without writing SQL. It's helpful for users who prefer a visual approach. SQL View is for writing or editing the SQL directly. .
What feature automatically reclaims unused space and optimizes performance in Access?
AutoCorrect
Save As
Compact and Repair Database
Backup
The Compact and Repair Database tool removes wasted space created by record deletions and object changes, and repairs minor database corruption. It reduces file size and can improve performance. Regular compaction is recommended for multi-user databases. .
In a one-to-many relationship, which side is the "many" side?
The junction table
The table with the foreign key
The table with the primary key
The secondary table
In a one-to-many relationship, the "many" side contains the foreign key that references the primary key on the "one" side. This allows multiple child records to link back to a single parent record. Understanding this is crucial for designing relational databases. .
What dialog appears when you right-click a field tab to filter by the selected value?
Show Filtered Records
Filter by Form
Filter Excluding Selection
Filter by Selection
Filter by Selection is the context menu option you get when you right-click a field value in Datasheet View. It quickly filters the recordset to show only records matching that value. It's a fast way to narrow results without building a query. .
Which property of a text field limits the number of characters allowed?
Format
Caption
Input Mask
Field Size
The Field Size property of a Short Text field specifies the maximum number of characters allowed. For Long Text fields, this property is not available since they can store up to 65,536 characters. Adjusting field size can optimize storage. .
Which set of objects are the four primary types in an Access database?
Tables, Relationships, Forms, Reports
Tables, Queries, Forms, Macros
Tables, Queries, Forms, Reports
Tables, Queries, Reports, Modules
The four primary object types in Access are Tables (store data), Queries (retrieve or change data), Forms (enter and view data), and Reports (format and print data). Modules and Macros are additional objects for automation. .
Which shortcut key opens the Visual Basic editor in Access?
Ctrl+R
Alt+F11
F2
F5
Pressing Alt+F11 opens the Visual Basic for Applications editor in Access, allowing you to view and edit VBA code. This is the same shortcut used across Office applications for VBA. It's essential for custom automation. .
Which SQL clause retrieves unique values in a query?
SELECT DISTINCT
SELECT UNIQUE
SELECT ONLY
SELECT FIRST
The DISTINCT keyword in SQL returns only unique values for the specified fields. It eliminates duplicate records in the result set. In Access, you choose 'Unique Values' in the query Design ribbon to apply DISTINCT. .
Which join type in Access returns all records from the left table and matching records from the right table?
Right Outer Join
Left Outer Join
Inner Join
Full Outer Join
A Left Outer Join includes all records from the left (first) table and any matching records from the right (second) table. Non-matching rows in the right table return nulls. Access query Design shows this as 'Include ALL records from "Table1" and only those from "Table2" where the joined fields are equal'. .
What tool splits a database into front-end and back-end files?
Linked Table Manager
Database Splitter
Upsizing Wizard
Compact and Repair
The Database Splitter wizard divides a single Access file into a front-end (with queries, forms, reports) and a back-end (with tables). This enhances performance and multi-user stability. After splitting, the front-end links to tables in the back-end. .
Which Access feature enforces referential integrity between related tables?
Data Macros
Relationships with Enforce Referential Integrity
Primary Key Index
Foreign Key Constraints
When defining relationships, checking 'Enforce Referential Integrity' ensures that you cannot add a record to a related table unless a matching record exists in the primary table. It also offers cascade update and delete options. This maintains consistent data. .
Which query type permanently changes existing data in tables?
Update Query
Crosstab Query
Parameter Query
Select Query
Update queries modify existing records based on specified criteria. When run, they change the data in one or more fields of the target table. Action queries like Update, Append, Delete, and Make Table alter table contents permanently. .
What property of a report section can control when code runs during printing?
OnFormat event
Detail section Height
OnOpen event
OnCurrent event
The OnFormat event occurs for each section of a report before it is printed or previewed, allowing you to customize formatting dynamically. It's often used to hide or highlight elements based on data values. Other events fire at different times. .
Which method in VBA opens a form in a specified view?
Forms.Open
DoCmd.OpenTable
DoCmd.OpenForm
Application.Forms.Open
In VBA, DoCmd.OpenForm opens an Access form in the view you specify (e.g., acFormView, acDesign). You provide the form name and optional arguments like filter or data mode. It's the standard method for programmatic form opening. .
Which tool helps you analyze table design for normalization issues?
Dependency Checker
Performance Analyzer
Database Documenter
Table Analyzer Wizard
The Table Analyzer Wizard examines your table structure and suggests how to split it into multiple tables to reduce redundancy and improve integrity. It walks you through normalization steps. It's found under Database Tools. .
Which event runs when a user clicks a control on a form?
OnLoad
OnClick
OnCurrent
AfterUpdate
The OnClick event triggers when the user clicks a control such as a button or text box on a form. You can attach VBA code or a macro to this event to perform actions like opening other objects or validating data. .
What is a crosstab query used for in Access?
To delete records
To make a table
To calculate sums by category across columns
To update records
A crosstab query summarizes data in a compact, spreadsheet-like format, with one set of values displayed across column headers and another set down the rows. It's useful for pivot-like reporting. You define row headings, column headings, and value fields. .
Which function returns the current system date in Access?
Today()
Time()
Now()
Date()
The Date() function returns the current system date without the time component. For date and time, use Now(). Date() is commonly used in default values and criteria to compare or insert today's date. .
Which object in Access can contain VBA event procedures as well as macros?
Table
Query
Form
Report
Both forms and reports support event properties that can run VBA procedures or embedded macros. You can attach code to events like OnOpen, OnLoad, or OnClick. Tables and queries do not support VBA event procedures. .
What is the Function Return type for a custom VBA function in Access?
Event
Function
Procedure
Sub
In VBA, a Function procedure returns a value and must be declared with the Function keyword and a return data type. Subs do not return values. You can call functions in queries, macros, and event properties. .
Which property would you set to run code when a form opens?
OnLoad
OnActivate
OnOpen
OnCurrent
The OnOpen event occurs before the form opens and before records are displayed, making it the ideal place for initialization code. OnLoad runs after the form is opened but before data is displayed. OnCurrent triggers when the current record changes. .
How do you prevent a cascade delete from removing child records in a relationship?
Enable Referential Integrity
Set DeleteRule in VBA to None
Uncheck Cascade Delete in Relationship properties
Use a delete query instead
In the Relationships window, editing properties of the one-to-many relationship lets you uncheck 'Cascade Delete Related Records'. This ensures deleting a parent record won't remove related child records. Enable Referential Integrity without cascade settings. .
Which DAO object represents the result of a query in VBA?
Recordset
Database
Field
QueryDef
In DAO, a Recordset object holds the data returned by a query or table, allowing you to navigate, update, and add records in VBA. QueryDef defines parameterized queries. Recordsets are central to VBA data manipulation. .
What technique can improve performance when joining large tables in Access?
Use subqueries instead of joins
Add indexes on join fields
Use complex domain functions
Convert tables to queries
Indexing the fields used in join conditions speeds up lookup and matching operations in large tables. Proper indexes can drastically reduce query execution time. Ensure statistics are up to date and avoid functions on indexed fields in criteria. .
Which SQL clause groups records for aggregate functions in Access?
GROUP BY
HAVING
ORDER BY
WHERE
The GROUP BY clause groups rows that have the same values in specified columns so aggregate functions like Sum, Count, and Avg can be applied to each group. You often use HAVING to filter grouped results. .
Which method runs a parameter query defined in Access from VBA?
DoCmd.RunSQL
CurrentDb.QueryDefs.Execute
DoCmd.OpenQuery
Application.ExecuteQuery
DoCmd.OpenQuery opens and runs a saved query, prompting for any parameters defined in the query. For action queries, it will execute them. CurrentDb.QueryDefs('').Execute also runs action queries but doesn't display results. .
What is the purpose of the TempVars collection in Access?
Define user roles
Hold form controls
Store temporary variables globally
Cache linked tables
TempVars is a VBA collection that lets you store temporary name/value pairs accessible throughout the database session, including macros, queries, and code modules. They persist until cleared or the database is closed. .
Which method would you use in VBA to loop through all fields in a recordset?
Loop Through rs.Fields.Count
For Each fld In rs.Fields
rs.Fields.Next
Do While Not rs.EOF
Using 'For Each fld In rs.Fields' iterates over every Field object in the Fields collection of a Recordset. Inside the loop, you can access fld.Name and fld.Value. This is the most straightforward pattern. .
Which Access object holds metadata about all other objects in the database?
System Tables
Property Sheet
Navigation Pane
Database Documenter
System Tables (hidden by default) like MSysObjects contain definitions of all database objects. They store metadata used internally by Access. You can view them by enabling system objects in Options. .
What keyword in Access SQL limits the number of records returned?
TOP
LIMIT
ROWCOUNT
FETCH
The TOP keyword in Access SQL returns only the specified number or percentage of records from the result set. For example, SELECT TOP 5 * FROM Customers retrieves the first five records. LIMIT is not supported in Jet SQL. .
Which method updates a table via an SQL string in VBA without opening a query?
DoCmd.RunSQL
DoCmd.OpenQuery
DoCmd.TransferDatabase
CurrentDb.Execute
DoCmd.RunSQL executes an action SQL statement passed as a string in VBA, prompting for confirmation by default. CurrentDb.Execute also runs SQL without prompts and is preferred in code that must run silently. .
What feature lets you call a macro without embedding it in an object's event property?
Data macro
Hidden macro
Global macro
AutoExec macro
An AutoExec macro runs automatically when the database opens, without being tied to an object event. It can call other macros or perform startup tasks. No event property needs to reference it. .
Which SQL keyword sorts query results in Access?
ORDER BY
SORT BY
GROUP BY
FILTER BY
The ORDER BY clause sorts the result set by one or more fields in ascending (ASC) or descending (DESC) order. For example, 'ORDER BY LastName DESC' sorts names from Z to A. .
How do you reference a form control in a query expression in Access?
[Forms]![FormName]![ControlName]
Form.FormName.ControlName
Forms!FormName.ControlName
[Form].[ControlName]
The correct syntax uses square brackets: [Forms]![YourFormName]![YourControlName]. This tells Access to take the value of that control at runtime. It's commonly used in query criteria. .
Which option lets you call VBA directly from a macro?
CallProcedure
RunCode
ExecuteVBA
RunMacro
The RunCode action in macros runs a public function in a standard module. You specify the function name and any arguments. This allows combining macros and VBA procedures. .
In DAO, how do you begin a transaction in Access VBA?
Begin Transaction
CurrentDb.BeginTrans
StartTransaction
DAO.TransactionStart
To begin a transaction in DAO you call CurrentDb.BeginTrans. You can then execute multiple operations and either commit with .CommitTrans or rollback with .Rollback. Transactions help maintain data integrity. .
Which technique prevents SQL injection when building SQL in VBA?
Concatenate strings carefully
Use parameterized QueryDefs
Use DoCmd.RunSQL
Escape quotes manually
Parameterized QueryDefs allow you to define parameters and assign values in VBA without concatenating strings, preventing injection. You set QueryDef.Parameters(0) = value before executing. .
How can you dynamically change the RowSource of a combo box in VBA?
Me!ComboSource = SQLString
Me.Combo.RowSource = SQLString
DoCmd.SetRowSource Combo, SQLString
Combo.RowSourceQuery = SQLString
You assign your SQL statement string to the RowSource property of the combo box control in code, e.g. Me.cmbItems.RowSource = sql. Then requery the control. This allows dynamic lists. .
Which object and method chains multiple recordset updates into a single transaction?
DAO.Database.OpenTrans
CurrentDb.Execute(SQL, dbTransaction)
Application.Transactions.Start
DBEngine.BeginTrans and .CommitTrans
Using DBEngine.Workspaces(0).BeginTrans and later .CommitTrans wraps multiple DAO operations into one transaction. You can roll back via .Rollback if needed. This grouping ensures atomicity. .
0
{"name":"What is the default file extension for an Access database created in Access 2007 or later?", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the default file extension for an Access database created in Access 2007 or later?, Which view in Access allows you to enter, edit, and delete data directly?, In Access, what term describes a field that uniquely identifies each record in a table?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

Study Outcomes

  1. Understand Core Access Concepts -

    Grasp the fundamentals of tables, relationships, and keys to build a solid foundation for any access database test.

  2. Apply Normalization Techniques -

    Use normalization principles to design efficient, scalable tables and eliminate data redundancy in your ms access final exam scenarios.

  3. Analyze and Optimize Queries -

    Examine query structures and apply optimization strategies to improve performance in real-world and exam-style access questions.

  4. Evaluate Data Integrity Measures -

    Implement constraints, validation rules, and referential integrity checks to maintain accurate and reliable data in your access database test projects.

  5. Interpret Exam-Style Questions -

    Break down complex access exam prompts to identify key requirements and solution paths for higher scores.

  6. Prepare with Targeted Feedback -

    Use instant scoring and detailed explanations from our ms access quiz to pinpoint areas for improvement and boost your confidence.

Cheat Sheet

  1. Database Normalization -

    Mastering 1NF, 2NF, and 3NF is essential for any access exam; it removes data redundancy and ensures consistency. Use the mnemonic "1NF”Atomic, 2NF”Partial, 3NF”Transitive" to recall each step. Official Microsoft Docs and university courses (e.g., Stanford DB) stress normalization for optimal table design.

  2. Query Fundamentals -

    Whether you're tackling an ms access quiz or access database test, knowing SQL basics like SELECT, WHERE, and JOIN is a must. For example: SELECT FirstName FROM Employees WHERE Department='Sales'; illustrates filtering, while INNER JOIN links tables. Microsoft Learn and W3Schools both emphasize practicing real access questions to solidify these skills.

  3. Referential Integrity & Relationships -

    Setting one”to”many or many”to”many relationships correctly prevents orphan records and enforces data rules. Remember to enable "Cascade Update/Delete" where needed - academic programs at the University of Washington highlight this feature for robust design. Solid relationships boost performance and accuracy in your ms access final exam scenarios.

  4. Forms & Reports Design -

    Creating intuitive forms and detailed reports is key for both usability and exam success. Use bound controls for data entry and subforms for related records - think "CRISP": Controls, Record Source, Input masks, Subforms, Properties. Resources from Microsoft Education show how well-designed forms streamline data handling.

  5. Macros & VBA Automation -

    Automate routine tasks with simple macros or custom VBA for complex logic in your access questions. For instance, an AutoExec macro can open a startup form, while VBA event procedures (e.g., Private Sub Form_Open()) handle advanced workflows. Official MSDN guides recommend starting with macros, then converting to VBA as you tackle higher-level access exam challenges.

Make a Quiz (FREE) Copy & Edit This Quiz Create a Quiz with AI

Programming & Software Quizzes

Powered by: Quiz Maker