Select the text box that appears below the ContractorID column (and contains the number 11) in the ContractorList report. Then use the mouse to resize the height of the text box slightly (by approximately 1/16-inch) so that it is tall enough to completely display the value it contains as shown in Figure 1 below. Save the report.
Select the text box that appears below the ContractorID column (and containsthe number 11) in the ContractorList report. Then use the mouse to resize theheight of the text box slightly (by approximately 1/16-inch) so that it is tallenough to completely display the value it contains as shown in Figure 1below. Save the report.
PRN NURSING SERVICES CREATING A TABLE QUERY FORM AND REPORT TO MANAGE STAFF DATAOrder DescriptionNew Perspectives Access 2013Tutorial 1: SAM Project 1bPRN NURSING SERVICESCREATING A TABLE QUERY FORM AND REPORT TO MANAGESTAFF DATANew Perspectives Access 2013| Tutorial 1: SAM Project 1b3. Change the data type of the ClientID field to Short Text.4. Create the following fields in the Client table using the Short Text data type:FirstName LastName Address City State and Zip.5. Enter the records shown in Table 1 into the Client table.Table 1: Client TableClientID FirstName LastName Address City State ZipA501 Susan Rogers 101 W Eagle Nashville TN 37244B505 David Truax 1201 Rivalto Ct Murfreesboro TN 371336. Resize the Address field to best fit the data it contains. Save and close theClient table.7. Open the Contractor table in Datasheet view and then change the name ofthe ID field to ContractorID.8. Change the data type of the ContractorID field to Short Text.9. Change the data type of the HireDate field to Date/Time and then save thetable.10. Enter the records shown in Table 2 into the Contractor table.Table 2: Contractor TableContractorID FirstName LastName Interests Credentials HireDate1025 Alan Mazuelos Pediatrics MSN 3/2/20141026 Pamela McCabe Obstetrics MSN 3/4/201411. Amy created a database named support_NP_A13_T1_P1b_nurses.accdbthat contains a table with additional contractor data. The Contractor table youjust edited has the same design as the Employee table in thesupport_NP_A13_T1_P1b_nurses.accdb database. Copy all the recordsfrom the Employee table in the support_NP_A13_T1_P1b_nurses.accdbdatabase available for download from the SAM website and paste them atthe end of the Contractor table in the current database.12. Resize the ContractorID column in the Contractor datasheet to best fit thedata it contains. Save the table and then close it.13. Use the Simple Query Wizard to create a query based on the Contractor table.Include the FirstName LastName and Interests fields from the Contractortable in the query in that order. Name the query Interests and then closethe query.2014 Cengage Learning.2014 Cengage Learning.New Perspectives Access 2013| Tutorial 1: SAM Project 1b14. Use the Form tool to create a form based on the Contractor table. Save theform as ContractorInfo. Use the navigation buttons for the ContractorInfoform to navigate to the third record the last record and the first record.Close the ContractorInfo form.15. Use the Report tool to create a report based on the Contractor table. Save thereport as ContractorList.16. In Layout view for the ContractorList report use the mouse to reduce thewidth of the ContractorID column so it is approximately as wide as the textContractorID in the column heading.17. Select the text box that appears below the ContractorID column (and containsthe number 11) in the ContractorList report. Then use the mouse to resize theheight of the text box slightly (by approximately 1/16-inch) so that it is tallenough to completely display the value it contains as shown in Figure 1below. Save the report.Figure 1: ContractorList Report18. Close the Navigation pane. Select the text box that appears below theInterests and Credentials columns and that contains the text Page 1 of 1.Use an arrow key to move the text box to the left so that its left edgevertically aligns with the left edge of the Interests column above it. View thefirst page of the report in Print Preview to view the changes you made andthen view the next page of the report in Print Preview. Save and close thereport and then open the Navigation pane.Microsoft product screenshots used with permission from Microsoft Corporation.Copyright 2014 Cengage Learning. All Rights Reserved.New Perspectives Access 2013| Tutorial 1: SAM Project 1bSave and close any open objects in your database. Compact and repair your database closeit and exit Access. Follow the directions on the SAM website to submit your completedproject
. .
The post Select the text box that appears below the ContractorID column (and contains the number 11) in the ContractorList report. Then use the mouse to resize the height of the text box slightly (by approximately 1/16-inch) so that it is tall enough to completely display the value it contains as shown in Figure 1 below. Save the report. appeared first on writerbay.shop.
