Category: Programming

Access Module 1 Canvas Project Details
City Tours Ltd. is a company that provides tours in a city that is a popular tourist destination for travelers. As a customer service manager for the company, you’ve decided to create an Access database to better manage information on customers and tours.
Access Module 1 Canvas Project Steps
Complete the steps below.
Download the Start_File.accdb file and New2019Blank.accdb files:Start_File.accdbDownload Start_File.accdb
New2019Blank.accdbDownload New2019Blank.accdb
Rename the Start_File.accdb presentation to Access_Mod1_FirstLastName.accdb and Save it in a location easily found by you. The Desktop is a good spot.If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
Example: Access_Mod1_AndreAndersen.accdb
Create a new table in Datasheet View with the following options:Rename the default primary key ID field TourNumber and change the data type to Short Text. TourNumber should remain the primary key.
Add a new field with the name TourName and the Short Text data type.
Change the field size of the TourName field to 35.
Add a new field with the name BasicCost and the Currency data type.
Save the table using Tours as the name.
With the Tours table still open in Datasheet View, add the record shown in Table 1 below. Save and close the Tours table.
Create a new table in Design View to store the customers of City Tours Ltd. who have requested private group tours as follows:Add a field with the name GroupNumber and the AutoNumber data type.
Set GroupNumber as the table’s primary key.
Save the table with the name Groups but do not close it.
With the Groups table still open in Design View, add a second field to the table with the field name CustomerID and the Short Text data type. Save the table and then close it.
Open the Guides table in Design View and change the name of the field named FName to FirstName and use LastName to change the name of the field named LName.
With the Guides table still open in Design View, change the data type property for the GuideID field from Number to Short Text.
In Design View, add a new field to the Guides table after the Phone field. The field should be named StartDate and have the Date/Time data type. Save the Guides table and do not close it.
Switch the Guides table to Datasheet View, navigate to the fifth record (which has a GuideID field value of 108), and delete the record.
With the Guides table still open in Datasheet View, navigate to the third record (which has a GuideID field value of 104) and change the value to Devlin for the LastName field. Close the Guides table.
You also need to view individual guide records. Use the Form tool to create a form for the Guides table. Save the form with the name Guide Data Form and confirm that the form matches Figure 1. Close the form.Figure 1
Use the Simple Query Wizard to create a query based on the Customers table with the following options:Include all fields from the Customers table in the query.
Save the query with the name Customers Query (which is the default name) and then close the query.
You need to refer to a printed copy of the Customers table when reconfirming tour reservations. Use the Report Wizard to create a report based on the Customers table with the following options:Include the LastName, FirstName, and Mobile fields from the Customers table in the report.
Do not include any grouping levels.
Sort the report by LastName in Ascending order.
Select Tabular as the layout of the report and Portrait as the orientation of the report.
Save the report using Customer Contact Report as the name. Confirm that the report matches Figure 2and then close the report.
Figure 2
In the Navigation Pane, use Customer Data Form to rename the Customers Form.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions below to submit your completed project.

