Computer Science
CITC 1303 Nashville State College Microsoft Access Database Concepts Report

CITC 1303

Nashville State Community College

CITC

Question Description

Help me study for my Computer Science class. I’m stuck and don’t understand.

Perform the following tasks: 1. Open the Advisor table in Design view.
2. Add the Phone Number, CFA Certification, Other Skills, and Picture fields to the Advisor table structure, as shown in Figure 5–82. Create an input mask for the new Phone Number field. Store the phone number data without symbols. CFA Certification is a field that indicates whether the advisor has completed all the exams for a chartered financial analyst.

3. Add the data shown in Table 5–1 to the Advisor table. Adjust the row and column spacing to best fit the data. Save the changes to the layout of the table.

4. If requested to do so by your instructor, change the phone number for advisor number 103 to your phone number.

5. Query the Advisor table to find all Advisors who have CFA Certification. Include the Advisor Number, Last Name, First Name, and Phone Number fields in the query result. Save the query as Apply 5 Step 5 Query.

6. Query the Advisor table to find all advisors with a master’s degree or pursuing a master’s degree who have completed the CFA Certification. Include the Advisor Number, Last Name, First Name, and Other Skills fields in the query result. Save the query as Apply 5 Step 6 Query.

7. What value did you enter in the criteria row for the CFA Certification field in the query in Step 6 above? Could you have entered the criteria differently? If yes, then how would you enter the criteria

CITC 1303 Nashville State College Microsoft Access Database Concepts Report
figure_5_82.jpg
CITC 1303 Nashville State College Microsoft Access Database Concepts Report
table_5_1.jpg

Unformatted Attachment Preview

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Hey buddy, see attached😋 Let me know if you need ...

Dr_ConnorK (2683)
UIUC

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags