Simnet Group 8 Exam

9 September 2022
4.7 (114 reviews)
50 test answers

Unlock all answers in this set

Unlock answers (46)
question
Change the Navigation Pane grouping option
answer
You clicked the Nav Pane Open/Close button.
question
Add a new record to this form.
answer
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button.
question
Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)
answer
You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.
question
Go to record number 20.
answer
You clicked the Current Record Box, typed 20 in the Current Record Box, and pressed the Enter key.
question
From the current view (Datasheet view), set the Default Value property for the Classification field to Fr.
answer
In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Default Value button. Inside the Expression Builder dialog, you typed =Fr in the Expression Default Value Input input, clicked the Ok button.
question
Run the Compact & Repair tool to optimize database efficiency by compacting unused space and deleting unnecessary temporary objects.
answer
In the Database Tools Ribbon Tab in the Tools Ribbon Group, you clicked the Compact and Repair Database button.
question
Enable active content in this database.
answer
You clicked the Enable Content button.
question
Go to the previous record.
answer
You clicked the Previous Record Button.
question
A new record has been added to this form. Undo the data entry.
answer
In the application header, you clicked the Undo button.
question
Add the picture Justin to the second record.
answer
In the Access Table, you Double-Clicked the Attachment Icon. Inside the Attachments dialog, you clicked the Add... button. You clicked Justin. Inside the Choose File dialog, you clicked the Open button. Inside the Attachments dialog, you clicked the OK button.
question
From the current view, add a new Short Text field to the far right side of the table. Name the field: Description
answer
got wrong
question
Add a new table in Design view.
answer
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button.
question
From the current view (Datasheet view), change the Field Size property for the RAStudentID field to 4.
answer
In the Access Table, you right-clicked the RAStudentID column header. In the Fields Ribbon Tab in the Properties Ribbon Group, you typed 4 in the Field Size input, pressed the Enter key. Inside the Spa : Database dialog, you clicked the Yes button.
question
Delete this student record.
answer
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button, clicked the Delete button arrow. In the Delete menu, you clicked the Delete Record menu item. Inside the Spa : Database dialog, you clicked the Yes button.
question
Delete the NewDepartments table.
answer
You right-clicked the NewDepartments table. In the Right-Click menu, you clicked the Delete menu item. Inside the Spa : Database dialog, you clicked the Yes button.
question
Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
answer
You right-clicked the Navigation Pane Header, clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Tables and Related Views menu item.
question
From the current view, insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished.
answer
got wrong
question
Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: ResidentAdvisors
answer
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button. In the Access Table, you typed RA ID, typed RA ID and pressed Tab, clicked the Drop-Down Button, clicked the AutoNumber Item, and typed AutoNumber and pressed Tab. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Primary Key button. In the application header, you clicked the Save button. Inside the Save As dialog, you typed ResidentAdvisors in the Table Name: input, clicked the OK button.
question
Click the field that most likely uses the AutoNumber data type.
answer
In the Access Table, you clicked in the 2 Cell.
question
Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
answer
In the Access Table, you clicked the Input Mask property box, clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog, you clicked the dialog Close button. In the Access Table, you clicked in the StartDate Cell, clicked the Input Mask property box, and clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Short Date. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish button.
question
Go to the first record.
answer
You clicked the First Record Button.
question
Clear the sorting from this table.
answer
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Remove Sort button.
question
From the current view (Design view), change the Field Size property for the RAStudentID field to 4.
answer
In the Access Table, you clicked in the RAStudentID Cell, clicked the Field Size property box, typed 4 in the Field Size property box, and pressed the Tab key.
question
From Design view, change the data type for the ResidenceAssignment field to use a lookup list. The values in the list should include ResidenceName from the ResidenceHalls table. Items in the list should sort alphabetically by the ResidenceName field. Allow Access to hide the key column. Enforce data integrity, and do not allow deletions that would violate the integrity of records. Save the table.
answer
In the Access Table, you right-clicked the ResidentAssignment cell, clicked in the Lookup Wizard Cell, clicked the Drop-Down Button, and clicked the Lookup Wizard Item. Inside the Lookup Wizard dialog, you clicked the Next button. Inside the Lookup Wizard dialog from the Table Select list, you selected Table: ResidenceHalls. Inside the Lookup Wizard dialog, you clicked the Next button. Inside the Lookup Wizard dialog from the Available Fields list, you double-clicked the ResidenceName list item. Inside the Lookup Wizard dialog, you clicked the Next button. Inside the Lookup Wizard dialog in the 1 drop-down, you selected ResidenceName. Inside the Lookup Wizard dialog, you clicked the Next button, clicked the Next button, checked the Enable Data Integrity check box, and clicked the Finish button. Inside the Microsoft Access dialog, you clicked the Yes button.
question
Modify the width of the CourseDescription column to best fit the data.
answer
In the Access Table, you right-clicked the CourseDescription column header. In the Right Click Menu menu, you clicked the Field Width menu item. Inside the Column Width dialog, you checked the Standard Width check box, unchecked the Standard Width check box, and clicked the Best Fit button.
question
Use the Search box to begin searching for a student with the last name beginning with Car.
answer
You clicked the Search Box, typed Car in the Search Box.
question
Preview how the results of this query will look when printed when the page orientation is changed to landscape.
answer
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button.
question
Preview how the results of this table will look when printed. Change the preview options to show two pages at once.
answer
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Zoom Ribbon Group, you clicked the Two Pages button.
question
Create a new table in Datasheet view. Save it with the name: Degrees
answer
got wrong
question
Use the Enter Field Properties dialog to rename the ID field to DegreeName and change the caption to Degree Name. Do not add a description.
answer
In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Name & Caption button. Inside the Enter Field Properties dialog, you typed DegreeName in the Name: input, typed Degree Name in the Caption: input, and clicked the OK button.
question
Enter the following information in the form in order. Enter the course number ACC-301 and the section AA. Enter MWF 9:00 - 9:50 for the time. Enter SB 311 as the room and 100 as the professor. When you are done entering data in the last field, start a new blank record.
answer
You clicked the control, changed the cell's value to "ACC-301", clicked the control, changed the cell's value to "AA", clicked the control, changed the cell's value to "MWF 9:00 - 9:50", clicked the control, changed the cell's value to "SB 311", clicked the control, and changed the cell's value to "100". In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button. You clicked the control, changed the cell's value to "ACC-301", clicked the control, changed the cell's value to "AA", clicked the control, changed the cell's value to "MWF 9:00 - 9:50", clicked the control, changed the cell's value to "SB 311", clicked the control, changed the cell's value to "100", clicked the 37 control, clicked the 37 control, and changed the cell's value to "". In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button. You clicked the control, changed the cell's value to "MWF 9:00 - 9:50", clicked the control, changed the cell's value to "SB 311", clicked the control, and changed the cell's value to "100". In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button.
question
Close the Course table.
answer
You clicked the Course Tab Header, right-clicked the Course Tab Header. In the Right Click menu, you clicked the Close menu item.
question
Create a backup of the database. You do not need to change the backup location.
answer
You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Save button.
question
Add a new record to the table with the student ID 6412 and advance to the second field.
answer
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button. In the Access Table, you typed 6412, typed 6412 and pressed Tab.
question
From the current view (Design view), set the Default Value property for the Classification field to Fr.
answer
In the Access Table, you clicked in the Classification Cell, clicked the Default Value property box, and clicked the Default Value Build... Button. Inside the Expression Builder dialog, you typed =Fr in the Expression Default Value Input input, clicked the Ok button.
question
Modify the table relationships so that when a record is deleted in the Department table, the related records in the Professor table will also be deleted.
answer
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the department and professor tables. Inside the Edit Relationships dialog, you checked the Cascade Delete Related Records check box, clicked the OK button.
question
From Datasheet view, add a new field to the far right of the table to store a picture for each resident advisor. Add the picture Patrick to the first record.
answer
In the Access Table, you clicked the arrow at the top of the Click To Add column. In the Drop-Down Menu menu, you clicked the Attachment menu item. In the Access Table, you Double-Clicked the Attachment Icon. Inside the Attachments dialog, you clicked the Add... button. You clicked Patrick. Inside the Choose File dialog, you clicked the Open button. Inside the Attachments dialog, you clicked the OK button.
question
Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
answer
In the Access Table, you right-clicked the FirstName column header. In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. Inside the Find and Replace dialog, you clicked the dialog Close button. In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Replace button. Inside the Find and Replace dialog, you checked the Match Case check box, typed julie in the Find What input, typed Julie in the Replace With input, and clicked the Replace All button. Inside the Appointments dialog, you clicked the Yes button.
question
From the current view (Design view), apply the Medium Time format to the StartTime field.
answer
got wrong
question
From the current view, change the data type for the EndDate field to Date/Time.
answer
In the Fields Ribbon Tab in the Formatting Ribbon Group, you clicked the Data Type: drop-down arrow. In the Data Type: menu, you clicked the Date/Time menu item.
question
Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.
answer
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the department and professor tables. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.
question
Rename the table IncomingFreshmenStudents to: NewStudents
answer
You right-clicked the IncomingFreshmanStudents table. In the Right-Click menu, you clicked the Rename menu item. You renamed the IncomingFreshmanStudents table to NewStudents.
question
From the current view, delete the Major field from the table.
answer
In the Access Table, you right-clicked the Major cell. In the Right Click menu, you clicked the Delete Rows menu item. Inside the Spa : Database dialog, you clicked the Yes button.
question
Switch to the view where you can modify the structure of the report without viewing any live data.
answer
In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Design View menu item.
question
From the current view, delete the Description field.
answer
In the Access Table, you clicked the arrow at the top of the Description column, right-clicked the Description column header. In the Right Click Menu menu, you clicked the Delete Field menu item. Inside the Spa : Database dialog, you clicked the Yes button.
question
From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.
answer
In the Access Table, you clicked in the Lookup Wizard Cell, clicked the Drop-Down Button, and clicked the Lookup Wizard Item. Inside the Lookup Wizard dialog, you selected the I will type in the values that I want Radio Button, clicked the Next button. Inside the Lookup Wizard dialog in the Access Table, you clicked in the Male Cell, typed Male, typed Male and pressed Tab, and typed Female. Inside the Lookup Wizard dialog, you clicked the Next button, checked the Limit To List check box, and clicked the Finish button.
question
Preview how the results of this query will look when printed.
answer
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.
question
Create a new relationship between the EmployeeID field in the Professor table and the Advisor field in the Student table. Ensure that values in the Advisor field have a corresponding value in the EmployeeID field.
answer
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database, clicked the relationships Database, and dragged the object onto the advisor in the student Database. Inside the Edit Relationships dialog, you checked the Enforce Referential Integrity check box, clicked the Create button.
question
Open the Relationships window.
answer
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button.
question
Create a new database from the Students template. Do not change the location. Name the database: Students.
answer
You opened the backstage view, clicked the New navigation button, clicked the Students template, typed Students in the File Name box, and clicked the Create button.