Microsoft Access Project

In: Computers and Technology

Submitted By amriuum
Words 640
Pages 3
BKAS3093 Project
BKAS3093 Project
iskandar SOA
iskandar SOA

Individual Project – 20%
Due Date: 9 March 2014 before 2.00PM
Place: Room 2.15

Individual Assignment 1 – 20%
Early year 2013, you established a new bowling alley in Sintok, Kedah. After a long discussion with some bowling alley suppliers locally, the initial capital needed to start the business is RM1 million. You and two other partners had contributed RM200 000 each. OCBC bank had approved your long term loan application for amount RM500,000, 5% monthly compounded for 15 years, effective on 1 Feb 2013. The monthly payment is made at every end of monthly payment term. The cost for bowling alley is RM900,000 and was constructed on 1 March 2013 by Ampang Superbowl Malaysia Sdn Bhd (ASMSB). ASMSB agreed that the payment arrangement would be made as follows: * 50% on 1 March 2013 * 30% on 2 July 2013 * 10% on 15 Oct 2013 * 10% on 15 Jan 2014

In addition, you also borrowed from CIMB bank to acquire a new building located at EDC Hotel. EDC Hotel agreed to sell the building for RM300,000 on 15 April 2014. CIMB bank approved your loan application for amount RM250,000, 4% quarterly compounded for 10 years, effective on 1 July 2013. However, the quarterly payment should be made at beginning of quarterly payment term. The payment arrangement with EDC Hotel as follows: * 40% on 31 April 2013 * 30% on 15 August 2013 * 30% on 15 Jan 2014
1 November 2013, you had contributed RM100,000 as an additional business capital, later 1 Jan 2014 both of your partners also contributed RM50,000 each.
All excess cash is kept in PBB bank in Changlun. The excess cash will be used to acquire other capital expenses (CAPEX) and operating expenses (OPEX) for bowling business. The depreciation rate is 5% per year for buildings and bowling alleys.

Requirements*: a)…...

Similar Documents

Microsoft Project Tutorial

