Exp19_Access_Ch01_CapAssessment – Latte Delights Inventory 1.0  Project Description: In this project, you will open a database containing the inventory of a coffee shop, create a new table in which to store sales representatives (reps) information, and then add the sales rep records. You add a new product using a form and print a report. You apply a filter by selection and sort a query, and then you apply a filter by form to a table. You save both filters. Start Access. Open the downloaded Access file named Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb. Grader has automatically added your last name to the beginning of the filename. Add the following records to the Sales Reps table, letting Access assign the SalesRepID:  LastName FirstName Address City State ZIP Eissler Karean 13 Oak Lane Montgomery PA 17752 Rai Namrata 1000 Ogden Blvd New Castle DE 19720 Pellum Katryn 286 Bergen Rd Salford PA 18957   Close the table. Open the Customers form in Form view. Use Search to locate the record for Baker Auto Supply. Modify the record so that the Address1 field displays 4508 N.W. 7 Avenue. Save and close the form. Open the Products form in Form view. Add a new product (Access will automatically add the Product ID): Coffee-Arabica Premium. The Description is 24/Case, Pre-Ground 1.75 Oz Bags, the Cost is $13 (just type 13, no $), the Markup Percent is 100%, the Brand is Premium, and the Year Introduced is 2017. Save the new record and close the form. Open the Products report and check that the report contains the new product P0026, Coffee-Arabica Premium. View the layout of the report in Print Preview and then change the page layout to Landscape. Save the report and close Print Preview. Open the Customers table. Sort the table by Customer Name in ascending order. Save the changes and close the table. Open the Revenue Stats query and sort the City field in ascending order. Apply Filter by Selection so that only stats for the last name Pellum display. Save and close the filtered query. Open the Products table. Use Filter by Form to create a filter that will identify all premium brands in the Brand field that were introduced after 2017. Apply the filter and preview the filtered table. Close the table and save the changes. Close all database objects. Close the database and then exit Access. Submit the database as directed.
 

 

Exp19_Access_Ch02_Capstone – International Foodies 1.0

 

nternational Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the company and discovered that their product lists and the suppliers they buy from are stored in Excel workbooks. You offer to help by using your newly gained knowledge of Access to create a relational database for them. You will begin by importing the workbooks from Excel into a new Access database. Your manager mentions that she would also like a table that specifies food categories so that you can relate the products you sell to specific categories in the database. You will create a table from scratch to track categories, create relationships between the tables, and create some baseline queries.

1

Start   Access. Open the downloaded Access file named Exp19_Access_Ch2_Cap_Foodies. Grader has automatically added your   last name to the beginning of the filename. Save the file to the location   where you are storing your files.

2

You   will examine the data in the downloaded Excel worksheets to determine which   fields will become the primary keys in each table and which fields will   become the foreign keys so that you can join them in the database.
 

  Open the Suppliers.xlsx Excel   workbook, examine the data, and close the workbook. Open the Products.xlsx Excel workbook, examine   the data, and close the workbook.
 

  You will import two Excel workbooks that contain supplier and product   information into the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Suppliers.xlsx   workbook to be imported as a new table in the current database. Select First Row Contains Column Headings.   Set the SupplierID field Indexed option to Yes (No Duplicates). Select SupplierID   as the primary key when prompted and accept the table name Suppliers. Do not save the import   steps.

3

Import   the Products.xlsx workbook, set the   ProductID Indexed option to Yes (No   Duplicates), and select ProductID   as the primary key. Accept the table name Products.

4

Change   the Field Size of the QuantityPerUnit field to 25   in Design view of the Products table. Set the Field Size of ProductID and   CategoryID to Long Integer. Save   the changes and open the table in Datasheet view. Open the Suppliers table in   Datasheet view to examine the data. Close the tables.

5

You   will create a new table that will enable International Foodies to associate   each product with a food category in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as CategoryID   with the Number Data Type and Number assigned to a new category.   (type the period) as the Description. Set the Caption property to Category ID.
 

  Save the table as Categories.

6

   Add CategoryName with the Short Text Data Type and Name of food   category.   (type the period) as the Description. Change the field size to 15. Set the Caption property to Category Name and the Required property to Yes.

