Hi, I need help with some homework.  It’s VBScript and Included are the instructions.  It has to written in

NotePad++  Half of the script is already included as well.

• Attachment 1
• Attachment 2

 ATTACHMENT PREVIEW Download attachmentIf you’re doing this lab on your own computer and do not have Microsoft Access 200732-bit installed on your computer, you need to download and install the fileAccessDatabaseEngine.exe for Access Database 2007. Follow the instructionsfound here.http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=enVBScript Database Query LabObjectivesIn this lab, students will complete the following objecTves.Create a connecTon to an Access database.Create various SQL queries to extract informaTon from a database.Format extracted data with column headers.Lab DiagramDuring your session you will have access to the following lab con±guraTon.Connecting to Your LabFor this lab, we will only need to connect toVlab-PC1.COMP230_Wk 7_Database_Lab1Revision Date:1213

View the AnswerVlab-PC1Vlab-PC2To start simply click on the named Worksta±on from the device list (located on the leF hand side ofthe screen) and clickPower onin the tools bar. In some cases the devices may power onautoma±cally.During the boot up process an ac±vity indicator will be displayed in the name tab.Black—Powered O²Orange—Working on your requestGreen—Ready to accessIf the remote console is not displayed automa±cally in the main window (or popup) click theConnecticon located in the tools bar to start your session.If the remote console does not appear please try the following op±on.Switch between the HTML 5 and Java client versions in the tools bar.In the event this does not resolve your connec±vity problems please visit our Help/Support pages foraddi±onal resolu±on op±ons.Task 1: Understanding the Commands inComputerDatabase.vbsThe IT department maintains an Access database that is used to inventory the computers in thevarious rooms. ³ields in the database include: Computer Type, Hostname, Room Number, CPU Type,Number of Bits, Speed, Number of Processors, Opera±ng System, Memory, and Hard Drive Size. Weneed to query this database to determine upgrades and replacements for exis±ng computers.Below (and on the following page) is a lisTng of the Computers.accdb database contents.COMP230_Wk 7_Database_Lab2Revision Date:1213

Show

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"