Simnet Group 8 Exam
Add the picture Justin to the second record.
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.
Click the field that most likely uses the AutoNumber data type.
In the Access Table, you clicked in the 2 Cell.
From the current view (Design view), set the Default Value property for the Classification field to Fr.
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.
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.
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.
From the current view (Design view), change the Field Size property for the RAStudentID field to 4.
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.
Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.
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.
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.
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.
From the current view, delete the Description field.
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.
Modify the width of the CourseDescription column to best fit the data.
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.
Replace all instances of the first name julie with Julie. Be sure to match the case exactly.
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.
From the current view, delete the Major field from the table.
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.
From the current view (Datasheet view), change the Field Size property for the RAStudentID field to 4.
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.
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.
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.
Add a new table in Design view.
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button.
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
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.
Open the Relationships window.
In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button.
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.
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.
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.
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.
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.
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.
Run the Compact & Repair tool to optimize database efficiency by compacting unused space and deleting unnecessary temporary objects.
In the Database Tools Ribbon Tab in the Tools Ribbon Group, you clicked the Compact and Repair Database button.
From the current view, change the data type for the EndDate field to Date/Time.
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.
From the current view (Datasheet view), set the Default Value property for the Classification field to Fr.
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.
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.
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.
Delete this student record.
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.
Add a new record to this form.
In the Home Ribbon Tab in the Records Ribbon Group, you clicked the New button.
Add a new record to the table with the student ID 6412 and advance to the second field.
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.
Clear the sorting from this table.
In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Remove Sort button.
Switch to the view where you can modify the structure of the report without viewing any live data.
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.
A new record has been added to this form. Undo the data entry.
In the application header, you clicked the Undo button.
Close the Course table.
You clicked the Course Tab Header, right-clicked the Course Tab Header. In the Right Click menu, you clicked the Close menu item.
Go to record number 20.
You clicked the Current Record Box, typed 20 in the Current Record Box, and pressed the Enter key.
Enable active content in this database.
You clicked the Enable Content button.
Go to the first record.
You clicked the First Record Button.
Change the Navigation Pane grouping option
You clicked the Nav Pane Open/Close button.
Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)
You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.
Go to the previous record.
You clicked the Previous Record Button.
Use the Search box to begin searching for a student with the last name beginning with Car.
You clicked the Search Box, typed Car in the Search Box.
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.
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.
Create a new database from the Students template. Do not change the location. Name the database: Students.
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.
Preview how the results of this query will look when printed.
You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.
Preview how the results of this query will look when printed when the page orientation is changed to landscape.
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.
Preview how the results of this table will look when printed. Change the preview options to show two pages at once.
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.
Create a backup of the database. You do not need to change the backup location.
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.
Rename the table IncomingFreshmenStudents to: NewStudents
You right-clicked the IncomingFreshmanStudents table. In the Right-Click menu, you clicked the Rename menu item. You renamed the IncomingFreshmanStudents table to NewStudents.
Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.
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.
Delete the NewDepartments table.
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.
Create a new table in Datasheet view. Save it with the name: Degrees
got wrong
From the current view (Design view), apply the Medium Time format to the StartTime field.
got wrong
From the current view, add a new Short Text field to the far right side of the table. Name the field: Description
got wrong
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.
got wrong