7

Add   CategoryDescription with the Long Text Data Type. Set the Caption property to Category Description. Switch to Datasheet view and save the   table when prompted. You will enter Category data into the table in the next step.

8

   You will add 8 records to the Categories table so that you have some sample   data to test in the database.
 

  Add the following records to the Categories table:

Category   ID Category Name   Category Description 

1 BEVERAGES  SOFT DRINKS, COFFEES, TEAS 

2 CONDIMENTS  SAUCES, RELISHES, SEASONINGS

3 CONFECTIONS  DESSERTS,   CANDIES, SWEET BREADS

4 DAIRY   PRODUCTS  CHEESES

5 GRAINS/CEREALS  BREADS, PASTA, CEREAL

6  MEAT/POULTRY  PREPARED   MEATS

7 PRODUCE  DRIED FRUIT, BEAN CURD

8 SEAFOOD  SEAWEED AND FISH

  Close the table.

9

You will create   the relationships between the tables using the Relationships window.
 

  Add all three tables to the Relationships window. Identify the primary key   fields in the Categories table and the Suppliers table and join them with   their foreign key counterparts in the related Products table. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

10

You   will use the Simple Query Wizard to create a query of all products that you   import in the seafood category.
 

  Add the ProductName, SupplierID, and CategoryID fields from Products (in that order). Save the query   as Seafood Products.

11

Add   a criterion in Design view, to include only products with 8 as the CategoryID.

12

Sort   the query results in ascending order by ProductName. Run, save, and close the   query.

13

You   want to create a query that displays actual category names rather than the   CategoryIDs. You are interested to know which meat and poultry products are   imported. You will copy the Seafood Products query and modify it to delete a   field, then add an additional table and field.
 

  Copy the Seafood Products query   and paste it using Seafood Or Meat/Poultry   as the query name.

14

Open   the Seafood Or Meat/Poultry query   in Design view and delete the CategoryID   column.

15

Add   the Categories table to the top   pane of the query design window. Add the CategoryName   field to the last column of the design grid and set the criterion as “Seafood” Or “Meat/Poultry”.   Run, save, and close the query.

16

You   will create a query that identifies suppliers and their associated products.   Because there is a relationship between the two tables, you can now pull data   from each of them together as usable information.
 

  Create a query in Design view that includes the Suppliers and Products   tables. The query should list the company name, contact name, phone (in that   order), then the product name and the product cost (in that order).

17

Sort   the query by company name in ascending order, then by product cost in   descending order. Run, close, and save the query as Company by Product List.

18

You   determine that the data in the Company by Product List query could be   summarized with a Total row. You will group the records by company name, and   then count the number of products you buy from each of them.
 

  Copy the Company by Product List query   and paste it using Summary of Company by   Product   as the query name.

19

Open   the Summary of Company by Product   query in Design view and delete the ContactName, Phone, and ProductCost columns.

20

Click   Totals in the Show/Hide group on   the Query Tools Design tab. Click in the Total   row of the ProductName field, click the arrow, and then select Count.   The records will be grouped by the company’s name and the products for each   company will be summarized.

21

Modify   the field name of the ProductName column as Product Count:   ProductName to make the field name more   identifiable. Click Run in the   Results group (20 records display in the Datasheet). The results display the   product count for each company that supplies your organization. Save and   close the query.

22

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

PFA

2-3 Pages

APA

 

Week 4 Course Project 

Add loops to validate data. Add a menu to your program that allows users to use the various features or exit the program.

Examples: In the programming tutorial, add a tutorial on working with loops. Then use loops to validate user input and display an error message if they enter data outside the valid range. Use a main loop to allow the user to keep selecting different tutorials until they decide to exit the program.

Refer the the Course Project Overview for complete details.

PowerPoint on your U6 paper and post it on the Discussion Board for this assignment. Comment on two other students’ presentations for full points on this assignment. 

VBScript Database Query Lab

‘======================================================================

‘ NAME: ComputersDatabase.vbs

‘

‘ AUTHOR: jlmorgan , 

‘ DATE  : 8/19/2011

‘

