Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

additional steps CTURE AND SERVICES Database Application: Building a Knowledge Database 3-41. Campus Travel seems to be growing quite rapidly. Now it has franchises in

image text in transcribed
additional steps
image text in transcribed
CTURE AND SERVICES Database Application: Building a Knowledge Database 3-41. Campus Travel seems to be growing quite rapidly. Now it has franchises in three different states, totaling 16 locations. As the company has grown tremendously over the past few years, it has become increasingly difficult to keep track of the areas of expertise of each travel consultant; often consultants waste valuable time trying to find out who in the company possesses the knowledge about a particular region. Impressed with your skills, the general manager of Campus Travel has asked you to add, modify, and delete the following records from its employee database: Open employeedata.mdb. Select the "employee" tab. Add the following records: a. Eric Tang. Spokane Office, Expert in Southwest. Phone (509) 555-2311 b. Janna Connell, Spokane Office, Expert in Delta, Phone (509) 555-1144 Delete the following record: a. Carl Looney from the Pullman office Modify the following: a. Change Frank Herman from the Pullman office to the Spokane office b. Change Ramon Sanchez's home number to (208) 549-2544 Access Assignment Attiched Fisch unceyou.cod 038) Segment 341 on page 134 Folow all the instruction sted Adonionly change Connell's last name to Connell yourlastname. Within the database, create an input fomi bo aliow you to input the data. The name of the form should be labeled with your name followed by te word FORM As an example, Sua Sam's form would be Sue Smith Form Save the form with the same name Create a Report with the coloyeedata do data. The title of the port should be your name, preceded by "Report by As an ancie, Son Santh's report would be Report by Sue Smith Sort the data so that it is in alphabetical order by LastName. Format the results and present me form and moon in a professional marverConed out is required Ara, presenting the work in a very professional and wonly appealing mannes required to get full credit On the report make sure you indude the report name, dato of completion, and the page number in the heading on each pagrouputis on multiple pages . Submit the database file using this link . Alhon providename a screenshot of the Sorted Employee File, the Form, and the import . Upload them before submitting this assignment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

3. Provide two explanations for the effects of mass media

Answered: 1 week ago

Question

=+ What topics are contained in the contracts?

Answered: 1 week ago