Course Hero Logo
This textbook is available atAmazon.com Logo
Technology for Success and Shelly Cashman Series Microsoft Office 365 & Office 2019 1st Edition

Technology for Success and Shelly Cashman Series Microsoft Office 365 & Office 2019 (1st Edition)

Book Edition1st Edition
Author(s)Freund, Last
ISBN9780357026380
PublisherCengage Learning
SubjectComputer Science
End of Chapter
Apply Your Knowledge
Expand Your World
Chapter AC1, End of Chapter, Apply Your Knowledge, Exercise 10
Page AC 1-41

Adding a Caption, Changing a Data Type, and Creating a Query, Form, and Report

 

Note: To complete this assignment, you will be required to use the Data Files. Please contact your instructor for information about accessing the Data Files.

 

Instructions: Friendly Janitorial Services provides janitorial services to local businesses. The company uses a team-based approach and each team has a team leader or supervisor. Friendly Janitorial Services has a database that keeps track of its supervisors and its clients. Each client is assigned to a single supervisor; each supervisor may be assigned many clients. The database has two tables. The Client table contains data on the clients who use Friendly Janitorial Services. The Supervisor table contains data on the supervisors. You will add a caption, change a data type, and create a query, a form, and a report, as shown in Figure 1-83.

 

How would you change the field name of the Street field in the Client table to Address?

Explanation

  1. In the Navigation double-click the table in which you need to rename the field.  
  2. Right-click the section heading for the field that you need to rename, and afterward click Rename Field on the alternate route menu.
  3. Type the new name for the field and afterward press ENTER.

Verified Answer

To Change a field in a table in Access, open the table containing the field to rename in design view.  

Click into the "Field Name" section of the field that you need to rename and type another name. 

How would you rate this answer and explanation?
Did you like this example?
Subscribe for full access
Page AC 1-41