‘ COMMENT: Use 32 bit ODBC Microsoft Access Driver

‘

‘==========================================================================

recordsStr = “”

sqlStr = “SELECT * FROM Computers”

dataSource = “provider=Microsoft.ACE.OLEDB.12.0;” _

& “data source=C:ScriptsComputers.accdb”

Set objConnection = CreateObject(“ADODB.Connection”)

objConnection.Open dataSource

Set objRecordSet = CreateObject(“ADODB.Recordset”)

objRecordSet.Open sqlStr , objConnection

objRecordSet.MoveFirst

‘ Display Headers

recordsStr = “Computer                 HostName           Room_Num” & _

     ”   CPU_Type  Speed   Num_CPUs   Bit_Size          OS_Type   ” & _

     ”      Memory       HDD_Size” & vbCrLf & _

     “============================================================” & _

     “=============================” & vbCrLf

Do Until objRecordSet.EOF

   recordsStr = recordsStr & objRecordSet.Fields.Item(“Computer”) & _

        vbTab & pad(objRecordSet.Fields.Item(“HostName”),12) & _

        vbTab & pad(objRecordSet.Fields.Item(“Room_Num”),14) & _

        vbTab & objRecordSet.Fields.Item(“CPU_Type”) & _

        vbTab & objRecordSet.Fields.Item(“Speed”) & _

        vbTab & objRecordSet.Fields.Item(“Num_CPUs”) & _

        vbTab & objRecordSet.Fields.Item(“Bit_Size”) & _

        vbTab & pad(objRecordSet.Fields.Item(“OS_Type”),12) & _

        vbTab & objRecordSet.Fields.Item(“Memory”) & _

        vbTab & objRecordSet.Fields.Item(“HDD_Size”) & vbCrLf

    objRecordSet.MoveNext

Loop

objRecordSet.Close

objConnection.Close

WScript.Echo recordsStr

function pad(ByVal strText, ByVal len)

pad = Left(strText & Space(len), len)

end Function

Objective 

In this lab, students will complete the following objectives. 

• Create a connection to an Access database. 

• Create various SQL queries to extract information from a database. 

• Format extracted data with column headers. 

Element K Network Connections

 

For this lab, we will only need to connect to vlab-PC1. The computer vlab-PC1 is the computer on the left side while vlab-PC2 is on the right. If you leave the cursor on the PC icon for a few seconds, a tool-tip message will appear indicating the hostname of the PC. Open vlab-PC1 and log in as Administrator with the password password.

Lab Overview

Even though we are only using vlab-PC1 to complete our lab assignment, the database we will be accessing (Computers.accdb) is actually located on the computer vlab-PC2 in the directory C:Database. This directory is shared as a ReadOnly network share by vlab-PC2. The Universal Naming Convention (UNC) name for this share is \vlab-PC2Database. Our VBScript program vlab-PC1 will have to open the \vlab-PC2Database share and map it to the local X: drive. The path specified fro the database will then be X:Computers.accdb.

The IT department maintains an Access database on vlab-PC2 that is used to inventory the computers in the various rooms. Fields in the database include: Computer Type, Hostname, Room Number, CPU Type, Number of Bits, Speed, Number of Processors, Operating System, Memory, and Hard Drive Size. We need to query this database to determine upgrades and replacements for existing computers. 

Below (and on the following page) is a listing of the Computers.accdb database contents:

 

 

 

Task 1: Understanding the Net Use Commands in ComputerDatabase.vbs 

• Open Notepad++. Use the menu option File/Open to open the VBScript program: C:ScriptsComputerDatabase.vbs. 

Task 2: Understanding the ADODB.Connection and ADODB.Recordset Objects

• In NotePad++, look at the following code lines.

Line 11 contains the SQL Query String named sqlStr. This is the line you will have to modify to properly query the Computer database. The SQL Query  “SELECT * FROM Computers” will select all fields from the database table Computers.

Lines 12 and 13 uses a string named dataSource to specify the Microsoft Driver and the name and location of the local database: X:Computers.accdb.

Line 14 Creates the “ADODB.Connection” object while line 15 opens the connection to the database.

Line 16 Creates the “ADODB.Recordset” object while line 17 provides access to the records using the SQL Query String and the Connection object. Line 18 moves the objRecordSet pointer to the first record.

 

Task 3: Displaying the Record Headers and Database Records 

• In NotePad++, look at the following lines of the ComputerDatabase.vbs program.

Lines 20–24 display the Database fieldnames as column headers.  Note the use of & to concatenate (add) string values together and _ which is the VBScript line continuation character.

Lines 25–37  are a Do Until loop that sequences through the database looking for records

that match the SQL Query String. The objRecordSet.EOF method checks to see if we have reached the last record in the database. This required because reading past the end of a database will cause an error. recordStr is a string variable initially set to “”. recordStr is used to create a multi-line string that contains the column headers and records that match the SQL query. The WScript.Echo recordStr statement in line 40 displays the column headers and records to the console or desktop windows depending on whether cscript or wscript is used to run the program.

Lines 38 and 39 close the database connections made by the ADODB.Connection and ADODB.Recordset objects. 

The function pad(byVal strText, ByVal len) in lines 44–46 are used to format the field values with added spaces so the tab positions will line up correctly.

Task 4: Write and Run Database Query Program 1 

In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors, and the size of the Hard Drive.

• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerReplace.vbs. 

• Modify the SQL Query String (sqlStr) in line 11 to extract the following information from the database.

Fields Displayed from Computers Table (specified by the SELECT clause). 

Computer

Room_Num

Speed

Num_CPUs

OS_Type

HDD_Size

Replacement Criteria (specified by the WHERE clause).

Any computer with a single CPU

Any computer with a CPU speed less than 2.1 GHz

Any Computer with a Hard Disk Drive size less than 300 GBytes

Sort Criteria (specified by the ORDER BY clause).

Sort the extracted records by the “Room_Num” field.

• Modify lines 20–24 to display the correct field headers for the fields being displayed.

• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.

• Press the function key and in the Commands box, type wscript ComputerReplace.vbs. Click OK to run the program and verify correct formatting and query results. 

 

• This query should generate eight records displayed in order by room number. If you have any errors, do not get the correct results or your columns are mis-aligned; modify your program

as required until you get the correct output.

Copy and paste your ComputerReplace.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your  lab-report document. Answer the questions about the Replacement SQL Query in the  lab-report document.

 

Task 5: Write and Run Database Query Program 2

In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgraded to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB. 

• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerUpgrade.vbs. 

• Modify the SQL Query String (sqlStr) in line 11 extract the following information from the database.

Fields Displayed from Computers Table (specified by the SELECT clause). 

Computer

HostName

Room_Num

OS_Type

Memory

Replacement Criteria (specified by the WHERE clause).

Note: String values in fields must be delimited by single quotes.

Any computer with the Fedora 10 Operating System (‘Fedora 10’)

Any computer with the Windows XP Operating System (‘Windows XP’)

Any computer with 2 GB of memory

Sort Criteria (specified by the ORDER BY clause).

Sort the extracted records by the “OS_Type” field.

• Modify lines 20–24 to display the correct field headers for the fields being displayed.

• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.

• Press the function key and in the Commands box, type wscript ComputerUpgrade.vbs. Click OK to run the program and verify correct formatting and query results.

 

• This query should generate 16 records displayed in order by OS_Type. If you have any errors, do not get the correct results, or your columns are mis-aligned; modify your program as required until you get the correct output.

Copy and paste your ComputerUpgrade.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your  lab-report document. Answer the questions about the Upgrade SQL Query in the  lab-report document.

 

Student Name ____________________________  Date _____________

VBScript Database Query Lab Report

Task 4: Write and Run Database Query Program 1 

In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors and the size of the Hard Drive.

• In the space provided in your Lab Report document, paste your modified VBScript program and the RUN.

In the table cell below, paste your ComputerReplace.vbs Program

 

In the table cell below, paste the desktop RUN from your ComputerReplace.vbs Program

How many Computers will be replaced due only to CPU Speed < 2 GHz?

How many Computers will be replaced due only to Number of CPUs = 1?

How many Computers will be replaced due only to HDD Size < 300?

How many Computers will be replaced due to 2 or more reasons?

 

Task 5: Write and Run Database Query Program 2

In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgrade to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB. 

In the table cell below, paste your ComputerUpgrade.vbs Program

 

In the table cell below, paste the desktop RUN from your ComputerUpgrade.vbs Program

How many Fedora 10 Computers will be upgraded?

How many Window 7 Computers will be upgraded due to 2 GB memory?

How many Windows XP Computers will need a Memory and OS upgrade?

         Answer the following question(s):      

1. Think about how you would feel if there were no rules regarding  how your credit card information was stored on merchants’ websites.  Consider whether you would purchase items online. Would the Internet be  as big as it is today if we had no laws or information security policies  regarding data that makes up an e-commerce transaction? Provide  rationale for your answer.
2. Imagine that you work for an organization that has no Internet  use policy. Employees use the Internet in whatever way they want using  company-owned personal computers. Could this cause a problem for the  organization? Why or why not?

     Fully address the questions in this discussion; provide valid  rationale for your choices, where applicable; 

Download The Attachment and Message Me Please for Detailed Instructions

This week’s journal article was focused on the Complexity of Information Systems Research in the Digital World. Complexity is increasing as new technologies are emerging every day. This complexity impacts human experiences. Organizations are turning to digitally enabled solutions to assist with the emergence of digitalization. 

Please review the article and define the various technologies that are emerging as noted in the article. Note how these emerging technologies are impacting organizations and what organizations can to do to reduce the burden of digitalization.

Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research. Please be sure that journal articles are peer-reviewed and are published within the last five years.

The paper should meet the following requirements:

3-5 pages in length (not including title page or references)

APA guidelines must be followed. The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.

A minimum of five peer-reviewed journal articles.

The writing should be clear and concise. Headings should be used to transition thoughts. Don’t forget that the grade also includes the quality of writing.

Journal articles:

• Journal Article 1.1: Trumpy, A.J. and Elliott, M. (2019) ‘You lead like a girl: Gender and children’s leadership development’, Sociological Perspectives, 62(3): 346–365.
• Journal Article 1.2: Sudha, K.S., Shahnawaz, M. G. and Farhat, A. (2016) ‘Leadership styles, leader’s effectiveness and well-being: Exploring Collective Efficacy as a Mediator’, Vision, 20(2): 111–120.

 

For this problem you must use Java’s semaphore class. Your  implementation for this problem must only use the semaphore methods to  control the concurrency of your solution (IE. acquire and release).  Consider a small take-out food restaurant called Burrito Brothers that  is open 24 hours, seven days a week. This very popular establishment  offers a VERY-TASTY burrito. There are three servers that own a private  beef area, a cheese area, and a tortilla area (IE. Each server has their  own ingredients in an infinite supply). Additionally, there are three  shared counter locations, a shared cash register and a shared waiting  area that can accommodate up to 15 customers. By law the shop has a  maximum customer capacity of 15. A customer cannot enter the shop if it  is filled to capacity. If the there is room a customer will gain access  to the shop. Each customer will enter the shop with an order of one to  20 burritos. As soon as a server is free, the customer that has the  shortest order is served next. A server is either servicing a customer  or waiting. Each server will make (at most) three burritos at time for a  given customer. Once a server has obtained all ingredients, a burrito  can be made. When a customer’s entire order is finished, the customer  pays a cashier and leaves the shop. Since there is only one cash  register, only one patron may pay at a time. However, in the event that a  customer’s entire order has not been filled by the server at the  completion of the current counter visit the customer must reenter the  waiting area. The waiting area is organized by the shortest order next.  Implement a solution to this problem as a Java application using the  Java semaphore class for synchronization. Your zip file must expand into  a single directory and your application must compile at the command  prompt using javac *.java. Output must include the arrival of each  customer and each state transition: leaving full shop, entering shop  with an order of m burritos, customer standing, getting service from  server n, paying, and leaving. Each customer is represented by a  corresponding thread and each server in your implementation is also  represented by a unique Java thread. All customers and servers exist  within a single application. The system must compile using the command:  javac *.java. The system must run using the command: java Burrito.