please select the correct fill in
Question 1
Which of the following lines is an example of alliteration?
Question 1 options:”a sad, raggy tune”
“dreamless, uninvaded sleep”
“the sound of steel on stones”
“thump, thump, thump”
Question 2 (5 points)
What do the experiences described in “A Tree Telling of Orpheus” show about life?
Question 2 options:the effects of weather
the goodness of nature
the power of music
the wisdom of stillness
Question 3 (5 points)
SavedWhich phrase from “Meeting at Night” contains alliteration?
Question 3 options:”the yellow half-moon large and low”
“As I gain the cove”
“the two hearts beating each to each”
“Three fields to cross”
Question 4 (5 points)
Saved
Which of the following lines is an example of a metaphor?
Question 4 options:”I am offering this poem to you”
“He didn’t fight / he hadn’t fought at all”
“My stomach was a melon split wide inside my skin”
“The weeping of the guitar / begins”
Question 5 (5 points)
What does the speaker of “When I went to visit …” hint at, or suggest, in the poem?
Question 5 options:how cruelly his beloved treats him
how deeply he loves his girlfriend
how greatly he regrets his actions
how cleverly he tricked someone
Question 6 (5 points)
To what does the speaker in “The Empty Dance Shoes” compare the energy of dance shoes at rest?
Question 6 options:a 98-pound weakling
“The Colossus” by Sylvia Plath
A clown knocked down by a sandbag
the music in the Stardust Ballroom
Question 7 (5 points)
Which sentence summarizes the story told in “The Fish”?
Question 7 options:A woman catches a fish and then lets it go.
A woman catches a fish that grants her three wishes.
A woman catches a fish and takes it home for dinner.
A woman catches a fish but the fish gets away.
Question 8 (5 points)
In which season of the year is a forest most likely to look very stark?
Question 8 options:winter
spring
summer
fall
Question 9 (5 points)
A poem’s words and details give clues about the author’s attitude toward his or her subject. In “Fear,” what is Mistral’s attitude toward the mother’s fears?
Question 9 options:She feels sorry for the child who is smothered by such fears.
She sees that the mother’s fears spring from her deep love.
She thinks that the mother’s fears are unnecessary.
She believes that the mother’s fears are not normal.
Question 10 (5 points)
Vocabulary and Grammar. Which item below is an object that could be venerable?
Question 10 options:an antique book
a box of crayons
a cell phone
a luxurious new house
Question 11 (5 points)

Which of the following lines is an example of onomatopoeia?
Question 11 options:”dreamless, uninvaded sleep”
“the sound of steel on stones”
“a sad, raggy tune”
“thump, thump, thump”
Question 12 (5 points)
What does the word context mean in the following passage from “How to React to Familiar Faces”? A face out of context creates confusion.
Question 12 options:a previous neighborhood
expression
familiar surroundings
a past conversation
Question 13 (5 points)
Which of the following are characteristics of the tanka form?
Question 13 options:a rhyme scheme of aba
14 lines and 5 accented syllables per line
5 lines and a syllable count of 5, 7, 5, 7, 7
a rhyme scheme of abba, cddc, efef, gg
Question 14 (5 points)
How are the poems “The Bridegroom” and “Danny Deever” alike?
Question 14 options:They are both set in England in the 1800s.
The both describe the dangers of romantic love.
They both describe military life.
They both use dialogue to tell a dramatic story.
Question 15 (5 points)
How many sentences would be included if the following lines from “Mowing” were read aloud? There was never a sound beside the wood but one, And that was my long scythe whispering to the ground.
Question 15 options:one
none
two
three
Question 16 (5 points)

Which of the following is an example of a narrative poem?
Question 16 options:
All of the above
The Bridegroom by Alexander Pushkin
The Fish by Elizabeth Bishop
Danny Deever by Rudyard Kipling
Question 17 (5 points)
When previewing the following lines from Sonnet 18, how many sentences should readers plan to read fluently? So long as men can breathe, or eyes can see, So long lives this, and this gives life to thee.
Question 17 options:one
four
two
none
Question 18 (5 points)
Which of these phrases from “In Flanders Fields” contains an example of assonance?
Question 18 options:”In Flanders fields the poppies blow”
“We are the Dead”
“The torch; be yours to hold it high.”
“We shall not sleep”
Question 19 (5 points)
What is the tone of “Conscientious Objector”?
Question 19 options:comic
defiant
happy
despairing
Question 20 (5 points)
SavedHow does the poem “Also All” respond to the poem “All”?
Question 20 options:It praises the poem’s world view.
It disagrees with the poem’s main idea.
It extends the poem with extra examples.
It answers the poem’s questions.
4 of 20 questions saved

mit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g.,misspell words, remove spaces between words, hide characters, usedifferent character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.

