Question: (This query will have two different names) d. i. Create a new field name, Age, to calculate the current ages of all clients. The following

(This query will have two different names) d. i. Create a new field name, Age, to calculate the current ages of all clients. The following calculation may be helpful: Round (I n t ( D a t e ( ) - [ D O B ] ) / 3 6 5 . 2 5 ) ii. How many clients are under 25 years of age? Name this query Q5-Under25. (Hint: "Where" clause may be helpful.) 6. A PIVOT chart showing the results of Q2-Followers might be more effective. Create this chart with suitable labels in a spreadsheet MGMT2006_MSS_first name_last name.xlsx. 7. Using the 'Query on Followers', remove the client's name from the criteria. Add fields to show Replies, Likes, Shares, and Clicks. Create a report grouped by the client's name and sorted by the brand. Show each client's details, summary fields, and a grand report total. Give suitable report headings that are appropriately adjusted and legible. For printing purposes, ensure the report prints each client on a new page, with alternate lines shaded and the title on each page. Rearrange the fields on the report to prevent overflow of information and extra pages. Name the report 'Report of Daily Followers by Client - October 20xxx. 8. Create a switchboard named MGMT Software Solutions Client Menu System. Include TWO queries, the database report, and an Exit option. In the bottom right-hand corner, create a label using an 8-point font that states that you made the switchboard. For example, 'Created by .' Hints: Consider the "where" and "expression" clauses

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!