MS Access 101 Quiz
(162).jpg "MS Access 101 Quiz - Quiz")
Getting some basic computer knowledge is something that most people are required to have in any business field. There are different computer applications used daily. How good are you when it comes to MS Access? Take up the quiz below and get to increase your understanding of the use of the application before you get tested. All the best!
Questions and Answers
- 1.
Which object is used to create a form?
- A.
Tables and Queries
- B.
Tables only
- C.
Tables and reports
- D.
Queries and reports
Correct Answer
A. Tables and QueriesExplanation
Tables and Queries are used to create a form. Tables store the data that will be entered into the form, while queries retrieve and manipulate the data from the tables. By using tables and queries, a form can be created to display and collect information from the user in a structured manner. This allows for efficient data entry and retrieval within the form.Rate this question:
-
- 2.
What determines a table’s sort order?
- A.
AutoNumber field
- B.
Index field
- C.
Field order
- D.
Primary key
Correct Answer
B. Index fieldExplanation
The sort order of a table is determined by the Index field. An index is created on one or more fields in a table to improve the performance of data retrieval operations. When sorting data, the index field is used to determine the order in which the records are displayed or accessed. By using an index field, the database can quickly locate and retrieve the requested data in the desired order, making sorting more efficient.Rate this question:
-
- 3.
What is an intersection of a row and a column?
- A.
Form
- B.
Cursor
- C.
Cell
- D.
Record
Correct Answer
C. CellExplanation
An intersection of a row and a column refers to the point where a row and a column meet in a table or grid. This point is called a cell and it represents a single unit of data in the table. Each cell contains specific information or values corresponding to its position in the row and column. Therefore, the correct answer for this question is "Cell".Rate this question:
-
- 4.
Which tool do you use to create a query object?
- A.
Database wizard
- B.
Simple filter wizard
- C.
Simple query wizard
- D.
Table query wizard
Correct Answer
C. Simple query wizardExplanation
The Simple query wizard is used to create a query object. This tool allows users to easily create queries by selecting the desired fields and criteria from the database. It provides a user-friendly interface and step-by-step instructions to guide users through the query creation process. With the Simple query wizard, users can quickly generate queries without having to write complex SQL statements manually.Rate this question:
-
- 5.
Which of the following is not a view for interacting with a form object?
- A.
Datasheet view
- B.
Design view
- C.
Form view
- D.
Layout view
Correct Answer
D. Layout viewExplanation
Layout view is not a view for interacting with a form object. Datasheet view allows users to interact with the form data in a spreadsheet-like format. Design view is used for creating and modifying the design of the form. Form view is used to enter and view data in a form. However, Layout view is not a valid view option for interacting with a form object.Rate this question:
-
- 6.
What is the purpose of indexing?
- A.
To reduce table size
- B.
To speedup data search
- C.
Both A and B
- D.
None of the above
Correct Answer
B. To speedup data searchExplanation
Indexing is the process of creating a data structure that allows for faster retrieval of data from a database. It creates a separate structure that contains a subset of the data, organized in a way that makes it easier and faster to search for specific information. By using indexing, the time taken to search for data is significantly reduced, as the database system can directly access the indexed structure instead of scanning the entire table. Therefore, the purpose of indexing is to speed up data search.Rate this question:
-
- 7.
Which is the valid data type in Access?
- A.
Number
- B.
Text
- C.
Currency
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The correct answer is "All of the above" because in Access, all three data types (Number, Text, and Currency) are valid and commonly used. Number data type is used for numeric values, Text data type is used for alphanumeric values, and Currency data type is used for monetary values. So, all of these data types can be used to store different types of data in Access.Rate this question:
-
- 8.
How many types of relations may exist between tables in databases?
- A.
4
- B.
3
- C.
2
- D.
1
Correct Answer
B. 3Explanation
In a database, tables can have relationships with each other. These relationships are established using keys, such as primary keys and foreign keys. There are three types of relationships that can exist between tables: one-to-one, one-to-many, and many-to-many. In a one-to-one relationship, each record in one table is related to only one record in another table. In a one-to-many relationship, each record in one table can be related to multiple records in another table. In a many-to-many relationship, multiple records in one table can be related to multiple records in another table. Therefore, the correct answer is 3.Rate this question:
-
- 9.
What is the full form of SQL?
- A.
Sophisticated Question List
- B.
Structured Question List
- C.
Structured Query Language
- D.
Small Query Length
Correct Answer
C. Structured Query LanguageExplanation
SQL stands for Structured Query Language. It is a programming language used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases. It is widely used in the field of database management systems and is essential for working with databases efficiently.Rate this question:
-
- 10.
Which data type is better to use for storing phone number in the following format “977-1-1234567”?
- A.
Text
- B.
AutoNumber
- C.
Number
- D.
Currency
Correct Answer
A. TextExplanation
The phone number format "977-1-1234567" includes hyphens, which are non-numeric characters. Therefore, the best data type to use for storing this phone number would be "Text" as it allows for the storage of both numeric and non-numeric characters.Rate this question:
-
- 11.
What do you call a collection of records matching parameters of a query?
- A.
Field
- B.
Record
- C.
Query
- D.
Dynaset
Correct Answer
D. DynasetExplanation
A dynaset is a term used to describe a collection of records that match the parameters of a query. It is a dynamic set of data that can be updated or modified based on the query criteria. This term is commonly used in database management systems to refer to the result set of a query that meets specific conditions. Therefore, a dynaset is the correct answer for this question.Rate this question:
-
- 12.
Which query do you use to answer the question “Which employees earn more than $5000 a month”?
- A.
Search query
- B.
Cross tab query
- C.
Select query
- D.
Update query
Correct Answer
C. Select queryExplanation
A select query is used to retrieve specific data from a database. In this case, the query "Which employees earn more than $5000 a month?" can be answered by using a select query to retrieve the employees who have a monthly salary greater than $5000.Rate this question:
-
- 13.
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
- A.
Zipcode, firstname, lastname
- B.
Firstname, lastname, zipcode
- C.
Zipcode, lastname, firstname
- D.
Can’t sort by multiple fields
Correct Answer
C. Zipcode, lastname, firstnameExplanation
The correct order to sort the Dynaset first by zipcode, then by lastname, and finally by firstname is zipcode, lastname, firstname. This means that the records will be arranged in ascending or descending order based on the zipcode field first, then within each zipcode group, the records will be sorted by lastname, and finally within each lastname group, the records will be sorted by firstname.Rate this question:
-
- 14.
What does the expression [detail] ! [product] * 1.30 do?
- A.
Multiplies the contents of detail and product fields by 1.3
- B.
First divides detail by product and then multiplies by 1.3
- C.
Multiplies the contents of detail in the product table by 1.3
- D.
Multiplies the contents of product in the detail table by 1.3
Correct Answer
D. Multiplies the contents of product in the detail table by 1.3Explanation
The expression [detail] ! [product] * 1.30 multiplies the contents of product in the detail table by 1.3.Rate this question:
-
- 15.
Which criteria return only those addresses beginning with the letter “K”?
- A.
Address = “K”
- B.
Address = “K*”
- C.
Address = “K?”
- D.
Address = “K#”
Correct Answer
B. Address = “K*”Explanation
The criteria "address = 'K*'" returns only those addresses beginning with the letter "K". The asterisk (*) is a wildcard character that represents any number of characters, so "K*" matches any address that starts with "K" followed by any number of characters.Rate this question:
-
- 16.
Which criteria do not return the position “Officer” as a match?
- A.
Position = “*ff*”
- B.
Position = “O??icer”
- C.
Position = “ ?ff*”
- D.
Position = “O#r”
Correct Answer
B. Position = “O??icer”Explanation
The criteria "position = “O??icer”" does not return the position "Officer" as a match because the question marks represent wildcard characters that can match any single character. Therefore, the question mark in the second position can match any character, making it possible for the position to be "Officer".Rate this question:
-
- 17.
Which query do you use to answer the question “What is the average salary of the employees”?
- A.
Search query
- B.
Cross tab query
- C.
Select query
- D.
Update query
Correct Answer
C. Select queryExplanation
A select query is used to retrieve data from a database. In this case, the select query can be used to retrieve the salary data of all the employees. By using aggregate functions like AVG, the average salary of the employees can be calculated. Therefore, a select query is the appropriate query to answer the question "What is the average salary of the employees?".Rate this question:
-
- 18.
What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
- A.
Display all customers with CustID from 10 to 100
- B.
Display all customers with CustID above 10
- C.
Display all customers with CustID below 100
- D.
Display all customers with CustID from 11 to 99
Correct Answer
D. Display all customers with CustID from 11 to 99Explanation
The given SQL query "Select * from customer where CustID>10 and CustID10" which selects customers with CustID above 10, and the condition "CustIDRate this question:
-
- 19.
How to make a date field DOB store the dates like “2002/10/17” ?
- A.
By setting the input mask property to “yyyy/mm/dd”
- B.
By setting the format property to “yyyy/mm/dd”
- C.
By entering dates in yyyy, mm, dd order
- D.
None of the above
Correct Answer
B. By setting the format property to “yyyy/mm/dd”Explanation
By setting the format property to "yyyy/mm/dd", the date field DOB will store the dates in the specified format of "year/month/day". This means that when entering a date, it should be entered in the order of year, month, and day, separated by slashes. This format ensures that the dates are stored consistently and can be easily interpreted and manipulated. The other options of setting the input mask property or entering dates in a different order are not correct for achieving the desired format.Rate this question:
-
- 20.
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
- A.
By setting required to ‘Yes’
- B.
By using default value
- C.
By defining validation rule
- D.
By using format
Correct Answer
C. By defining validation ruleExplanation
By defining a validation rule, you can limit the value of the 'Sex' field to 0 and 1 only. This means that any other value entered into the field will be considered invalid and will not be accepted. This ensures that the field can only contain the specified values, providing data integrity and accuracy.Rate this question:
-
- 21.
In an application created using the database wizard, the main menu is presented as a:
- A.
Form, called a switchboard
- B.
Report, called a menu
- C.
Table, called a switchboard
- D.
Query, called a menu
Correct Answer
A. Form, called a switchboardExplanation
In an application created using the database wizard, the main menu is presented as a form, called a switchboard. A switchboard is a user-friendly interface that allows users to navigate through different sections or functionalities of the application. It typically contains buttons or links that represent different options or tasks that the user can perform. By presenting the main menu as a form, it provides a visually appealing and interactive way for users to access and interact with the various features of the application.Rate this question:
-
- 22.
Which leads you through the process of creating a table?
- A.
Wizard
- B.
Assistant
- C.
Relation
- D.
Coach
Correct Answer
A. WizardExplanation
A wizard is a software tool that guides users step by step through a process. In the context of creating a table, a wizard would provide a series of prompts and options to help the user define the table's structure, including specifying the columns, data types, and any constraints or relationships. The wizard simplifies the process by breaking it down into manageable steps and providing clear instructions, making it easier for users to create a table without needing in-depth knowledge of the underlying database system.Rate this question:
-
- 23.
Which data type is better to use for storing the price of an item?
- A.
Text
- B.
AutoNumber
- C.
Number
- D.
Currency
Correct Answer
D. CurrencyExplanation
The data type "Currency" is better to use for storing the price of an item because it is specifically designed for storing monetary values. It provides more precision and accuracy when dealing with decimal numbers, ensuring that calculations involving prices are more accurate. Additionally, the "Currency" data type also includes built-in formatting options for displaying currency symbols, decimal places, and thousand separators, making it easier to present the price in a standardized and user-friendly manner.Rate this question:
-
- 24.
Which do you click to display the table’s primary key and indexes in a separate window?
- A.
Indexes button
- B.
Primary key button
- C.
View datasheet button
- D.
View design button
Correct Answer
A. Indexes buttonExplanation
To display the table's primary key and indexes in a separate window, you would click on the "indexes button." This button allows you to view and manage the indexes and primary key of the table, providing a separate window specifically for this purpose.Rate this question:
-
- 25.
After right click the field selector button, which do you choose to delete a field in design view?
- A.
Delete field
- B.
Delete rows
- C.
Remove field
- D.
Remove rows
Correct Answer
B. Delete rowsExplanation
In design view, after right-clicking the field selector button, the option to delete a field is "delete rows". This option allows the user to remove a specific field from the design view by deleting the corresponding row associated with that field.Rate this question:
-
- 26.
Which tool is used to generate printout of a table’s structure?
- A.
Analyzer
- B.
Designer
- C.
Documenter
- D.
Generator
Correct Answer
C. DocumenterExplanation
The tool used to generate a printout of a table's structure is called the Documenter. This tool is specifically designed to document the structure of a table, providing a detailed overview of its columns, data types, constraints, and other relevant information. By using the Documenter, users can easily generate a printable document that serves as a reference for the table's structure, making it easier to understand and analyze the database design.Rate this question:
-
- 27.
Which of the following is not a legitimate section for form objects?
- A.
Form detail
- B.
Group header
- C.
Form header
- D.
Page footer
Correct Answer
B. Group headerExplanation
The group header is not a legitimate section for form objects. In a form, the group header is typically used to provide a title or label for a group of related fields. It is not meant to contain form objects such as input fields or buttons. The other sections mentioned (form detail, form header, and page footer) are commonly used in forms to organize and display form data and controls.Rate this question:
-
- 28.
The basic elements of a form or a report are called:
- A.
Controls
- B.
Objects
- C.
Windows
- D.
Properties
Correct Answer
A. ControlsExplanation
Controls are the basic elements of a form or a report. They are used to collect and display data, such as text boxes, buttons, checkboxes, and drop-down menus. Controls allow users to interact with the form or report and input or retrieve information. They can be customized with various properties, such as size, color, and font, to meet the specific design and functionality requirements of the form or report. Therefore, controls are the correct answer as they are the fundamental components that make up a form or a report.Rate this question:
-
- 29.
Which control types is most often associated with a bound control?
- A.
Command button
- B.
Label
- C.
Text box
- D.
List box
Correct Answer
C. Text boxExplanation
A bound control is typically associated with a text box. A bound control is used to display data from a data source, and a text box is commonly used for this purpose. It allows the user to view and edit the data in a convenient and user-friendly manner. Other control types like command button, label, and list box are not typically used as bound controls.Rate this question:
-
- 30.
Which control type do you use to create a calculated control?
- A.
Command button
- B.
Combo box
- C.
Text box
- D.
List box
Correct Answer
C. Text boxExplanation
A text box control is used to create a calculated control. This is because a text box allows the user to input and display text, which can be used to perform calculations. By entering formulas or expressions into the text box, the control can calculate and display the desired result. Other control types such as command buttons, combo boxes, and list boxes do not have the capability to perform calculations.Rate this question:
-
- 31.
Which is not a view for displaying a report object?
- A.
Datasheet view
- B.
Design view
- C.
Print preview
- D.
Layout preview
Correct Answer
A. Datasheet viewExplanation
Datasheet view is not a view for displaying a report object. Datasheet view is typically used for displaying and manipulating data in a tabular format, similar to a spreadsheet. However, when it comes to displaying a report object, the options are Design view, Print preview, and Layout preview. In Design view, you can customize the layout and design of the report. Print preview allows you to see how the report will look when printed. Layout preview provides a preview of the report with actual data.Rate this question:
-
- 32.
The report footer section is most useful for displaying:
- A.
Grand totals
- B.
Column headings
- C.
Subtotals
- D.
Page numbers
Correct Answer
C. SubtotalsExplanation
The report footer section is most useful for displaying subtotals. This section allows for the calculation and display of subtotals for different sections or categories within the report. It is typically used to summarize and provide a breakdown of the data presented in the report.Rate this question:
-
- 33.
Which function can not be used for calculated controls in a report?
- A.
SUM
- B.
AVG
- C.
MPT
- D.
COUNT
Correct Answer
C. MPTExplanation
The MPT function cannot be used for calculated controls in a report. This is because MPT is not a valid function in Access or any other commonly used database software. The SUM, AVG, and COUNT functions, on the other hand, are commonly used for calculating totals, averages, and counts in reports.Rate this question:
-
- 34.
Which setting you must modify to print a report using letterhead?
- A.
Group
- B.
Margin
- C.
Section
- D.
Orientation
Correct Answer
B. MarginExplanation
To print a report using letterhead, you must modify the "Margin" setting. This setting allows you to adjust the space between the content and the edges of the page, ensuring that the letterhead is properly positioned on the printed report. By adjusting the margins, you can ensure that the letterhead is included in the printed output and appears in the desired location on the page.Rate this question:
-
- 35.
In the datasheet formatting dialogue box, which is not an option in the border and line styles drop down list box?
- A.
Datasheet border
- B.
Datasheet underline
- C.
Column Header underline
- D.
Vertical gridline
Correct Answer
A. Datasheet borderExplanation
In the datasheet formatting dialogue box, the option "datasheet border" is not available in the border and line styles drop down list box. This means that users cannot select this option to apply a border style to the datasheet.Rate this question:
-
- 36.
Which is not an option for customizing a datasheet window?
- A.
Change one row’s height
- B.
Hide one column
- C.
Change one column’s width
- D.
Freeze one column
Correct Answer
A. Change one row’s heightExplanation
The option "change one row's height" is not available for customizing a datasheet window. This means that users cannot adjust the height of a single row in the datasheet window. They can, however, hide columns, change the width of columns, and freeze columns as options for customization.Rate this question:
-
- 37.
Which is not a command that is selectable from right click menu of a field column?
- A.
Hide columns
- B.
Unhide columns
- C.
Freeze columns
- D.
Sort descending
Correct Answer
B. Unhide columnsExplanation
The option "Unhide columns" is not a command that is selectable from the right-click menu of a field column. This option is typically used to display columns that have been previously hidden.Rate this question:
-
- 38.
What do you call the process of restricting the display of records in a table to those matching a particular criterion?
- A.
Filtering
- B.
Restricting
- C.
Sorting
- D.
Sifting
Correct Answer
A. FilteringExplanation
Filtering is the process of restricting the display of records in a table to only those that match a specific criterion. This involves applying a set of conditions or rules to the data in order to narrow down the results and display only the relevant information. Filtering allows users to focus on specific subsets of data that meet their requirements, making it easier to analyze and work with large datasets.Rate this question:
-
- 39.
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
- A.
Referential integrity is enforced
- B.
Referential integrity isn’t enforced
- C.
An inner join is set
- D.
An outer join is set
Correct Answer
A. Referential integrity is enforcedExplanation
The appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line indicates that referential integrity is enforced. This means that the relationship between the two entities in the relationship line is maintained and any changes made to the primary key of one entity will be reflected in the foreign key of the other entity. This ensures that there are no orphaned records or inconsistencies in the database.Rate this question:
-
- 40.
Which of the following is not an action query?
- A.
Add
- B.
Delete
- C.
Make-table
- D.
Update
Correct Answer
A. AddExplanation
The given question asks to identify the option that is not an action query. An action query is a type of query that modifies the data in a database. The options "delete," "make-table," and "update" are all examples of action queries as they involve deleting data, creating a new table, and updating existing data, respectively. However, the option "add" is not an action query. It is likely referring to the "add" command or function, which is typically used to insert new records into a database, rather than modifying existing data.Rate this question:
-
- 41.
In MS Access, Text Data type may contain maximum character of:
- A.
255 Character
- B.
256 Character
- C.
1064 Character
- D.
No Limit
Correct Answer
A. 255 CharacterExplanation
The maximum character limit for the Text Data type in MS Access is 255.Rate this question:
-
- 42.
Which of the following is not a valid Data Type in MS Access?
- A.
Memo
- B.
Picture
- C.
Currency
- D.
AutoNumber
Correct Answer
B. PictureExplanation
The data types in MS Access are used to define the type of data that can be stored in a field. The Memo data type is used to store large amounts of text, Currency is used to store monetary values, and AutoNumber is used to automatically generate a unique number for each record. However, Picture is not a valid data type in MS Access. MS Access does not have a specific data type for storing pictures, but instead, pictures can be stored as objects or as a path to the picture file.Rate this question:
-
- 43.
In MS Access, “Hyperlink” Data Type can store:
- A.
Web Address
- B.
Email Address
- C.
Path of a File
- D.
All of Above
Correct Answer
D. All of AboveExplanation
The "Hyperlink" data type in MS Access can store all of the above types of data, including web addresses, email addresses, and paths of files. This means that you can use the "Hyperlink" data type to store any type of hyperlink data in your Access database, making it a versatile option for storing and managing various types of links.Rate this question:
-
- 44.
Which of the following data type is used to store logical value in MS Access?
- A.
True/False
- B.
On/Off
- C.
Yes/No
- D.
All of Above
Correct Answer
C. Yes/NoExplanation
The Yes/No data type is used to store logical values in MS Access. This data type allows for the storage of two possible values, either Yes or No, representing true or false, on or off, or any other logical condition. It is commonly used for fields that require a binary response, such as a checkbox or a toggle switch.Rate this question:
-
- 45.
The appropriate Data Type to store Time in MS Access?
- A.
Date/Time
- B.
Time Only
- C.
Time
- D.
Time cannot be stored
Correct Answer
A. Date/TimeExplanation
The appropriate data type to store time in MS Access is Date/Time. This data type allows for the storage of both date and time values in a single field. It is commonly used when there is a need to track and manipulate time-related data accurately, such as recording the time of events or appointments. By using the Date/Time data type, MS Access can handle various time calculations and comparisons efficiently.Rate this question:
-
- 46.
In MS Access “Lookup Wizard” is used to
- A.
To select from previous values
- B.
To select values from Excel Sheet
- C.
To select value from another table
- D.
Not a valid Data Type
Correct Answer
C. To select value from another tableExplanation
The "Lookup Wizard" in MS Access is used to select a value from another table. This feature allows users to create a field in a table that can be used to look up values from another table, making it easier to maintain data consistency and avoid data entry errors. By using the Lookup Wizard, users can easily select a value from a predefined list of values in another table, rather than manually entering the value each time.Rate this question:
-
- 47.
Which of the following Data Type is used to store picture in MS Access?
- A.
Picture
- B.
OLE Object
- C.
Memo
- D.
Picture cannot be stored
Correct Answer
B. OLE ObjectExplanation
The correct answer is OLE Object. In MS Access, the OLE Object data type is used to store pictures. OLE stands for Object Linking and Embedding, which allows objects such as pictures to be linked or embedded within a database. This data type can store various types of data, including pictures, audio, and video files. The OLE Object data type is commonly used when working with multimedia files in MS Access.Rate this question:
-
- 48.
In MS Access, which data type is appropriate to store large text and numbers?
- A.
Text
- B.
Memo
- C.
OLE
- D.
Large Text
Correct Answer
B. MemoExplanation
The correct answer is Memo. In MS Access, the Memo data type is appropriate for storing large text and numbers. Memo fields can hold up to 65,536 characters of text, making it suitable for storing lengthy descriptions, notes, or other large amounts of text data. Additionally, Memo fields can also store numeric values, allowing for the storage of large numbers in the database. Therefore, Memo is the most appropriate data type for storing both large text and numbers in MS Access.Rate this question:
-
- 49.
In MS Access, OLE Object Data type can store:
- A.
Microsoft Word documents
- B.
Microsoft Excel spreadsheets
- C.
Sounds
- D.
All of the Above
Correct Answer
D. All of the AboveExplanation
The OLE Object Data type in MS Access can store various types of data including Microsoft Word documents, Microsoft Excel spreadsheets, and sounds. Therefore, the correct answer is "All of the Above".Rate this question:
-
- 50.
In MS Access, AutoNumber Data Type:
- A.
Can be Sequential
- B.
Can be Random
- C.
Can be Edited
- D.
Only A & B
Correct Answer
D. Only A & BExplanation
The correct answer is "Only A & B". In MS Access, the AutoNumber data type can be sequential, meaning that it assigns a unique number to each record in ascending order. It can also be random, meaning that it assigns a unique number to each record in a random order. However, the AutoNumber data type cannot be edited, as it is automatically generated by the system.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 19, 2024Quiz Edited by
ProProfs Editorial Team -
Mar 24, 2012Quiz Created by
Michael_laguisma
Back to top