Download Microsoft Access Database Management and more Exams Nursing in PDF only on Docsity!
Add a new Date/Time field to the far right side of the table. Name the field: StartDate - correct answer On the Table Tools Fields tab, in the Add & Delete group, click the Date/Time button. Type StartDate and press Enter.
Add a new calculated field named EmployeeCost in the first empty column to the right of the ProviderName field. The new field should calculate the value in the Premium field multiplied by .25. Run the query to view the results. - correct answer Click in the first empty cell in the Field row in the query grid to the right of the ProviderName column. On the Query Tools Design tab, in the Query Setup group, click the Builder button to open the Expression Builder. Double-click the Premium field and type *.25 to finish the expression. Click OK. Click in the new field and replace Expr1 with EmployeeCost as the name for the field. On the Query Tools Design tab, in the Results group, click the Run button.
Add a new record to the table with the staff ID 10-9999 and advance to the second field. - correct answer Click the New (blank) record button at the bottom of the table. Type 10-9999 in the StudentID field and press Tab.
Add a new record to this form. - correct answer Click the New (blank) record button at the bottom of the form.
Add a new table in Design view. - correct answer On the Create tab, in the Tables group, click the Table Design button.
Add criteria to this query to return only the records where the value in the SubscriptionType field is Self or Family and the value in the Premium field is <200. Run the query to view the results. - correct answer Type >200 and <250 in the Criteria row in the Premium column. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the Premium field is greater than 200 and less than 250. Run the query to view the results. - correct answer Add criteria to this query to return only the records where the value in the Premium field is greater than 200 and less than 250. Run the query to view the results.
Add criteria to this query to return only the records where the value in the InsuranceType field is Dental or Vision. Run the query to view the results. - correct answer Type Dental in the Criteria row in the InsuranceType column. Type Vision in the or row in the InsuranceType column (below the Criteria row). On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the SubscriptionType field is Family or the value in the Premium field is >200. Run the query to view the results. - correct answer Type Family in the Criteria row in the SubscriptionType column. Type >200 in the or row in the Premium column. Be careful to enter >200 in the or row not the Criteria row. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return records where the SubscriptionType field begins with the letters Self. Run the query. - correct answer Type Like "Self*" in the Criteria row in the SubscriptionType column. On the Query Tools Design tab, in the Results group, click the Run button.
Add the Services table to the Relationships window. - correct answer On the Relationship Tools Design tab, in the Relationships group, click the Show Table button. Double-click Services. Click Close.
Add the image MedicalInsurance to the form header as a logo. Do not switch views. - correct answer On the Form Layout Tools Design tab, in the Header/Footer group, click the Logo button. In the Insert Picture dialog, click MedicalInsurance to select the file, and then click the Open button.
From Layout view, apply bold formatting to the selected controls. Do not switch views. - correct answer On the Form Layout Tools Format tab, in the Font group, click the Bold button.
Apply the Currency format to the Premium bound text box controls. Do not switch views. - correct answer Click the control that displays the Premium value. On the Form Layout Tools Format tab, in the Number group, click the Currency Format button.
InsuranceProviders table. On the Query Tools Design tab, in the Results group, click the Run button.
Create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table. Enforce data integrity between the two tables. - correct answer On the Database Tools tab, in the Relationships group, click the Relationships button. Click StaffID in the Staff table and drag to Reviewer in the Reviews table. In the Edit Relationships dialog, click the Enforce Referential Integrity check box. Click Create.
Create a new table in Datasheet view. Save it with the name: InsurancePlans - correct answer On the Create tab, in the Tables group, click the Table button. Click the Save button on the Quick Access Toolbar. Type InsurancePlans in the Table Name box. Click OK.
Create a new table in Design view. Name the first field: IncreaseID Make the field data type: AutoNumber Add the description: Unique ID Set the field as the primary key. Save the table with the Name: WageIncreases - correct answer On the Create tab, in the Tables group, click the Table Design button. Type IncreaseID Press Tab. Expand the Data Type list and select AutoNumber. Press Tab again. Type Unique ID. Click the Primary Key button. Click the Save button on the Quick Access Toolbar. Type WageIncreases in the Table Name box. Click OK.
Create a parameter query where the user will enter a value to use as the criterion for the InsuranceType field. Use the prompt Enter Insurance Type. Run the query using the insurance type dental. - correct answer Click in the Criteria row in the InsuranceType column and type [Enter Insurance Type]. Click the Run button. Type dental when prompted. Click OK.
Create a Split form from the InsurancePlans table. - correct answer On the Create tab, in the Forms group, click the More Forms button, and select Split Form.
Delete the Copy of Staff table. - correct answer Right-click Copy of Staff. Click Delete. Click Yes.
The company no longer offers this insurance plan. Delete this record. - correct answer Click the record selector to select the entire record. On the Home tab, in the Records group, click the Delete button. Click Yes.
Export the InsuranceOptions query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps. - correct answer In the Navigation Pane, click the InsuranceOptions query once to select it. On the External Data tab, in the Export group, click the Excel button. Click the Export data with formatting and layout. check box. Click OK. Click Close.
Export the InsuranceOptions query to a comma-separated text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps. - correct answer In the Navigation Pane, click the InsuranceOptions query once to select it. On the External Data tab, in the Export group, click the Text File button. Click OK. Click Next. Click the Include Field Names on First Row check box. Click Next. Click Finish. Click Close.
From Datasheet view, add a new field the far right of the table to store a picture of each staff member. Add the picture JerryWashington to the fifth record. - correct answer Click the arrow in the Click to Add column to expand the list of available field data types. Click Attachment. Double-click the Attachment field in the fifth record. The Attachments dialog opens. Click the Add... button. Double- click the JerryWashington file to add it. Click OK.
From Design view, change the data type for the StaffID field to use a lookup list. The values in the list should include LastName from the Staff table. Items in the list should sort alphabetically by the LastName 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. - correct answer Expand the Data Type list for the StaffID field and select Lookup Wizard¿ Click Next. Click Table: Staff. Click Next. Double-click LastName. Click Next. Expand the first sort box, and click LastName. Click Next. Click Next. Click the Enable Data Integrity check box. Click Finish. Click Yes.
Preview tab, in the Data group, click the More button. Click Word. Click OK. Click Close.
Import all of the fields from the Staff worksheet in the Staff Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the StaffID field as the primary key. Accept the new table Staff. Do not save the import steps. - correct answer On the External Data tab, in the Import & Link group, click the New Data Source button, select From File, and click Excel. Click the Browse button. Click the Staff file. Click Open. Click OK. Click Next. Click the First Row Contains Column Headings check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.
Import data from the UpdatedBenefitPlans text file and append the records to the Benefits table. The data fields in the text file are separated by tabs. The first row in the text file is the header row. Save the import steps. Use the default name suggested by Access. - correct answer On the External Data tab, in the Import & Link group, click the New Data Source button, select From File, and click Text File. Click the Browse... button. Click UpdatedBenefitPlans, and then click Open. Click the Append a copy of the records to the table: radio button, and verify that Benefits is selected. Click OK. Click Next. Click the First Row Contains Field Names check box. Click Next. Click Finish. Click the Save Import Steps check box. Click the Save Import button.
Import data from the Departments comma-delimited text file to a new table. Use the first row as field names. Do not change any field information. Use the DeptID field as the primary key. Accept the new table Departments. Do not save the import. - correct answer On the External Data tab, in the Import & Link group, click the New Data Source button, select From File and click Text File. Click the Browse button. Click the Departments file. Click Open. Click OK. Click Next. Click the First Row Contains Field Names check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.
Limit the query results to records where the insurance Premium is greater than
- Run the query to view the results. - correct answer Type >250 in the Criteria
row in the Premium column. On the Query Tools Design tab, in the Results group, click the Run button.
Modify the table relationships so that when a record is deleted in the Departments table, the related records in the Staff table will also be deleted. - correct answer On the Database Tools tab, in the Relationships group, click the Relationships button. Double-click the line connecting the Departments and Staff tables. Click the Cascade Delete Related Records check box. Click OK.
Modify this query to show only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query. - correct answer Type Medical in the Criteria row in the InsuranceType column. On the Query Tools Design tab, in the Results group, click the Run button.
Modify this query so the InsuranceType field is hidden in the query results, and then run the query. - correct answer Click the Show box in the InsuranceType column to remove the checkmark. On the Query Tools Design tab, in the Results group, click the Run button.
Rename the ID field to: PlanID - correct answer On the Table Tools Fields tab, in the Properties group, click the Name & Caption button. Type PlanID in the Name box. Click OK.
Run the Compact & Repair tool to optimize database efficiency. - correct answer Click the File tab to open Backstage. Click the Compact & Repair Database button.
Set the Default Value property for the IncreaseType field to COLA. - correct answer On the Table Tools Fields tab, in the Properties group, click the Default Value button. Type COLA. Click OK.
Share the document with [email protected] and include the message Please proofread and edit. The recipient should be able to edit the document. - correct answer Click the Share button at the far right side of the Ribbon next to the user profile name. Type the e-mail address in the Invite people box. Verify Can edit is selected. Type the message Please proofread and edit. in the Include a message box. Click the Share button.
Add a subform to the bottom of this form to display all the fields from the WageIncreases table. Accept the relationship suggested by Access, and accept the suggested name for the subform. - correct answer On the Form Design Tools Design tab, in the Controls group, expand the Controls gallery by clicking the More button. Click the Subform/Subreport button. Click in the empty area at the bottom of the form. Click Next. Expand the Tables/Queries list and select Table: WageIncreases. Click the >> button. Click Next. Click Next. Click Finish.
Add criteria to this query to return only the records where the value in the Premium field is <500 and the value in the SubscriptionType field is Family. Run the query to view the results. - correct answer Type <500 in the Criteria row in the Premium column. Type Family in the Criteria row in the SubscriptionType column. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this summary query to include only records where the value in the DepartmentName field is Management. Do not include the DepartmentName field in the query groups. Run the query. - correct answer In the Total row, under DepartmentName, expand the Group by list and select Where. In the Criteria row, under DepartmentName, type Management. On the Query Tools Design tab, in the Results group, click the Run button.
Display the Total row for this query. - correct answer On the Query Tools Design tab, in the Show/Hide group, click the Totals button.
From Design view, add a combo box control to the form to the upper right corner of the Detail section of the form. Create a combo box that can be used as a navigation tool based on the value selected. Include the StaffID and LastName fields, in that order. Keep the primary key hidden. The label should display: Find staff by last name - correct answer On the Form Design Tools Design tab, in the Controls group, expand the Controls gallery by clicking the More button. Click the Combo Box button. Click in the form to the right of the DOB field. Click the Find a record on my form based on the value I selected in my combo box. radio button. Click Next. Double-click StaffID. Double-click LastName. Click Next. Click Next. In the box, type Find staff by last name and then click Finish.
From Design view, add a Command Button control to the upper right corner of the form next to the DOB field. Use the Close Form action from the Form Operations category. Display this text on the button: Save and Close Name the button control: btnCloseForm - correct answer On the Form Design Tools Design tab, in the Controls group, click the Button button. Click in the upper right corner of the form. Click Form Operations in the Categories list. Click Close Form in the Actions list. Click Next. Click the Text: radio button. Edit the button text to Save and Close and then click Next. Name the button control: btnCloseForm
From Design view, add a list box control to the form below the InsuranceID control. The list box control should display the following three values in this order: Medical Dental Vision Store the selected value in the InsuranceType field. The label should display: InsuranceType - correct answer On the Form Design Tools Design tab, in the Controls group, expand the Controls gallery by clicking the More button. Click the List Box button. Click in the form below the InsuranceID control. Select the I will type in the values that I want. radio button. Click Next. Type Medical in the first cell under Col1 and then press Tab. Type Dental and then press Tab. Type Vision and then click Next. Click the Store that value in this field: radio button. Select InsuranceType from the list. Click Next. In the box, type InsuranceType and then click Finish.
From Design view, add a new label control to the Page Header section above the LastName control. Change the label text to: Last Name - correct answer On the Report Design Tools Design tab, in the Controls group, click the Label control. If the Controls gallery is not visible on the Ribbon, click the Controls button to display it. Click in the report Page Header section above the LastName control. Type Last Name and press Enter.
From Design view, add a subform control to the bottom of this form. Base the subform on the Staff form. Accept the first suggested link between the form and subform. Finish the subform without changing the subform name. - correct answer On the Form Design Tools Design tab, in the Controls group, expand the Controls gallery and click the Subform/Subreport button. Click in the empty area
Create a new query in Design view using the following fields in this order: From the InsurancePlans table, add the InsuranceID, InsuranceType, SubscriptionType, and Premium fields. From the InsuranceProviders table, add the ProviderName field. Run the query. - correct answer On the Create tab, in the Queries group, click the Query Design button. In the Show Table dialog, double-click InsurancePlans and InsuranceProviders. Click Close. Double-click these fields in the InsurancePlans table in this order: InsuranceID, InsuranceType, SubscriptionType, and Premium. Double-click the ProviderName field in the InsuranceProviders table. On the Query Tools Design tab, in the Results group, click the Run button.
Limit the query results to records where the insurance Premium is greater than
- Run the query to view the results. - correct answer Type >250 in the Criteria row in the Premium column. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return records where the SubscriptionType field begins with the letters Self. Run the query. - correct answer Type Like "Self*" in the Criteria row in the SubscriptionType column. On the Query Tools Design tab, in the Results group, click the Run button.
Modify this query so the InsuranceType field is hidden in the query results, and then run the query. - correct answer Click the Show box in the InsuranceType column to remove the checkmark. On the Query Tools Design tab, in the Results group, click the Run button.
Set the sort order so the results will display records with the highest Premium first. Run the query and review the results. - correct answer Click in the Sort row under the Premium field. Click the arrow to expand the sort options list, and select Descending. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the Premium field is greater than 200 and less than 250. Run the query to view the
results. - correct answer Type >200 and <250 in the Criteria row in the Premium column. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the Premium field is <500 and the value in the SubscriptionType field is Family. Run the query to view the results. - correct answer Type <500 in the Criteria row in the Premium column. Type Family in the Criteria row in the SubscriptionType column. On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the InsuranceType field is Dental or Vision. Run the query to view the results. - correct answer Type Dental in the Criteria row in the InsuranceType column. Type Vision in the or row in the InsuranceType column (below the Criteria row). On the Query Tools Design tab, in the Results group, click the Run button.
Add criteria to this query to return only the records where the value in the SubscriptionType field is Self or Family and the value in the Premium field is <200. Run the query to view the results. - correct answer Type Self in the Criteria row in the SubscriptionType column. Type Family in the or row in the SubscriptionType column. Type <200 in the Criteria row in the Premium column. Type <200 in the or row in the Premium column. On the Query Tools Design tab, in the Results group, click the Run button.
Create a parameter query where the user will enter a value to use as the criterion for the InsuranceType field. Use the prompt Enter Insurance Type. Run the query using the insurance type dental. - correct answer Click in the Criteria row in the InsuranceType column and type [Enter Insurance Type]. Click the Run button. Type dental when prompted. Click OK.
Add a new calculated field named EmployeeCost in the first empty column to the right of the ProviderName field. The new field should calculate the value in the Premium field multiplied by .25. Run the query to view the results. - correct answer Click in the first empty cell in the Field row in the query grid to the right of the ProviderName column. On the Query Tools Design tab, in the Query Setup group, click the Builder button to open the Expression Builder. Double-click the
Browse button. Click the Departments file. Click Open. Click OK. Click Next. Click the First Row Contains Field Names check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.
Import data from the UpdatedBenefitPlans text file and append the records to the Benefits table. The data fields in the text file are separated by tabs. The first row in the text file is the header row. Save the import steps. Use the default name suggested by Access. - correct answer On the External Data tab, in the Import & Link group, click the New Data Source button, select From File, and click Text File. Click the Browse... button. Click UpdatedBenefitPlans, and then click Open. Click the Append a copy of the records to the table: radio button, and verify that Benefits is selected. Click OK. Click Next. Click the First Row Contains Field Names check box. Click Next. Click Finish. Click the Save Import Steps check box. Click the Save Import button.
Export the InsuranceOptions query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps. - correct answer In the Navigation Pane, click the InsuranceOptions query once to select it. On the External Data tab, in the Export group, click the Excel button. Click the Export data with formatting and layout. check box. Click OK. Click Close.
Export the InsuranceOptions query to a comma-separated text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps. - correct answer In the Navigation Pane, click the InsuranceOptions query once to select it. On the External Data tab, in the Export group, click the Text File button. Click OK. Click Next. Click the Include Field Names on First Row check box. Click Next. Click Finish. Click Close.
Go to the last record. - correct answer You clicked the Last Record Button
Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation. - correct answer In the Access Table, you clicked on CourseDescription, clicked the arrow at the top of the CourseDescription column, right-clicked the CourseDescription column
header, and clicked the arrow at the top of the CourseDescription column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.
Add the Status Quick Start fields to the right of the DegreeName field. - correct answer In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button, clicked the More Fields button. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.
Clear the sorting from this table. - correct answer In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right- Click menu, you clicked the Clear Filter menu item.
Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance. - correct answer In the Access Table, you clicked on Department, clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and clicked the OK button.
Add a new Short Text field to the far right side of the table. Name the field: Description - correct 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 Short Text menu item. In the Access Table, you typed Description and pressed Enter.
Add a new record to the table with the student ID 6412 and advance to the second field.
1/1 - correct answer You clicked the undefined view. In the Access Table, you clicked in Cell 33 in the StudentID column, typed 4126, clicked in the 6 Cell, typed 6412, and typed 6412 and pressed Enter.
Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4. - correct
Case check box, and clicked the Replace All button. Inside the Appointments dialog, you clicked the Yes button.
Delete this student record. - correct answer In the Access Table, you right- clicked the Row Selector. In the Right-Click menu, you clicked the Delete Record menu item. Inside the Spa : Database dialog, you clicked the Yes button.
Modify the width of the Time column to exactly 22. - correct answer In the Access Table, you clicked on Time, right-clicked the Time column header. In the Right Click Menu menu, you clicked the Field Width menu item. Inside the Column Width dialog, you typed 22 in the Column width: input, clicked the OK button.
Modify the width of the CourseDescription column to best fit the data. - correct answer In the Access Table, you clicked on CourseDescription, 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
Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out. - correct answer In the Access Table, you clicked on DOB, clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A menu item. In the Access Table, you clicked the arrow at the top of the Classification column. In the Table Column Filter Right-Click menu, you clicked the Sort A to Z menu item.
Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students. - correct answer You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, and typed Students in the File Name box.
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: Resident Advisors - correct 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, clicked in the Unique RA ID Cell, clicked in the AutoNumber Cell, typed AutoNumber and pressed Tab, and dragged the RA ID row. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Primary Key button. You right-clicked the Table1 Tab Header. In the Right Click menu, you clicked the Save menu item. Inside the Save As dialog, you typed Resident Advisors in the Table Name: input, clicked the OK button.
Add a new table in Design view. - correct answer In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design 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.
- correct answer In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. Inside the Edit Relationships dialog, you clicked the dialog Close button. You clicked the relationships Database. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.
Insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished. - correct answer In the Access Table, you right-clicked the Status cell. In the Right Click menu, you clicked the Insert Rows menu item. In the Access Table, you typed StartDate, typed StartDate and pressed Tab, clicked the Drop-Down Button, clicked the Date/Time Item, typed Date/Time and pressed Enter, clicked in the StartDate Cell, clicked in the StartDate Cell, typed StartDate, typed StartDate and pressed Enter, typed Date/Time and pressed Enter, and typed and pressed Enter. You right-clicked the Degrees Tab Header. In the Right Click menu, you clicked the Save menu item.
Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters. - correct answer In the Access