Access Module 1 Canvas Project Details
City Tours Ltd. is a company that provides tours in a city that is a popular tourist destination for travelers. As a customer service manager for the company, you’ve decided to create an Access database to better manage information on customers and tours.
Access Module 1 Canvas Project Steps
Complete the steps below.
Download the Start_File.accdb file and New2019Blank.accdb files:Start_File.accdbDownload Start_File.accdb
New2019Blank.accdbDownload New2019Blank.accdb
Rename the Start_File.accdb presentation to Access_Mod1_FirstLastName.accdb and Save it in a location easily found by you. The Desktop is a good spot.If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
Example: Access_Mod1_AndreAndersen.accdb
Create a new table in Datasheet View with the following options:Rename the default primary key ID field TourNumber and change the data type to Short Text. TourNumber should remain the primary key.
Add a new field with the name TourName and the Short Text data type.
Change the field size of the TourName field to 35.
Add a new field with the name BasicCost and the Currency data type.
Save the table using Tours as the name.
With the Tours table still open in Datasheet View, add the record shown in Table 1 below. Save and close the Tours table.
Create a new table in Design View to store the customers of City Tours Ltd. who have requested private group tours as follows:Add a field with the name GroupNumber and the AutoNumber data type.
Set GroupNumber as the table’s primary key.
Save the table with the name Groups but do not close it.
With the Groups table still open in Design View, add a second field to the table with the field name CustomerID and the Short Text data type. Save the table and then close it.
Open the Guides table in Design View and change the name of the field named FName to FirstName and use LastName to change the name of the field named LName.
With the Guides table still open in Design View, change the data type property for the GuideID field from Number to Short Text.
In Design View, add a new field to the Guides table after the Phone field. The field should be named StartDate and have the Date/Time data type. Save the Guides table and do not close it.
Switch the Guides table to Datasheet View, navigate to the fifth record (which has a GuideID field value of 108), and delete the record.
With the Guides table still open in Datasheet View, navigate to the third record (which has a GuideID field value of 104) and change the value to Devlin for the LastName field. Close the Guides table.
You also need to view individual guide records. Use the Form tool to create a form for the Guides table. Save the form with the name Guide Data Form and confirm that the form matches Figure 1. Close the form.Figure 1
Use the Simple Query Wizard to create a query based on the Customers table with the following options:Include all fields from the Customers table in the query.
Save the query with the name Customers Query (which is the default name) and then close the query.
You need to refer to a printed copy of the Customers table when reconfirming tour reservations. Use the Report Wizard to create a report based on the Customers table with the following options:Include the LastName, FirstName, and Mobile fields from the Customers table in the report.
Do not include any grouping levels.
Sort the report by LastName in Ascending order.
Select Tabular as the layout of the report and Portrait as the orientation of the report.
Save the report using Customer Contact Report as the name. Confirm that the report matches Figure 2and then close the report.
Figure 2
In the Navigation Pane, use Customer Data Form to rename the Customers Form.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions below to submit your completed project.

please select the correct fill in
Question 1
Which of the following lines is an example of alliteration?
Question 1 options:”a sad, raggy tune”
“dreamless, uninvaded sleep”
“the sound of steel on stones”
“thump, thump, thump”
Question 2 (5 points)
What do the experiences described in “A Tree Telling of Orpheus” show about life?
Question 2 options:the effects of weather
the goodness of nature
the power of music
the wisdom of stillness
Question 3 (5 points)
SavedWhich phrase from “Meeting at Night” contains alliteration?
Question 3 options:”the yellow half-moon large and low”
“As I gain the cove”
“the two hearts beating each to each”
“Three fields to cross”
Question 4 (5 points)
Saved
Which of the following lines is an example of a metaphor?
Question 4 options:”I am offering this poem to you”
“He didn’t fight / he hadn’t fought at all”
“My stomach was a melon split wide inside my skin”
“The weeping of the guitar / begins”
Question 5 (5 points)
What does the speaker of “When I went to visit …” hint at, or suggest, in the poem?
Question 5 options:how cruelly his beloved treats him
how deeply he loves his girlfriend
how greatly he regrets his actions
how cleverly he tricked someone
Question 6 (5 points)
To what does the speaker in “The Empty Dance Shoes” compare the energy of dance shoes at rest?
Question 6 options:a 98-pound weakling
“The Colossus” by Sylvia Plath
A clown knocked down by a sandbag
the music in the Stardust Ballroom
Question 7 (5 points)
Which sentence summarizes the story told in “The Fish”?
Question 7 options:A woman catches a fish and then lets it go.
A woman catches a fish that grants her three wishes.
A woman catches a fish and takes it home for dinner.
A woman catches a fish but the fish gets away.
Question 8 (5 points)
In which season of the year is a forest most likely to look very stark?
Question 8 options:winter
spring
summer
fall
Question 9 (5 points)
A poem’s words and details give clues about the author’s attitude toward his or her subject. In “Fear,” what is Mistral’s attitude toward the mother’s fears?
Question 9 options:She feels sorry for the child who is smothered by such fears.
She sees that the mother’s fears spring from her deep love.
She thinks that the mother’s fears are unnecessary.
She believes that the mother’s fears are not normal.
Question 10 (5 points)
Vocabulary and Grammar. Which item below is an object that could be venerable?
Question 10 options:an antique book
a box of crayons
a cell phone
a luxurious new house
Question 11 (5 points)

Which of the following lines is an example of onomatopoeia?
Question 11 options:”dreamless, uninvaded sleep”
“the sound of steel on stones”
“a sad, raggy tune”
“thump, thump, thump”
Question 12 (5 points)
What does the word context mean in the following passage from “How to React to Familiar Faces”? A face out of context creates confusion.
Question 12 options:a previous neighborhood
expression
familiar surroundings
a past conversation
Question 13 (5 points)
Which of the following are characteristics of the tanka form?
Question 13 options:a rhyme scheme of aba
14 lines and 5 accented syllables per line
5 lines and a syllable count of 5, 7, 5, 7, 7
a rhyme scheme of abba, cddc, efef, gg
Question 14 (5 points)
How are the poems “The Bridegroom” and “Danny Deever” alike?
Question 14 options:They are both set in England in the 1800s.
The both describe the dangers of romantic love.
They both describe military life.
They both use dialogue to tell a dramatic story.
Question 15 (5 points)
How many sentences would be included if the following lines from “Mowing” were read aloud? There was never a sound beside the wood but one, And that was my long scythe whispering to the ground.
Question 15 options:one
none
two
three
Question 16 (5 points)

Which of the following is an example of a narrative poem?
Question 16 options:
All of the above
The Bridegroom by Alexander Pushkin
The Fish by Elizabeth Bishop
Danny Deever by Rudyard Kipling
Question 17 (5 points)
When previewing the following lines from Sonnet 18, how many sentences should readers plan to read fluently? So long as men can breathe, or eyes can see, So long lives this, and this gives life to thee.
Question 17 options:one
four
two
none
Question 18 (5 points)
Which of these phrases from “In Flanders Fields” contains an example of assonance?
Question 18 options:”In Flanders fields the poppies blow”
“We are the Dead”
“The torch; be yours to hold it high.”
“We shall not sleep”
Question 19 (5 points)
What is the tone of “Conscientious Objector”?
Question 19 options:comic
defiant
happy
despairing
Question 20 (5 points)
SavedHow does the poem “Also All” respond to the poem “All”?
Question 20 options:It praises the poem’s world view.
It disagrees with the poem’s main idea.
It extends the poem with extra examples.
It answers the poem’s questions.
4 of 20 questions saved

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Learning Outcome(s): LO3
The student will be able to develop a comprehensive IT project plan for estimation, scheduling, communication, resource management, procurement, risk, and quality.
Description and Instructions
Project Instructions
This project enables the students to integrate the covered knowledge and skills in this course to perform as project managers in the field of computing and improve the success rate of the IT projects.
Total Marks = 14
Project Report
Presentation
10 marks
4 marks
Group Size = 3- 4 members.
One group member (group leader) should submit all files: Project Report and Presentation Slides on blackboard on 12th May 2024. Marks will be given based on your submission and quality of the contents.
Each group must come up with a unique scenario for the project based on the below description and get approved by your instructor before 3rd March 2024.
Presentation
Grading Criteria:
Criteria
Marks
Complete content (Introduction, body, and conclusion)
2 marks
Answers questions accurately and effectively and clearly justify and support the point of view when needed.
1 mark
Effective use of time (max. 8-10 mints)
0.5 mark
Voice projection and loudness/ Eye contact/ Confidence and attitude
0.5 mark
Learning Outcome(s): LO3
The student will be able to develop a comprehensive IT project plan for estimation, scheduling, communication, resource management, procurement, risk, and quality.
Project Description
Assume that you are an IT project manager, and your company is facing a problem in one of the following areas:
1.Customer Services
2.Security
3.Processes Automation
4.Human Resources
5.Supply Chain
6.Procurement
Develop a unique project scenario with your team to solve a problem in one of the above areas and provide the following requirements based on the approved scenario.
1.Describe the company, problem, and your proposed IT solution. (1 mark).
2.Using a mind mapping software create a mind map of a SWOT analysis for the project, including at least two strengths, weaknesses, opportunities and threats. (1 mark).
3.Develop project charter. (1 mark).
4.Document your approach for collecting requirements for the project. Include at least five technical requirements and five non-technical requirements in a requirements traceability matrix. (1 mark).
5.Develop a Cause-and-effect diagram to understand possible causes of the problem and identify areas for improvement. (1 mark).
6.Identify at least 5 milestones covers the main functions that the project provides. (1 mark).
7.
Learning Outcome(s): LO3
The student will be able to develop a comprehensive IT project plan for estimation, scheduling, communication, resource management, procurement, risk, and quality.
Using Microsoft Project, or any similar tool, to develop a project plan and draw a Gantt chart organized by the five project management process groups showing the task name and the duration of each task for the Work Breakdown Structure (WBS) to Level 3 or Level 4, as appropriate. Be sure the WBS is based on the project charter, the project scope statement, and other relevant information. (1 mark).
8.Define your strategy for monitoring and controlling the flow of the project. (1 mark).
9.Define your strategy for mitigating the potential risks. (1 mark).
10.Make the necessary assumptions for the estimated costs, benefits and discount rate over three years. Then, Perform a financial analysis (NPV, ROI and Payback) for the project. (1 mark).

