CASE BACKGROUND MGMT Software Solutions (MSS) is a company that works with young clients to increase their popularity on various social networks. After all, likes and views can be a ticket to fame for upcoming artists. That is, they want to follow friends; retweets are the social currency of the 21st century. MSS also negotiates to have its clients wear, advertise, use a product or brand, or even interact with a celebrity to increase their online visibility. MGMT Software Solutions collects as much data as possible from its clients' followers. This data is generated when a follower retweets, clicks "Like," or creates a comment, thus creating a demographic profile of that follower. For example, MSS has clients Collins, Acadia, Julia, and Tyler. When Collins' friends like his profile picture, Facebook tracks who his most famous friends and family are. Why? Those persons, in turn, 'like' products, services, and celebrities information valuable to those advertisers. When Acadia 'likes' dozens of brands on Facebook, those brands can learn more about potential customers - all of her friends. When Julia and her friends retweet news about The Hunger Games or the Wedding Ringer, the movie studio can track their responses in real-time. When Tyler searches YouTube, Google (which owns YouTube) can track his every move and push content that may appeal to him, including other videos of young and upcoming artists, to start their popularity. This is where the currency of 'likes' and retweets and searches turns into actual currency. The selfies each client takes so that others will like them on Instagram helped that company sell for a billion dollars. Sending a tweet helped raise the value of Twitter to around $30 billion, while Facebook is valued at approximately $140 billion. You have been asked to help the company analyze some of this data on its new clients and check the data to see who has new 'followers' for the day. First, you need to peruse the database. It comprises the following tables: MGMT2006 - Management Information Systems

BRAND: The Company has negotiated client contracts to use these brands.

CLIENT: The names of MGMT Software Solutions' clients

FAN: Followers of the company's clients

SOCIALWEDAPP: Various social media and apps, along with some statistics

You are asked to prepare several queries, as well as some reports.

Project Requirements

MS ACCESS

You are given a database - MGMT2006_202324S02_MSS Student File. accdb, containing Brand, Client, Fan, and SocialWedApp tables to provide some results for MGMT Software Solutions. You should:

1. Rename the database as MGMT2006_MSS_ is your actual name. [[NB! ONLY DO THIS WHEN YOU UPLOAD WITHIN THE ASSESSMENT DROPBOX]]

2. Create relationships between pairs of tables and enforce referential integrity.

3. Add FIVE new clients and associate them with a brand.

4. Also, add TEN new followers along with their information.

5. Create the following queries:

a. List the followers who use WhatsApp. Name the query Q1- WhatsApp.

b. Produce the list of clients along with the number of followers. Show the client the most followers first on the list. Name this query Q2- Followers.

c. Using the name of the client with the most followers from Q2- Followers:

i. List the brand that this client is associated with. Name this query Q3-Brand.

ii. Produce a count of the brands this client's fans follow. Include the brand name (BrandID.Value) and the client's name. Sort the list in descending order of brand. Name this query Q4- BFollowers. Save the query again as 'Query on Followers' MGMT2006 - Management Information Systems (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 when using the totals options for queries.

POWER BI 1.

Whether you installed Power BI or plan to use the Web Service:- a. Use the pbix file provided on the course page.

2. Save your file as MGMT2006_MSS_first name_last name, where is your actual name.

3. Create the following Power BI dashboard on one page: An area chart showing the number of artist types for each parish. Insert a dotted line representing the average number of artist types. Label the axes and append an appropriate title to the graph. A pie chart showing the number and percentage of male and female clients. Append an appropriate title to this chart. A brand description slicer.

(i) Select a brand and insert a short note regarding its popularity.

(WORD) REPORT FOR SUBMISSION

To satisfactorily complete this part of the project, you should prepare a written report based on the Access queries and reports: Create a Word OR PowerPoint OR Video REPORT saved as MGMT2006_MSS_first name_last name, where is your actual name:

1. A cover page comprising the UWI Open Campus title, course code and course name, the instructor's name, the semester, and due date.

2. A section discussing the findings [[25 - 50 words]] of each query. Include copies of the query results. This means you should:

(a) Type the question asked. (For example, 'List the fans who use WhatsApp ')

(b) Report on the findings from your query. That is a sentence or two on the query's results related to the business. Identify any outstanding (exceptional) information that may arise from the query, IF APPLICABLE. Then, include the actual query. (Cut and paste your query from your Access database that answers this question into your Word document.)

(c) Type the following question and repeat point #2.

3. A copy of 'Report of Daily Followers by Client - October 20xx' that is exported from your database. (See handout on how to achieve this.)A copy of your chart from Excel.

Remember, this is a report that you 'should' submit to the administration of MGMT Software Solutions. Be professional in your reporting and presentation.