Question: Hello, I'm a bit lost on this assignment. Any help is appreciated. Below are the instructions And below this is the SWLicenses.mdb screenshot(s). Any help
Hello, I'm a bit lost on this assignment. Any help is appreciated. Below are the instructions
And below this is the SWLicenses.mdb screenshot(s).



Any help is appreciated. I'll make sure to thumbs up the correct answer.
Export PDF Adobe Export PDF Convert PDF files to Word of Excel online Select PDF File T9ICE Instructions.pdf 1 file/ 134 KB Securing Information Systems Database Application: Tracking Software Licenses at Campus Travel Recently, you have taken on the position of IS manager at Campus Travel. In your second week at work, you realize that many of the software licenses are about to expire or have already expired. As you know about the legal and ethical implications of unlicensed software, you have decided to set up a software asset management system that lets you keep track of the software licenses. You have already set up a database and stored some of the information, but you want to make the system more user friendly. Using the SWLicenses.mdb database, design a form to input the following information for new software products: Software title Installation location (office) License number Convert Tag Microsoft Word (.doc) Recognize Text in English(U.S.) Change Convert Create PDF Edit PDF Send Files Store Files Expiration date Furthermore, design a report displaying all software licenses and expiration dates (sorted by expiration dates). (Hint: In Microsoft Access, use the form and report wizards to create the forms and reports, you will find the wizards under the "Create" tab.) Open the report in the design view. Add a label control to the Page Footer section. Place CIS 3130 and your name in the label control. Print the report as a PDF file Submit a PDF file of the report. Table Tools Access Data Database Tools Help - 7 21 Ascending Selection 21 Descending Advanced 0 Remove Sort 7 Toggle Filter Fields Table Tell me what you want to do New Totals Replace Save abc Spelling Go To Refresh Find All X Delete - More Select Records Find o Filter Size to Swit Fit Form Windo Window Sort & Filter Copy Copy_ID License_NR - 165465-4654-46: 2 1654-4654-6546 3 16445-16541-89 4 87965-1621-652 5 1984984-65651 6 6549-6516-1654 7 564-654-6516 8 165465-1651-16 (New) Expiration_Date Software ID Location ID Click to Add- 12/12/2014 2 12/2/2012 1 5 4/15/2012 1 1 10 4/17/2012 1 - 20 4/22/2012 1 1 10 4/20/2014 1 15 4/20/2014 2 8 4/25/2012 2 19 0 Record H. search O A Table Tools Access ate Edernal Data Database Tools Help Fields Table New 7 z Ascending 7 Selection ? Tell me what you want to do Totals Replace Spelling Go To Find More Select 21 Descending T Advanced Save Filter Refresh All Sort & Filter Records Find Location Location_ID = Location_DeClick to Add 101 2 102 3 103 4 104 5 105 6 106 7 107 8. 201 9.202 10 203 11204 20 12 205 13 206 14 207 15 301 16 302 17 303 18 304 19 305 20 306 21 307 (New) Record: 1 of 21 No Filter Search earch ORI A Table Tools Access te Database Tools External Data Help Table Fields O Tell me what you want t 7 z Ascending Selection Repl Go T Selec Car New Totals Save aby Spelling Refresh All X Delet - More Records Find Filter 21 Descending Advanced 20 Remove So Y Toggle Filter Sort & Filter at Painter Find O Location Location_ID Location_De Click to Add O Software Software_ID Title Click to Add 1 Word 2 Excel 3 Access 4 Acrobat 5 EasyTax 6 Windows XP 7 Windows 7 (New) Record Record: 4107 No Filter Search to search Export PDF Adobe Export PDF Convert PDF files to Word of Excel online Select PDF File T9ICE Instructions.pdf 1 file/ 134 KB Securing Information Systems Database Application: Tracking Software Licenses at Campus Travel Recently, you have taken on the position of IS manager at Campus Travel. In your second week at work, you realize that many of the software licenses are about to expire or have already expired. As you know about the legal and ethical implications of unlicensed software, you have decided to set up a software asset management system that lets you keep track of the software licenses. You have already set up a database and stored some of the information, but you want to make the system more user friendly. Using the SWLicenses.mdb database, design a form to input the following information for new software products: Software title Installation location (office) License number Convert Tag Microsoft Word (.doc) Recognize Text in English(U.S.) Change Convert Create PDF Edit PDF Send Files Store Files Expiration date Furthermore, design a report displaying all software licenses and expiration dates (sorted by expiration dates). (Hint: In Microsoft Access, use the form and report wizards to create the forms and reports, you will find the wizards under the "Create" tab.) Open the report in the design view. Add a label control to the Page Footer section. Place CIS 3130 and your name in the label control. Print the report as a PDF file Submit a PDF file of the report. Table Tools Access Data Database Tools Help - 7 21 Ascending Selection 21 Descending Advanced 0 Remove Sort 7 Toggle Filter Fields Table Tell me what you want to do New Totals Replace Save abc Spelling Go To Refresh Find All X Delete - More Select Records Find o Filter Size to Swit Fit Form Windo Window Sort & Filter Copy Copy_ID License_NR - 165465-4654-46: 2 1654-4654-6546 3 16445-16541-89 4 87965-1621-652 5 1984984-65651 6 6549-6516-1654 7 564-654-6516 8 165465-1651-16 (New) Expiration_Date Software ID Location ID Click to Add- 12/12/2014 2 12/2/2012 1 5 4/15/2012 1 1 10 4/17/2012 1 - 20 4/22/2012 1 1 10 4/20/2014 1 15 4/20/2014 2 8 4/25/2012 2 19 0 Record H. search O A Table Tools Access ate Edernal Data Database Tools Help Fields Table New 7 z Ascending 7 Selection ? Tell me what you want to do Totals Replace Spelling Go To Find More Select 21 Descending T Advanced Save Filter Refresh All Sort & Filter Records Find Location Location_ID = Location_DeClick to Add 101 2 102 3 103 4 104 5 105 6 106 7 107 8. 201 9.202 10 203 11204 20 12 205 13 206 14 207 15 301 16 302 17 303 18 304 19 305 20 306 21 307 (New) Record: 1 of 21 No Filter Search earch ORI A Table Tools Access te Database Tools External Data Help Table Fields O Tell me what you want t 7 z Ascending Selection Repl Go T Selec Car New Totals Save aby Spelling Refresh All X Delet - More Records Find Filter 21 Descending Advanced 20 Remove So Y Toggle Filter Sort & Filter at Painter Find O Location Location_ID Location_De Click to Add O Software Software_ID Title Click to Add 1 Word 2 Excel 3 Access 4 Acrobat 5 EasyTax 6 Windows XP 7 Windows 7 (New) Record Record: 4107 No Filter Search to search
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