Instructions:
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Name:
Name:
Name:

ID:
ID:
ID:

Description and Instructions
Case Study Objective:
This case study is an opportunity for you to practice your knowledge and to develop skills of working in teams.
Total Marks = 14
Project Report
Presentation
10 marks
4 marks
Group Size = 3-4 Members.
One group member (group leader/coordinator) should submit all files: Project Report and Presentation Slides on blackboard.
Marks will be given based on your submission and quality of the contents.

Project Report
Each Project Report will be evaluated according to the marking criteria mentioned in each question section.

Presentation
Each group need to present their projects in week# 14.
Introduction
The global economy went through a difficult period due to COVID-19. Many businesses did struggle, and some unfortunately failed. While COVID-19 brought immense challenges, it also opened doors for new business and innovative opportunities.
Peloton’s Rise and Fall
Peloton, the high-end at-home fitness company, initially thrived during the early stages of the pandemic. With gyms closed and people stuck at home, demand for their stationary bikes and fitness classes skyrocketed. However, by 2022, they faced significant challenges. They overestimated demand and built-up excess inventory, leading to stockpiling and financial losses. Competitors like NordicTrack and Echelon offered cheaper alternatives, chipping away at Peloton’s market share. Rising inflation and interest rates squeezed consumer spending, making luxury items like Peloton bikes less affordable. Peloton cut expenses, closed stores, and laid off employees to streamline operations. They launched lower-priced bikes and accessories to broaden their customer base. They invested heavily in their app and content offerings, enhancing the virtual fitness experience. Collaborations with retailers like Dick’s Sporting Goods and Amazon expanded their reach. They focused on building community and the emotional benefits of fitness rather than just pushing product sales. While the road was bumpy, Peloton’s efforts are starting to pay off. They’ve reduced their losses, streamlined operations, and are seeing signs of renewed customer demand. The company has shown resilience and adaptability in the face of adversity.
Note: The above-mentioned case study is just an example; students are supposed to find a case study of business that faced significant challenges during the pandemic but found innovative ways to overcome them.
4 Marks
Learning Outcome(s): CLO1: Explain the interdisciplinary concepts, theories, and trends in ES and their role in supporting business operations.

Question One
After selecting your case study, describe it in your own words by using the following points.
§Clear introduction: It should give the most important information that describes the case study. What is the nature of the product or service they provide? (0.5 mark)
§Business process: describe in detail the key business processes, How are they done? (1 mark)
§The business situation: It describes their situation at that time based on the business process. What are the changes that are made on theses process to overcome the situation. (1 mark)
§The Issues: State the problem/issues, consequences, and any hesitations in the business process. (0.5 mark)
§The strategies: State the key success strategies that helped them to navigate the pandemic challenges. (1 mark)

