MS Access - Final Exam 1
MS Access - Final Exam created by Mr. Mike Laguisma
Questions and Answers
- 1.
Type description here
- 2.
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. Forms are used to input, edit, and view data in a database. Tables store the actual data, while queries are used to retrieve and manipulate the data. By using tables and queries, users can design a form that allows them to interact with the data in a structured and organized manner.Rate this question:
-
- 3.
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 field is used to improve the performance and efficiency of searching, sorting, and filtering data in a database table. It stores a sorted copy of the table's data, allowing for faster retrieval and sorting based on the values in that field. By specifying an index field, the table's data can be organized and displayed in a specific order, such as ascending or descending.Rate this question:
-
- 4.
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 represents a specific location within the table or grid, known as a cell. In this context, a cell is used to store and display data, making it the correct answer to the question.Rate this question:
-
- 5.
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 the tool used to create a query object. This wizard provides a user-friendly interface that allows users to easily define the criteria and parameters for their query. It simplifies the process of creating a query by guiding users through the necessary steps and providing options for selecting tables, fields, and conditions. By using the Simple query wizard, users can quickly and efficiently create a query object without needing to have in-depth knowledge of SQL or database management.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 used to speed up data search. When data is indexed, a separate data structure is created that allows for faster retrieval of specific data items. This is because the index provides a way to quickly locate the desired data without having to search through the entire table or database. By using indexing, the time taken to search for data is significantly reduced, improving the overall performance and efficiency of data retrieval operations.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
All of the above is the correct answer because Access supports multiple data types including Number, Text, and Currency. Number data type is used for storing numeric values, Text data type is used for storing alphanumeric values, and Currency data type is used for storing monetary values. Therefore, all three options are valid data types in Access.Rate this question:
-
- 8.
How many relations may exist between tables in databases?
- A.
4
- B.
3
- C.
2
- D.
1
Correct Answer
B. 3Explanation
In a database, relations are established between tables through keys. The number of relations that may exist between tables depends on the number of keys present. Since a table can have multiple keys, there can be multiple relations between tables. Therefore, the correct answer is 3, indicating that there can be multiple relations between tables in a database.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 considered the standard language for interacting with databases.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 both numbers and hyphens, which are not mathematical operations. Therefore, it is better to use the Text data type to store this phone number format, as it allows for the inclusion of non-numeric characters and preserves the specific format of the phone number.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 in database management systems to describe a collection of records that match the parameters of a query. It is a dynamic set of data that is generated based on the conditions specified in the query. Unlike a static set of records, a dynaset can be updated in real-time as new records that meet the query criteria are added or existing records are modified. Therefore, a dynaset is the correct term to refer to a collection of records matching the parameters of a query.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 would be used to select employees who earn more than $5000 a month. This query would involve specifying the necessary conditions and selecting the appropriate fields to display the desired information.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 sorted based on their zipcode first, then within each zipcode, the records will be sorted based on their lastname, and finally within each lastname, the records will be sorted based on their 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*'" will return only those addresses that begin with the letter "K". The asterisk (*) is a wildcard character that represents any number of characters, so when it is used after the letter "K", it will match any address that starts with "K" followed by any number of characters. Therefore, this criteria will only select addresses that begin with "K".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 ('?') in the criteria represent wildcard characters that can match any single character. Therefore, the criteria "O??icer" would match any position that starts with 'O', followed by any two characters, and then followed by "icer". Since "Officer" does not have any two characters between 'O' and "icer", it does not match the criteria.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 employees. By using the appropriate SQL syntax and functions, such as AVG(), the average salary of the employees can be calculated and returned as the result of the query.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 query will display all customers with CustID from 11 to 99. The query specifies a condition where the CustID should be greater than 10 and less than 100. Therefore, it will retrieve all customer records that have a CustID between 11 and 99, excluding 10 and 100.Rate 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
Setting the format property to "yyyy/mm/dd" allows the date field to store dates in the specified format of "2002/10/17". This means that when a date is entered into the field, it will be displayed and stored in the format of year/month/day. This ensures consistency and standardization in the way dates are entered and stored in the field. The input mask property, on the other hand, is used to control the input format while entering the date, but it does not affect the way the date is stored or displayed. Therefore, the correct answer is setting the format property to "yyyy/mm/dd".Rate this question:
-
- 20.
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 interface element that allows users to navigate through different sections or functions of the application. It typically consists of buttons or links that represent different options or tasks. By presenting the main menu as a form, users can easily interact with the application and access the desired functionalities.Rate this question:
-
- 21.
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 tool or feature in software applications that guides users through a step-by-step process to complete a task. In the context of creating a table, a wizard would provide a series of prompts and options to help the user define the table structure, specify column names and data types, and set any necessary constraints or properties. By following the prompts and making selections, the user can easily create a table without needing to manually write the underlying code or query. Therefore, a wizard is the correct answer as it leads the user through the process of creating a table.Rate this question:
-
- 22.
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
Currency is the better data type to use for storing the price of an item because it is specifically designed to handle monetary values. It provides built-in formatting and precision for currency calculations, ensuring accurate representation of prices with decimal places. Using the Currency data type also allows for easier integration with financial systems and simplifies calculations involving currency conversions or monetary operations.Rate this question:
-
- 23.
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 need to click on the "indexes button". This button allows you to view and manage the indexes associated with the table, which are used to improve database performance and enforce data integrity. By clicking on this button, you can access a separate window that displays the primary key and other indexes defined for the table.Rate this question:
-
- 24.
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
To delete a field in design view after right-clicking the field selector button, the correct option is "delete rows." This option allows you to remove the entire row associated with the selected field, effectively deleting the field from the design view. The other options listed, such as "delete field," "remove field," and "remove rows," do not accurately describe the action of deleting a field in design view.Rate this question:
-
- 25.
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 the Documenter. This tool allows users to create a detailed documentation of the table's structure, including information such as column names, data types, constraints, and relationships. It is commonly used in database management systems to provide a visual representation of the table's design, making it easier for users to understand and analyze the structure of the table.Rate this question:
-
- 26.
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 form detail section is used to display the main content of the form, the form header section is used to display information about the form, and the page footer section is used to display information at the bottom of each page. However, there is no specific section called the group header in a form.Rate this question:
-
- 27.
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, and they provide functionality to interact with the user. Examples of controls include text boxes, buttons, checkboxes, and dropdown lists. These controls can be used to input data, perform calculations, and present information in a structured manner. Therefore, the correct answer is Controls.Rate this question:
-
- 28.
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 text box is most often associated with a bound control because it allows the user to input and edit text, which can be bound to a data source. This means that the data entered in the text box can be stored and retrieved from a database or other data storage system. Other controls like command buttons, labels, and list boxes do not typically have this capability to directly interact with data sources.Rate this question:
-
- 29.
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 is used to create a calculated control. This is because a text box allows the user to enter and display text or numerical values. By using formulas or expressions, the text box can perform calculations and display the result as a calculated control. This makes it suitable for creating calculated controls in a user interface.Rate this question:
-
- 30.
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 editing data in a tabular format, similar to a spreadsheet. It is commonly used in database applications for data entry and data manipulation. However, when it comes to displaying a report object, options like Design view, Print preview, and Layout preview are more suitable as they provide better control over the appearance and formatting of the report.Rate this question:
-
- 31.
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 is typically used to display calculations or summaries of data that are relevant to the entire report, such as the total sales for a certain period or the average score of a group. By placing subtotals in the report footer, it allows the reader to easily see and understand the overall calculations or summaries of the data presented in the report.Rate this question:
-
- 32.
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 function MPT cannot be used for calculated controls in a report.Rate this question:
-
- 33.
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. By adjusting the margins, you can ensure that the letterhead is properly aligned and positioned on the page when printing the report. This allows for a professional and polished appearance when printing reports with letterhead.Rate this question:
-
- 34.
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown 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 dropdown list box. This means that users cannot select a specific border style for the entire datasheet.Rate this question:
-
- 35.
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 to 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 to make it larger or smaller. However, they can still customize the window by hiding a column, changing a column's width, or freezing a column.Rate this question:
-
- 36.
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 command "Unhide columns" is not selectable from the right-click menu of a field column. This command is used to reveal any hidden columns in a spreadsheet or table. The other options, "Hide columns", "Freeze columns", and "Sort descending", are commonly available commands that can be selected from the right-click menu of a field column.Rate this question:
-
- 37.
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 meet a specific criterion. It involves selecting and displaying only the relevant data that matches the specified condition, while hiding or excluding the rest of the records. This is commonly used to narrow down a large dataset and focus on specific information that meets certain criteria or conditions.Rate this question:
-
- 38.
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 there is a relationship between the tables involved and certain rules are in place to maintain the consistency and validity of the data. These symbols represent the cardinality of the relationship, with 1 indicating a one-to-one relationship and the infinity symbol indicating a one-to-many relationship. By enforcing referential integrity, the database ensures that any changes made to the data in one table are consistent with the data in related tables.Rate this question:
-
- 39.
Which of the following is not an action query?
- A.
Add
- B.
Delete
- C.
Make-table
- D.
Update
Correct Answer
A. AddExplanation
The action queries in databases are used to modify or manipulate data, such as adding, deleting, or updating records. The "add" query is an action query as it is used to add new records to a table. Therefore, it is not the correct answer.Rate this question:
-
- 40.
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 correct answer is 255 characters. In MS Access, the Text data type is limited to a maximum of 255 characters. This means that any text entered into a field with this data type cannot exceed 255 characters in length.Rate this question:
-
- 41.
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
In MS Access, the Picture data type does not exist. The other three options (Memo, Currency, and AutoNumber) are valid data types in MS Access.Rate this question:
-
- 42.
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 options, including web addresses, email addresses, and paths of files. This means that the Hyperlink data type is versatile and can be used to store different types of data related to links and addresses.Rate this question:
-
- 43.
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 data type used to store logical values in MS Access is "Yes/No". This data type allows for the storage of boolean values, where "Yes" represents true and "No" represents false. It is commonly used for fields that require a binary choice, such as whether a certain condition is met or not.Rate this question:
-
- 44.
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. It is commonly used when there is a need to store specific time information, such as recording the time of an event or tracking the duration of a task. The Date/Time data type in MS Access provides the necessary functionality to accurately store and manipulate time values.Rate this question:
-
- 45.
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 lookup field in a table that retrieves data from a related table. It provides a convenient way to establish relationships between tables and ensure data integrity by only allowing values that exist in the related table to be selected.Rate this question:
-
- 46.
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 users to create and manipulate objects from different applications. By using the OLE Object data type, users can insert and store pictures within an Access database, making it convenient to manage and retrieve images when needed. The Memo data type is used for storing large amounts of text, while the Picture data type does not exist in MS Access.Rate this question:
-
- 47.
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" because it is the appropriate data type in MS Access to store large text and numbers. The Memo data type can store up to 65,536 characters of text, making it suitable for storing large amounts of text data. Additionally, it can also store numbers, making it versatile for storing both text and numeric data.Rate this question:
-
- 48.
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 is capable of storing various types of data, including Microsoft Word documents, Microsoft Excel spreadsheets, and sounds. Therefore, the correct answer is "All of the Above" as it encompasses all the mentioned options.Rate this question:
-
- 49.
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
A. Datasheet viewExplanation
Datasheet view is a view commonly used in database applications to interact with tables or queries, where data is displayed in a spreadsheet-like format. It allows users to view and manipulate individual records and fields directly, but it is not typically used for interacting with form objects, which are designed for data entry, presentation, and interaction in a more structured manner.Rate this question:
-
- 50.
In MS Access, AutoNumber Data Type
- A.
Can be Sequential
- B.
Can be Random
- C.
Can be Edited
- D.
Can only be sequential or random
Correct Answer
D. Can only be sequential or randomExplanation
The correct answer is "Only A & B" because in MS Access, the AutoNumber data type can be set to generate sequential numbers or random numbers. It cannot be edited manually as it is automatically generated by the system. Therefore, options C and D are incorrect.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 13, 2024Quiz Edited by
ProProfs Editorial Team -
Dec 09, 2017Quiz Created by
Professor Bridges
Back to top