![]() Save the form and use the name Advisor for the form. Create a simple form for the Advisor table. Use the name Client Query for the query and close the query.ĥ. Use the Simple Query Wizard to create a query for the Client table that contains the Client Number, Client Name, and Advisor Number. Save the changes to the table and close the table.Ĥ. ![]() Change the field size for the field to 4 and add AU # as the caption for the Advisor Number field. Open the Client table in Design view and change the data type for the Advisor Number field to Short Text. Save the changes to the layout of the table and close the table.ģ. ![]() Open the Advisor table in Datasheet view, add AU # as the caption for the Advisor Number field, and resize all columns to best fit the data. Start Access, open the Support_AC_Financial Services database from the Data Files, and enable the content.Ģ. You will add a caption, change a data type, and create a query, a form, and a report, as shown in Figure 1–56.ġ. The Advisor table contains data on the advisors. The Client table contains data on the clients who use Financial Services. Each client is assigned to a single advisor each advisor may be assigned many clients. Financial Services has a database that keeps track of its advisors and its clients. The company employs a number of trained and certified financial advisors to help their clients navigate the complex world of financial investing. Instructions: Financial Services provides financial planning advise to the community. Please contact your instructor for information about accessing the Data Files. Note: To complete this assignment, you will be required to use the Data Files. Adding a Caption, Changing a Data Type, and Creating a Query, Form, and Report
0 Comments
Leave a Reply. |