a. Given excel file: Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows: Screenshot of Worksheet “Denver”

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Benefits of using arrays as instance variables: What are the advantages of incorporating arrays as instance variables within a class? Initializing and managing arrays: How do you initialize and manage arrays within class constructors and mutators (setters)? Example of using arrays as instance variables: Share an example where you have used arrays as instance variables and discuss its application in a real-world scenario. Common mistakes with arrays as instance variables: What are some common mistakes to avoid when working with arrays as instance variables? Information hiding violations: What is the potential violation of information hiding when using arrays as instance variables? How can this be resolved?

Do you think that computers should replace teachers? Give three references with your answer.

Is online learning or face to face learning better to teach students around the around the world? Give reasons for your answer and provide two references with your response. What are benefits of both online learning and face to face learning ? Give two references with your answer. How does online learning and face to face learning affects students around the world? Give two references with your answer.

Answer 2

Expert Solution & Answer

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Answer 8

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Answer 9

Chapter AE, Problem AE4.1

Explanation of Solution

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

Answer 10

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Answer 11

Explanation of Solution

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

Answer 12

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Answer 13

Explanation of Solution

c.

Importing “Denver” sheet into Access:

To import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

A “Get external data-Excel spreadsheet” dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Screenshot of Getting external data dialog box

Now Import Spreadsheet wizard get opened.

Screenshot of Import spreadsheet wizard

Select “Denver” sheet.

Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Screenshot of Import spreadsheet wizard

Click “Next” button again and click on “choose my own primary key option” and click “Next”.

Import spreadsheet wizard

Answer 14

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Answer 15

Explanation of Solution

d.

Delete the unnecessary records.

Screenshot of Employee table
...

Answer 16

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Answer 17

Explanation of Solution

e.

Steps to create parameterized query:

Click the “CREATE” tab and select a “Query Design” option.

Select “Employee” table and click on button on dialogue box. And close it.

From below panel, click the drop down button on “Filed” section and select the column name from the corresponding table “Employee”.

After placing all columns on “Field” section, the panel will be appeared as follows:

Screenshot of Placing column names in the query

Answer 18

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Answer 19

Explanation of Solution

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

Answer 20

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Answer 21

Explanation of Solution

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document

Answer 22

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 23

Ch. AE - Prob. AE1.1 Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - Prob. AE3.2 Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - Prob. AE5.1 Ch. AE - Prob. AE5.2

a. Given excel file: Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows: Screenshot of Worksheet “Denver”

Explanation of Solution

a. Given excel file: Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows: Screenshot of Worksheet “Denver”

Explanation of Solution

b. Creating blank database: The below are the steps to create new database: Click “File->New” and then choose on the option “Blank desktop database”. Provide the name of the database and click “Create”...

Explanation of Solution

Explanation of Solution

d. Delete the unnecessary records. Screenshot of Employee table...

Explanation of Solution

Explanation of Solution

f. Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows: Screenshot of Criteria for the columns “CPU” and “Memory”

Explanation of Solution

g. To import the query result into a word database click on the “External Data” tab and click on “Word”. The query data is exported into the word as follows: Table screenshot from word document

Want to see the full answer?

Chapter AE Solutions

a.

Given excel file:

Double click on the file “Ch04Ex01 _U10e.xlsx” that is downloaded and it contains three sheets as follows:

Screenshot of Worksheet “Denver”

b.

Creating blank database:

The below are the steps to create new database:

Click “File->New” and then choose on the option “Blank desktop database”.

Provide the name of the database and click “Create”...

d.

Delete the unnecessary records.

Screenshot of Employee table
...

f.

Now set the criteria for the columns “CPU” as “<=2” and “Memory” as “<=6” follows:

Screenshot of Criteria for the columns “CPU” and “Memory”

g.

To import the query result into a word database click on the “External Data” tab and click on “Word”.

The query data is exported into the word as follows:

Table screenshot from word document