Skip to main content

Posts

Showing posts with the label MS Access

In-Depth Analysis Forecast, Growth & Analysis in Excel

Founded in 2002, Analytics Software provides innovative search software, accessibility testing software, and usability testing software. All serve as part of its desktop and enterprise content management solution for government, corporate, educational, and consumer markets. The company’s solutions are used by website publishers, digital media publishers, content manager, document managers, business users, consumers, software companies, and consulting companies. Analytics Software Instructions: 1) Open Tutorial 6_InDepthAnalysis.xlsx. 2) Save the spreadsheet as Tutorial 6_InDepthAnalysis_Last Name.xlsx. (Replace “Last Name” with your last name.) Weekly Analysis Tab 3) Create a new worksheet tab and name it Weekly Analysis 4) Copy the table provided in Growth, Trends, Forecasts worksheet. 5) Create two pivot tables in the Weekly Analysis worksheet. 1 pivot table using Date and Sales Volume Group by 7 days so you have a sum of Sales Volumes for each week.  1 pivot table...

Bounds Job Opportunities (BJO) Ltd Scenario Database Design & Implementation

Bounds Job Opportunities (BJO) Bounds Job Opportunities (BJO) is an organisation which tries to match people seeking new job opportunities with companies offering employment prospects. BJO have several offices in major cities in the Midlands. Many companies prefer not to advertise vacancies themselves, instead using an agency for the major part of their recruitment. Thus such agencies as BJO place advertisements in the most appropriate websites and newspapers. Each advertisement includes details of one or more jobs. Where a number of jobs are listed in a single advertisement, the vacancies are with a range of companies, rather than each advertisement listing the opportunities available with a single company. BJO operates in a variety of ways. Companies register with BJO (including their name address etc.), notify them of job vacancies and supply a job description for each. Each job description is analysed and the key requirements, such as preferred age range of applicant, skill and ...

MediRAY chain of pharmacies database design & implementation with Queries

MediRAY Chain of Pharmacies The MediRAY chain of pharmacies has decided to develop a database system to store information of their prescriptions, patients, doctors and related details . They have given the development to your company and your manager has handed over the task to you. Below are the requirements Patients and doctors are persons identified by the personal identification number. The person has address, email and phone number. Patients have patient number (the hospital and the patient number used here ), and their names, addresses, and ages must be recorded. Doctors have doctors registration number. For each doctor, the name, specialty, and years of experience must be recorded. Each pharmaceutical company is identified by name, address, email and has a phone number. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If...

Rosslare port football club functional specification document

Project Description This project came about due to a growing need for the members of Rosslare Football club to obtain information on match fixtures, results and for general club information and announcements. Since the introduction of junior teams, parents and members have requested more information regarding the club. The new system will also allow members and non-members to purchase club merchandise and to make donations to the club. The club chairman and the committee will oversee that all objectives and they will ensure they are met. Functional requirements The main functions of the new proposed system are: Member registration and login Inserting, deleting and inspecting members details Inserting and amending match fixtures, results and club details Altering system passwords High-Level Requirements The new system must include the following: Ability to allow both internal and external users to access the application without downloading any software Ability to i...

The Zoo Management System - entity relationship diagram & MS Access Database

Zoo Management System - Project Details: You are the employee of a big, worldwide working Zoo Management Company. Your company is responsible for the Zoo management. Your boss thinks it would be a great idea to store all data for each Zoo in a brand new self-developed ZOO Management System. Up to now, the ZOO management company has maps of each ZOO available. Your boss knows that you took a course in introduction on an ERP system, so he asks you if you could help designing such a system. Each ZOO must have the same organizational structure, which should look like this: Each Zoo has a Zoo-Address. Each Zoo has many visitors (Visitor Ticket Process (VTP). Many Zoo-Attractions belong to a Zoo. Module 1: Entity Relationship Diagram Design a ER (entity-relationship) diagram for your ZOO Management System. Use the information provided below with the entities and its attributes. Put the entities in the correct relationship to each other (organizational structure). Module 2: DB Implem...