OCP A - Computer Applications 1 Access 2007
Instructions: You will have 45 minutes to complete this portion of the Access 2007 test. Once this portion is completed, print your certificate and give it to your instructor. If you have not already done some, complete the project portion of the Access 2007 test (obtain from your instructor). GOOD LUCK!
Questions and Answers
- 1.
Access is a DBBS program.
- A.
T
- B.
F
Correct Answer
B. FExplanation
The statement "Access is a DBBS program" is false. Access is not a DBBS program.Rate this question:
-
- 2.
When you open an existing database, the Navigation PAne opens on the left side of the screen.
- A.
T
- B.
F
Correct Answer
A. TExplanation
When you open an existing database, the Navigation Pane opens on the left side of the screen. This statement is true. The Navigation Pane is a feature in database software that allows users to easily navigate and access different objects within the database, such as tables, queries, forms, and reports. When opening an existing database, the Navigation Pane is typically displayed on the left side of the screen, providing a convenient way for users to browse and select the desired objects within the database.Rate this question:
-
- 3.
The database object called Macro displays data from one or more tables or queries in a format similar in appearance to a paper form.
- A.
T
- B.
F
Correct Answer
B. FExplanation
The statement is false because the database object called Macro does not display data in a format similar to a paper form. Macros are used to automate tasks and perform actions within a database, such as running queries or opening forms. They do not have a visual representation or display data in any specific format.Rate this question:
-
- 4.
A record is an incomplete set of data.
- A.
T
- B.
F
Correct Answer
B. FExplanation
The statement "A record is an incomplete set of data" is false. A record is a complete set of data that represents a single entity or object. It typically includes multiple fields or attributes that provide information about that entity. Therefore, the correct answer is False.Rate this question:
-
- 5.
A field selector appears at the top of each column in a table and contains the field name.
- A.
T
- B.
F
Correct Answer
A. TExplanation
The statement is true because a field selector is indeed present at the top of each column in a table. This field selector displays the name of the field that corresponds to that column, allowing users to easily identify and select the specific field they want to interact with or view in the table.Rate this question:
-
- 6.
When you create a blank database, Access creates the first tables for you and gives it the name Database1.
- A.
T
- B.
F
Correct Answer
B. FExplanation
When you create a blank database in Access, it does not automatically create any tables for you. You have to manually create tables and name them yourself. Therefore, the statement is false.Rate this question:
-
- 7.
A field's access type determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text.
- A.
T
- B.
F
Correct Answer
B. FExplanation
The statement is false because a field's access type does not determine the kind of data that can be entered in the field. The access type determines the level of access or permission that users have to the field, such as read-only or read-write access. The type of data that can be entered in a field is determined by the field's data type, not its access type.Rate this question:
-
- 8.
Left-aligned field values are usally Number fields.
- A.
T
- B.
F
Correct Answer
B. FExplanation
Left-aligned field values are not necessarily Number fields. Field values can be left-aligned or right-aligned regardless of their data type. The alignment of field values is determined by the formatting settings applied to the specific field. Therefore, the statement is false.Rate this question:
-
- 9.
In Design view, you can add, delete, and make changes to the way that fields store data.
- A.
T
- B.
F
Correct Answer
A. TExplanation
In Design view, users have the ability to add, delete, and modify the way fields store data. This means that they can create new fields, remove existing ones, and make changes to the data type, format, and other properties of the fields. Design view allows users to have full control over the structure and layout of their data, making it a powerful tool for customization and optimization.Rate this question:
-
- 10.
A field property discribes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store or the allowable values that you can enter in the field.
- A.
T
- B.
F
Correct Answer
A. TExplanation
The statement is true. A field property provides additional information about a field in a database beyond its basic data type. It can specify the maximum number of characters that can be stored in the field or define the range of allowable values that can be entered into the field. Field properties help to ensure data integrity and provide more detailed descriptions of the field's contents.Rate this question:
-
- 11.
A _____ selector appears to the left of the first field for each record.
- A.
Record
- B.
Column
- C.
Field
- D.
Datasheet
Correct Answer
A. RecordExplanation
A record selector appears to the left of the first field for each record. This selector allows the user to select or highlight a specific record in a dataset. It is typically represented by a small box or arrow that can be clicked on to select the entire row or record.Rate this question:
-
- 12.
When resizing a column, selecting _____ automatically resizes the column to the best width for the data contained in the column.
- A.
Best fit
- B.
Best column
- C.
Best data
- D.
Best selector
Correct Answer
A. Best fitExplanation
When resizing a column, selecting "best fit" automatically resizes the column to the best width for the data contained in the column. This means that the column width will be adjusted in a way that allows all the data in the column to be displayed without truncation or excessive empty space. By selecting "best fit," the column width is optimized to ensure the most efficient and visually appealing display of the data.Rate this question:
-
- 13.
In _____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.
- A.
Datasheet view
- B.
Column view
- C.
Edit view
- D.
Freeze view
Correct Answer
A. Datasheet viewExplanation
In Datasheet view, you can rearrange the order of the fields in a datasheet by dragging them to a new location. This view allows you to see the data in a tabular format similar to a spreadsheet, where each field is represented by a column. By dragging the fields, you can easily change their positions and customize the layout of the datasheet according to your preference. This feature provides flexibility and ease of use when working with large amounts of data in a database.Rate this question:
-
- 14.
Before printing a datasheet, you should view it in _____ so you can check the print settings.
- A.
Print Preview
- B.
Datasheet view
- C.
Black and white
- D.
Zoom mode
Correct Answer
A. Print PreviewExplanation
Before printing a datasheet, it is important to view it in Print Preview so that you can check the print settings. Print Preview allows you to see how the datasheet will look when printed, including the layout, formatting, and any potential issues that may arise. By reviewing the datasheet in Print Preview, you can ensure that the print settings are correct and make any necessary adjustments before actually printing the document. This helps to avoid wasting paper and ink, and ensures that the final printed document meets your requirements.Rate this question:
-
- 15.
If you make changes to the layout of a datasheet and try to close the table, Access will _____.
- A.
Prompt you to save your changes
- B.
Automactically save your changes
- C.
Give you an error message
- D.
None of the above
Correct Answer
A. Prompt you to save your changesExplanation
If you make changes to the layout of a datasheet and try to close the table, Access will prompt you to save your changes. This is because Access recognizes that modifications have been made to the datasheet and it wants to ensure that the changes are saved before closing the table.Rate this question:
-
- 16.
_____ a database rearranges how the database is stored on a disk and optimizes the performance of the database.
- A.
Crushing
- B.
Fragmenting
- C.
Compacting
- D.
Resizing
Correct Answer
C. CompactingExplanation
Compacting a database involves rearranging how the database is stored on a disk and optimizing its performance. This process helps to eliminate fragmentation and reclaim unused space, resulting in improved efficiency and faster access to data. By compacting the database, the storage utilization is optimized, and the overall performance of the database is enhanced.Rate this question:
-
- 17.
Access compacts and repairs a database _____.
- A.
During one process
- B.
One after the other
- C.
At least one day apart
- D.
Every time you open the program
Correct Answer
A. During one processExplanation
Access compacts and repairs a database during one process, meaning that it performs both actions at the same time. This helps to optimize the database by reducing its size and fixing any issues or errors that may have occurred. By compacting and repairing the database during one process, it ensures that the database remains efficient and functional.Rate this question:
-
- 18.
You can close Access by clicking the Close button on the _____.
- A.
Staus bar
- B.
Toolbar
- C.
Scroll bar
- D.
Title bar
Correct Answer
D. Title barExplanation
The title bar of a window typically contains the name or title of the application or document being viewed. It also includes the minimize, maximize, and close buttons. Therefore, it is logical to conclude that the correct answer is the title bar, as clicking the close button on the title bar is a common way to close an application or document.Rate this question:
-
- 19.
FIGURE 1 - 1Access case 1 - 1 Jonathan is preparing a dtabase of his favorite foods which is shown in Figure 1 - 1. It is his first time using a datbase and he is becoming familar with the terminolgy.Jonathan will be sorting the database on "Specialty," which is a _____.
- A.
Field selector
- B.
Database selector
- C.
Row selector
- D.
Datasheet selector
Correct Answer
A. Field selectorExplanation
In this question, Jonathan is preparing a database of his favorite foods. He wants to sort the database based on the "Specialty" field. A field selector is a tool or feature in a database program that allows users to select and manipulate specific fields or columns of data. Therefore, the correct answer in this case is "field selector" as Jonathan will be using it to sort the database based on the "Specialty" field.Rate this question:
-
- 20.
The word "Italian" is an example of a _____.
- A.
Field
- B.
Field value
- C.
Field name
- D.
Field selector
Correct Answer
B. Field valueExplanation
The word "Italian" is an example of a field value because it represents a specific value within a field. In this context, the field could be a category or attribute, such as "nationality" or "language", and "Italian" would be the specific value assigned to that field.Rate this question:
-
- 21.
Access Case 1 - 2Chloe's boss has asked her to make some changes to the layout of the datasheet. She has never done this before, and is learning as she goes along.Once Chloe makes the changes in the layout of the datasheet, the edits are saved _____.
- A.
Only if she saves them
- B.
Automactically by Access
- C.
With a generic name
- D.
None of the above
Correct Answer
A. Only if she saves themExplanation
The edits made by Chloe in the layout of the datasheet will only be saved if she manually saves them. The statement implies that there is no automatic saving feature in Access, and the edits will not be saved with a generic name or any other method.Rate this question:
-
- 22.
Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will _____.
- A.
Click the row selector and drag the row to the new location
- B.
Click the field selector and drag the column to a new location
- C.
Copy and append the column into its new location
- D.
Freeze the columns and then transfer the data manually
Correct Answer
B. Click the field selector and drag the column to a new location -
- 23.
To save a table, click the Save button on the _____.
- A.
Help Toolbar
- B.
Home tab
- C.
Quick Access Toolbar
- D.
Title bar
Correct Answer
C. Quick Access ToolbarExplanation
The Quick Access Toolbar is a customizable toolbar located at the top left corner of the screen in many Microsoft Office applications. It provides easy access to commonly used commands, such as saving a table. Therefore, to save a table, one should click the Save button on the Quick Access Toolbar.Rate this question:
-
- 24.
The _____ is the field that contains a unique field value for each record in the table.
- A.
Unique indentifier key
- B.
Primary key
- C.
Alphanumeric key
- D.
Field starter key
Correct Answer
B. Primary keyExplanation
The primary key is a field in a table that contains a unique value for each record. It is used to uniquely identify each record in the table and ensure data integrity. The primary key is essential for establishing relationships between tables and enforcing referential integrity. It is typically created using a single field or a combination of fields that uniquely identify each record.Rate this question:
-
- 25.
In Design View, the _____ appears in the top half of the Table window.
- A.
Design grid
- B.
Field Properties pane
- C.
External Data Wizard
- D.
Report Layout Toolbar
Correct Answer
A. Design gridExplanation
In Design View, the design grid appears in the top half of the Table window. The design grid is where you can define the structure and layout of the table, including adding and arranging fields, setting data types, and specifying field properties. It provides a visual representation of the table's structure and allows for easy customization and organization of the table's fields.Rate this question:
-
- 26.
To rename a field, edit the field name in the _____ and press the Tab key.
- A.
Layout pane
- B.
Datasheet selector
- C.
Tools group
- D.
Design grid
Correct Answer
D. Design gridExplanation
In order to rename a field, you need to edit the field name in the design grid and then press the Tab key. The design grid is the area where you can make changes to the structure and layout of a form or report in a database. By editing the field name in the design grid and pressing the Tab key, you can easily rename the field and move on to the next field for editing or modification.Rate this question:
-
- 27.
The _____ sets the number of characters you can store in a Text, Number, or AutoNumber field.
- A.
Field Size property
- B.
Required property
- C.
Field Length property
- D.
Data type
Correct Answer
A. Field Size propertyExplanation
The Field Size property sets the number of characters you can store in a Text, Number, or AutoNumber field. This property determines the maximum length of the data that can be entered into the field. By setting the Field Size property, you can control the amount of storage space allocated for the field and ensure that the data entered does not exceed the specified limit.Rate this question:
-
- 28.
FIGURE 2 -1Access Case 2 -1Kristin had put together a list of job candidates for various positions within her company. In Figure 2 - 1, she needs to confirm the data type for one column and also set athe primary key.The Appointment column has field values of the _____ data type.
- A.
Date/Time
- B.
Currency
- C.
Number
- D.
Text
Correct Answer
A. Date/TimeExplanation
In Figure 2-1, Kristin is working with a list of job candidates and needs to confirm the data type for one column and set it as the primary key. The column in question is the "Appointment" column, which contains field values related to dates and times. Therefore, the correct data type for this column would be "Date/Time."Rate this question:
-
- 29.
Access Case 2 - 2Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value. He is researching which Access properties will help him with his task.To make sure that a specific field is filled in and his data in it, Sam will use the _____ property.
- A.
Required
- B.
Must
- C.
Default
- D.
Control
Correct Answer
A. RequiredExplanation
To ensure that a specific field is filled in with data, Sam will use the "Required" property. This property will make it mandatory for users to enter a value in the field before they can proceed, ensuring that the field is not left blank.Rate this question:
-
- 30.
To set a default value that will automactically appear for some of the fields, Sam will use the _____ property.
- A.
List
- B.
Default Value
- C.
AutoNumber
- D.
Fill-in
Correct Answer
B. Default ValueExplanation
To set a default value that will automatically appear for some of the fields, Sam will use the "Default Value" property. This property allows Sam to predefine a value that will be automatically populated in the fields, saving time and ensuring consistency in data entry. By setting a default value, Sam can ensure that certain fields are always populated with the desired value unless manually changed by the user.Rate this question:
-
- 31.
Each record is made up of one or more of these.
- A.
Fields
- B.
Field name
- C.
Field selector
- D.
Field value
- E.
Record
Correct Answer
A. FieldsExplanation
The given answer "fields" is correct because it is stated that each record is made up of one or more of these. The term "fields" refers to the individual components or data elements within a record. These fields can include the field name, field selector, and field value. Therefore, "fields" is the appropriate answer as it encompasses all the mentioned components of a record.Rate this question:
-
- 32.
A complete set of data.
- A.
Fields
- B.
Field name
- C.
Field selector
- D.
Field value
- E.
Record
Correct Answer
E. RecordExplanation
The given answer "record" is correct because a record refers to a complete set of data that includes multiple fields. In a database or spreadsheet, a record represents a single instance or entry that contains all the relevant information about a particular entity or object. Each field within a record corresponds to a specific attribute or characteristic of that entity. Therefore, "record" is the appropriate term to describe a complete set of data that includes various fields.Rate this question:
-
- 33.
Used to identify the fields.
- A.
Fields
- B.
Field name
- C.
Field selector
- D.
Field value
- E.
Record
Correct Answer
B. Field nameExplanation
The term "field name" is used to identify the different fields within a record. It is a specific name given to each field in order to differentiate them from one another. By using field names, it becomes easier to reference and access specific data within a record.Rate this question:
-
- 34.
The data entered into a field.
- A.
Fields
- B.
Field name
- C.
Field selector
- D.
Field value
- E.
Record
Correct Answer
D. Field valueExplanation
The correct answer is "field value" because it refers to the actual data that is entered or stored in a specific field. In a database or form, a field value represents the information provided by the user or the data associated with a particular record. It can be a text, number, date, or any other type of data that is relevant to the field.Rate this question:
-
- 35.
Appears at the top of each column in a table and contains the field name.
- A.
Fields
- B.
Field name
- C.
Field selector
- D.
Field value
- E.
Record
Correct Answer
C. Field selectorExplanation
A field selector appears at the top of each column in a table and contains the field name. It is used to select or choose a specific field from the table. This allows users to easily identify and access the desired information within the table. The other options mentioned are not suitable because they do not accurately describe the purpose or function of the field selector.Rate this question:
-
- 36.
Specifies whether you must enter a field value in a record.
- A.
Default Value property
- B.
Description property
- C.
Field property
- D.
Required property
- E.
Format property
Correct Answer
D. Required propertyExplanation
The Required property specifies whether you must enter a field value in a record. This means that if the Required property is set to true for a particular field, it is mandatory to enter a value in that field when creating or updating a record. If the Required property is set to false, it is not necessary to enter a value in that field. Therefore, the Required property determines whether a field value is mandatory or optional.Rate this question:
-
- 37.
An optional field property that you can use to describe what to enter in the field.
- A.
Default Value property
- B.
Description property
- C.
Field property
- D.
Required property
- E.
Format property
Correct Answer
B. Description propertyExplanation
The Description property is an optional field property that allows you to provide a description or instructions on what to enter in a specific field. This property can be used to give additional clarification or guidance to users, helping them understand the purpose or format of the field. It is a helpful feature that enhances user experience and reduces confusion when filling out forms or inputting data.Rate this question:
-
- 38.
Enters the same field value in a field every time a new record is added to the table.
- A.
Default Value property
- B.
Description property
- C.
Field property
- D.
Required property
- E.
Format property
Correct Answer
A. Default Value propertyExplanation
The Default Value property allows the user to enter a specific value that will automatically populate a field every time a new record is added to the table. This ensures consistency and saves time by eliminating the need to manually enter the same value repeatedly.Rate this question:
-
- 39.
Describes a field's content beyond the field's basic data type, such as indication the number of characters the field can store.
- A.
Default Value property
- B.
Description property
- C.
Field property
- D.
Required property
- E.
Format property
Correct Answer
C. Field propertyExplanation
The Field property describes a field's content beyond the field's basic data type, such as indicating the number of characters the field can store. This property provides additional information about the field, allowing for more detailed and specific data storage and retrieval.Rate this question:
-
- 40.
Specifies how you want Access to display numbers, dates, times, and text.
- A.
Default Value property
- B.
Description property
- C.
Field property
- D.
Required property
- E.
Format property
Correct Answer
E. Format propertyExplanation
The Format property in Access specifies how you want numbers, dates, times, and text to be displayed. It allows you to define the formatting rules for these types of data in your database. By setting the Format property, you can control the appearance of data in your tables, forms, and reports, ensuring that it is presented in a consistent and easily readable manner.Rate this question:
-
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top