3 Marks
Learning Outcome(s): CLO4: Design ES architectural models for various business processes.
Question Two
Business Process Model and Notation (BPMN) is a standardized diagramming system used to visualize business processes.
§Use one of the tools such as Visio to model the chosen enterprise current process. (1.5 mark)
§Analyze the model process issues from at least two perspectives such as time and quality perspectives. (1.5 mark)

2 Marks
Learning Outcome(s):
CLO3: Discuss the issues and challenges associated with implementing ES and their impacts on corporate enterprises.
Question Three
Propose at least two suggestions for improving the process of your selected company from equipment, employees, IT & IS technologies perspectives. How your suggestions will solve business process issues. (1 mark)
Note: Your provided suggestions or solutions should be different than the solutions that the company have used to overcome the pandemic. (1 mark)
1 Marks
Learning Outcome(s):
CLO3: Discuss the issues and challenges associated with implementing ES and their impacts on corporate enterprises.
Question Four
Based on your information and the course materials, what innovative approaches can enterprises adopt to strengthen their disaster recovery plans? (1 mark)

Access Module 1 Canvas Project Details
City Tours Ltd. is a company that provides tours in a city that is a popular tourist destination for travelers. As a customer service manager for the company, you’ve decided to create an Access database to better manage information on customers and tours.
Access Module 1 Canvas Project Steps
Complete the steps below.
Download the Start_File.accdb file and New2019Blank.accdb files:Start_File.accdbDownload Start_File.accdb
New2019Blank.accdbDownload New2019Blank.accdb
Rename the Start_File.accdb presentation to Access_Mod1_FirstLastName.accdb and Save it in a location easily found by you. The Desktop is a good spot.If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
Example: Access_Mod1_AndreAndersen.accdb
Create a new table in Datasheet View with the following options:Rename the default primary key ID field TourNumber and change the data type to Short Text. TourNumber should remain the primary key.
Add a new field with the name TourName and the Short Text data type.
Change the field size of the TourName field to 35.
Add a new field with the name BasicCost and the Currency data type.
Save the table using Tours as the name.
With the Tours table still open in Datasheet View, add the record shown in Table 1 below. Save and close the Tours table.
Create a new table in Design View to store the customers of City Tours Ltd. who have requested private group tours as follows:Add a field with the name GroupNumber and the AutoNumber data type.
Set GroupNumber as the table’s primary key.
Save the table with the name Groups but do not close it.
With the Groups table still open in Design View, add a second field to the table with the field name CustomerID and the Short Text data type. Save the table and then close it.
Open the Guides table in Design View and change the name of the field named FName to FirstName and use LastName to change the name of the field named LName.
With the Guides table still open in Design View, change the data type property for the GuideID field from Number to Short Text.
In Design View, add a new field to the Guides table after the Phone field. The field should be named StartDate and have the Date/Time data type. Save the Guides table and do not close it.
Switch the Guides table to Datasheet View, navigate to the fifth record (which has a GuideID field value of 108), and delete the record.
With the Guides table still open in Datasheet View, navigate to the third record (which has a GuideID field value of 104) and change the value to Devlin for the LastName field. Close the Guides table.
You also need to view individual guide records. Use the Form tool to create a form for the Guides table. Save the form with the name Guide Data Form and confirm that the form matches Figure 1. Close the form.Figure 1
Use the Simple Query Wizard to create a query based on the Customers table with the following options:Include all fields from the Customers table in the query.
Save the query with the name Customers Query (which is the default name) and then close the query.
You need to refer to a printed copy of the Customers table when reconfirming tour reservations. Use the Report Wizard to create a report based on the Customers table with the following options:Include the LastName, FirstName, and Mobile fields from the Customers table in the report.
Do not include any grouping levels.
Sort the report by LastName in Ascending order.
Select Tabular as the layout of the report and Portrait as the orientation of the report.
Save the report using Customer Contact Report as the name. Confirm that the report matches Figure 2and then close the report.
Figure 2
In the Navigation Pane, use Customer Data Form to rename the Customers Form.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions below to submit your completed project.

Answer the questions in long essay format
Create correct physical and logical entity relationship diagrams (ERD) through draw.io

mit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g.,misspell words, remove spaces between words, hide characters, usedifferent character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.