...CS 587 Software Project Management Instructor: Dr. Atef Bader MS Project Tutorial MS MS Project in Labs: Available in Siegal Hall Lab in Main Campus Available in Room 210 Rice Campus Prepared by Milton Hurtado How to get MS Project ? How Download MS project from following link Embarking new Project Embarking Go to file, select new. This will open a screen for blank project click ok. You can now enter your project information viz. start date, finish date and also how would you like to schedule the project from either start or finish date. You can also chose selection if you will be using night shifts. Gantt Chart Gantt Select Gantt Chart view from the view menu. You’ll have a spreadsheet where you can now enter information of all the activities i.e. task name, duration, start date, end date, predecessors and various other fields. You can enter required information in two ways, in spreadsheet or when you double click on cell you get pop up window in which you can enter all the information of that particular activity. For predecessor activity you need to write activity number. The SW itself will calculate start and end date. Now the Gantt Chart is complete. Adding tasks and milestones to a Project File Adding 1. 2. 3. 4. 5. 6. On the View menu, click Gantt Chart. In the Task Name field, type a task name, and then press TAB. (Microsoft Project enters an......

Words: 2605 - Pages: 11

Microsoft Access Program

...then explain to him about using Microsoft Access program. I would explain to him all of the features and functions and the task that Access could do for him and his business such as, he could create a program where he could keep all of his data from him veterinarian business by using tables, queries, forms and reports and he can connect them together with a function called the relationship feature. I would begin by showing him how using tables would keep all of the company’s data or information on all of his records for each animal and also would explain how simple task can be programmed through the use of macros that have easy functions such a point and click options. Next I would explain to him that the creation of tables will work or correspond with certain animal records and each row works for a certain animal with has all of the information for that certain animal. Next I would talk about the other features of using Microsoft Access such as using a query interface function, the different forms that can be used to place information in, plus using reports that can be printed. Reports will provide the capability to quickly create summaries of the data contained in one or more tables and or queries, by using the wizards function the user can create reports very easily and it takes less time. After explaining all of this to Jack I need to remember that he is probably going to totally overwhelmed with all of this information about Microsoft Access especially if he has never......

Words: 1271 - Pages: 6

Microsoft Access Assignment

...Francis Adams Microsoft Access Assignment 1. The twin’s best approach would be to approach both Visa and Mastercard. Those are the two most frequently used by the customers, and both is used across state boundaries in enough frequency to warrant involvement in both. 2. Hotmail Accounts | LastName | FirstName | Email | State | Kelly | Val | | TX | Michaels | Baylee | | AR | Randolph | Danette | | TX | Burgerman | Gladys | | OK | Parish | Loubna | | KS | McMann | Fred | | LA | Wallace | Mark | | TX | Burma | Kincaide | | TX | Peter | Kowalski | | OK | 3. Current Member Cities Living in Texas | State | Total Of MNo | Baton Rouge | Benton | Bunkie | Clairemore | Clinton | College Station | Commerce | Crossett | Dallas | Dodge City | Emporia | Kansas City | Lavender | Little Rock | McAlester | Miami | Midland | Monroe | Muskogee | North Oaks | Oklahoma City | Pine Bluff | Sherman | Silver | Tulsa | Waco | Weatherford | Wichita | Winnfield | TX | 11 | | | | | | 1 | 1 | | 1 | | | | | | | | 3 | | | | | | 3 | 1 | | 1 | | | | 11 total 4.Total revenue generated by Texas is $249.89 5. kansas query | InitialContactDescription | KS | Another Web Site | 2 | Friend | | Magazine | 1 | Newspaper | | Other | 1 | ......

Words: 340 - Pages: 2


...98-366 Networking Fundamentals Preparing for MTA Certification for Cert ca n Certification MICROSOFT TECHNOLOGY ASSOCIATE (MTA TECHNOLOGY ASSOCIATE (MTA) ECHNOLOGY C (MTA A) STUDENT STUDY GUIDE F UDY FOR IT PROS 98-366 Networking Fundamentals Authors Shari Due (Networking). Shari is an IT Network Specialist Instructor at Gateway Technical College in Racine, Wisconsin where she has worked for the past 15 years. Previously, she worked for Digital Equipment Corporation (DEC) in Elk Grove, Illinois. She holds a Bachelor of Science from the University of Wisconsin-Parkside in Math and Economics with a minor in Computer Science and a MBA from the University of Wisconsin-Eau Claire. Shari’s current industry certifications include: Comptia Server+, Linux+, A+, Network+, and i-Net+. Her past certifications include: MCSE-NT 4.0, CCNA, and Pathworks for Macintosh. She is a Cisco Certified Instructor for Cisco’s Network Academy and teaches the CCNA curriculum. She is the author of Advanced WordPerfect Using Macro Power: A Guide for VMS and DOS Users from Digital Press. Patricia Phillips (Lead Author and Project Manager). Patricia taught computer science for 20 years in Janesville, Wisconsin. She served on Microsoft’s National K-12 Faculty Advisory Board and edited the Microsoft MainFunction website for technology teachers for two years. For the past five years she has worked with Microsoft in a variety of roles related to K-12 curriculum development and pilot programs......

Words: 12317 - Pages: 50

Microsoft Project

...Microsoft project do provide the feature of auto generating 6 different categories of reports which includes Overview Reports, Current Activity Reports, Cost Reports, Assignment Reports and Workload Reports. In Overview Reports, there are 4 types of reports which are Project Summary report, Top-Level Tasks report, Critical Tasks report and Milestones report. Project Summary report is to show users high-level information and at the end of the report it will show the overall task status which includes the number of pending, in progress and completed tasks. Top-Level Tasks Report is to shows the planned schedule with information straight from summary table. Critical Tasks Report is to show how delayed critical tasks may bring impact to the other tasks. Milestones report is to show the list of milestones so that user can see how the project is achieving. In Current Activity Reports, there are 6 types of reports which includes Unstarted Task report, Tasks Starting Soon report, Tasks In Progress report, Should Have Started Tasks report, Slipping Tasks report and Completed Tasks report. Unstarted Tasks report is to show the list of tasks that have not started yet together with whether the task is on time, early or it is late. Tasks Starting Soon report is to show tasks that are going to start or finish in the date range that user specified. Tasks In Progress Report is to show the list of tasks that are currently in progress and also their status. Should Have Started Tasks......

Words: 733 - Pages: 3

Benefits of Using Microsoft Access

...Efficiency and collaboration proposal Benefits of using Microsoft Access Microsoft Access is a database application included in Microsoft Office, which helps businesses to save money. The different components and features make Microsoft access easy to use. The database application is beneficial to the work environment and offers a quick-learning format (Demand Media, Inc., 1999-2012). People can create an operational database in less than one-hour when importing information from other Microsoft Office applications (Demand Media, Inc., 1999-2012).Microsoft Access is capable of taking information from the enterprise software. More than one person can access or use the database at a time. People can add, delete, and update information instantly without the knowledge of programming languages (Demand Media, Inc., 1999-2012). Beginners can use the database wizard to create database objects and relationships that has easy to follow instructions. The database application helps to avoid errors and duplicates of data. The application is compatible with word and excel. There is no database code needed to perform database functions where with other applications a code is required. Microsoft Access has predesigned database templates allowing people to add data immediately without developing a template (Demand Media, Inc., 1999-2012). A business would benefit from Microsoft Access because most businesses grow and collect data over the years. The business can use the application to...

Words: 267 - Pages: 2

Access to Care Project

...Access to Care Project Lane Community College William Bennett Scott Dawson Shana Perkins Assigned scenario: Summer is a 15 year old sophomore at South Eugene High School. She is 5 months pregnant. She lives at home with her parents in a home near the corner of Potter Street and 21st Avenue. Summer and her boyfriend would like to keep the baby. Summer’s boyfriend Jake is talking about moving into Summer’s parents’ house but Summer’s parents are not so sure that they want Jake living with them. a. What prenatal resources are available to Summer? b. How much will prenatal care cost? c. Is it likely that Summer’s prenatal care and the baby’s medical care be covered by her parents’ standard medical insurance policy? What criteria, if any need to be met? d. What post-partum resources are available to facilitate Jake’ & Summer’s parenting skills? e. Summer would like to transfer to Churchill High School to participate in their child care program. What bus route will Summer need to take to get from her parents’ home to Churchill High School? NOTE* Our group identified local medical coverage networks including Peacehealth, Oregon Medical Group (OMG) and Private Payer. We chose to gather data from OMG and assumed the insurance coverage of the parents covers services on an approved provider list limiting her to the OMG network. Questions: Community resources available to teen parents are numerous and qualification is based on......

Words: 1990 - Pages: 8


...Vision of Microsoft: “A personal computer in every home running Microsoft software.” Mission of Microsoft: “At Microsoft, our vision and values are to help people and businesses throughout the world realize their true potential.” Values at Microsoft: As a company, and as individuals, we value integrity, honesty, openness, personal excellence, constructive self-criticism, continual self-improvement, and mutual respect. We are committed to our customers and partners and have a passion for technology. We take on big challenges, and pride ourselves on seeing them through. We hold ourselves accountable to our customers, shareholders, partners, and employees by honoring our commitments, providing results, and striving for the highest quality. Introduction About Microsoft Microsoft Corporation is a software company based in Redmond, Washington. Microsoft's flagship product, the Windows operating system, is the single most popular operating system for home desktop use. Its other desktop products, namely Microsoft Office, Internet Explorer, and Windows Media Player, are either bundled directly with the Windows operating system, or are often sold together with Windows as preinstalled software on new computer systems. The company also manufactures and sells computer hardware such as keyboards and mice, owns several content-distribution channels such as MSNBC, the MSN Internet portal, and the Microsoft Encarta electronic encyclopedia. The Microsoft Windows operating system was......

Words: 1847 - Pages: 8

Microsoft Access Proposal

...level. Microsoft access is a database application system that manages and organizes data in a way that allows the information that has been stored to be retrieved from multiple sources. MS Access has the look and feel of other MS Office products and has a similar layout which will simplify the changes. Implementation of Microsoft Access We currently use Microsoft Excel to store our data even though it is not a database. Moving data to Microsoft Access by importing from Excel will let us test the waters every step of the way. We will be able to use Access reports, forms, filtering, sorting, and querying with Excel data. Access is designed for all user types but as with any new system requires time and use to get comfortable with. Benefits of Microsoft Access Microsoft Access is a low cost business tool that fills many business needs. Microsoft Access is user friendly and is similar to other Microsoft Office Applications. As the business continues to grow and change Microsoft Access is able to be upgraded and intergraded into other systems. There are templates and wizards to help you build your database or you can build it from scratch. Multiple departments can retrieve information for various queries and reports. The application is flexible and speedy allowing for a quick look at information or a detailed report. In conclusion in order to provide our customers with the service they deserve and desire, we need to move forward and upgrade our system. We will have......

Words: 332 - Pages: 2

Microsoft Access Database Terms

...There are numerous terms used in the Access database. Some of the more common terms are, Form, Layout, Design, Table, Query & Report. If a user is not familiar with Access or has very little knowledge they would probably need to have these terms explained to them. A Form is the easy to use screen where they enter Their data and the Layout is where they would modify the size, formatting or position of the controls. They would be able to see their data as they work to change the layout which is extremely useful on helping them to set everything up the way they want it. Design is the area where they would modify or change the Header, Footer or details of a section or the entire form. The Table is where all of their data is located in a spreadsheet-like view and they can have several tables with data that they can bring together by using a Query. The Query is the tool that allows them to select, organize and present the specific information they want on a report. The Report is the presentation of that information in whatever format they feel is the best for their needs. It could be something simple for personal use or something elaborate for a business meeting. The knowledge base of the customer is going to determine how extensive the explanation of the terms needs to be. It’s very possible that a more detailed description of each term would need to be given to someone brand new to using Access. Someone who has more experience is going to be familiar with most of the...

Words: 348 - Pages: 2

Acct 504 Final Financial Statement Analysis Project (Oracle vs Microsoft)

...ACCT 504 FINAL FINANCIAL STATEMENT ANALYSIS PROJECT (ORACLE VS MICROSOFT) A+ Graded Tutorial Available At: Visit Our website: Product Description ACCT 504 Final Financial Statement Analysis Project (Oracle vs Microsoft), Your Course Project Financial Statement Analysis Project—A Comparative Analysis of Oracle Corporation and Microsoft Corporation Here is the link for the financial statements for Oracle Corporation for the fiscal year ending 2011. First, select 2011 using the drop-down arrow labeled for Year on the right-hand side of the page, and then select Annual Reports using the drop-down arrow labeled Filing Type on the left-hand side of the page. You should select the 10k dated and choose to download in PDF, Word, or Excel format. Here is the link for the financial statements for Microsoft Corporation for the fiscal year ending 2011. You should select the 10k dated 7/28/2011 and choose to download in Word or Excel format. A sample project template is available for download in Doc Sharing. The sample project compares the ratio performance of Tootsie Roll and Hershey using the 2009 financial statements of Tootsie Roll and Hershey provided in Appendix A and Appendix B of your......

Words: 937 - Pages: 4


...Microsoft Company Analysis Kevin Roberts Matthew Ponder Joseph Horton Strategic Management Arkansas State University Introduction Microsoft is a company centered around today’s constantly growing and evolving technology field. From company servers, to Laptops, even tablets and smartphones. Microsoft is expanding its horizons to keep pace with, or even out perform its competitors. Microsoft’s corporate strategy centers around their product being accessible to customers in many different ways. This access based strategy differentiates itself from other companies in the same industry, like IBM, Apple, Google, Oracle, and the like. This industry, that most people would just consider “technology” or “computers”, is divided up into several sectors. Microsoft obtains most of its profits from the sale of its enterprise software and licenses, making this their primary industry, while secondaries include, but are not limited to, smartphone manufacturing, Nokia, PC manufacturing, the Surface, Gaming, the Xbox 36 and Xbox One, and other software products. Microsoft is a corporate giant covering many major countries, but no company is completely flawless. They are actually projecting to have reduced profits over the next few years. This along with the software industry moving to cloud-based computing, open-source software becoming more popular, Windows mobile devices not taking off as expected, and hacker threats to their Operating Systems, are issues that......

Words: 1566 - Pages: 7

Project: Access Control Proposal

...Project: Access Control Proposal * Phase I: Risk mitigation plan to identify critical IT assets * Phase II: Policies and procedures for protecting the IT assets Contents I. Introduction 2 II. Diagram of the proposed solution 3 III. Phase I:Access Control Risk Mitigation 3 1. Identified Treats and vulnerabilities 3 2. IT assets 4 3. Treats and vulnerabilities per IT Domain 4 4. The System Security Team 5 5. Access Control Plan 5 IV. Phase II: Policies and procedures for protecting the IT assets 6 1) General Security Practices for VPN Remote Access 6 2. Protecting Cyber Assets: Secure Interactive Remote Access Concepts 7 2. How Employee Accesses the Corporate Network 9 3. How external Partners (Vendor) Access the Corporate Network 9 V. Conclusion 13 I. Introduction Access control mechanisms operate at a number of levels in a system, from applications down through the operating system to the hardware. Higher-level mechanisms can be more expressive, but also tend to be more vulnerable to attack, for a variety of reasons ranging from intrinsic complexity to implementer skill levels. Most attacks involve the opportunistic exploitation of bugs; and software that is very large, very widely used, or both (as with operating systems) is particularly likely to have security bugs found and publicized. Operating systems are also vulnerable to environmental changes that undermine the assumptions used in their design. The main function of......

Words: 2458 - Pages: 10

Microsoft Access or Microsoft Sql Server: What's Right in Your Organization

...Microsoft Access or Microsoft SQL Server: What's Right in Your Organization? SQL Server Technical Article Writers: Luke Chung Technical Reviewer: Matt Nunn Published: December 2004, revised July 2006. Applies To: SQL Server 2005 Summary: This paper explains how Microsoft® Access is used within an organization. It also explains when to use Access and when to use Microsoft SQL Server™. Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights......

Words: 6412 - Pages: 26

Microsoft Project

...Step-0 Don’t use iLab You don’t need to, as long as you have a copy of Microsoft Project installed on your computer (either because you already own it, or because you are using a work machine that has it, or because you downloaded your free unrestricted copy from DeVry, or downloaded a trial copy from Microsoft, whatever). Step-1 If you want to use the version in iLab…. 1. First we have to find it. It used to be a link in Course home called iLab [pic] Now we have to search it out (*sigh*). Soooo, select Student Resources from the left hand navigation at Course Home [pic] Step-2 in the About The|Hub box in the top right hand corner of the window click on iLAB [pic] Step-3 click on Go to Citrix Link in the links box in the top right hand corner of the window [pic] You will get a pop up message telling you what login to use: [pic] Type in your user name and password Step-4. Click on the MS Office 2010 folder [pic] Step-5 Select Project 2010 [pic] I get this pop up (you may not), and I reply YES [pic] Step-6 And there you are — now the problem is how do you save your project file after you build your schedule??? [pic] Step-7. After you have worked on your project entries – click File/Save As [pic] Step-8. Now chose Computer (you need to map to your own local hard drive to save the file. YOU DO NOT WANT to SAVE your file on the DeVry server because that file is...

Words: 585 - Pages: 3