Documentation of video shop database.
Documentation of video shop database User guide For the video shop project I created a database on Microsoft access. To get to the database you have to do the following . Turn computer on and log onto the computer. 2. Then once the computer has loaded up double click on the icon which looks like this: 3. Once the programme has loaded up a window will appear and to carry on to access the video database click on OK. 4. Then this window appears and to access the video shop databases double click on OTHER folder. 5. Then another window appears and shows you what the other folder contains. It shows that the video database is in this folder. To access it just double click on it using the right mouse button. 6. Then another window will appear and you have now accessed the video databases. This window appears and shows all the things available on my data base. The table: The table is the main design point for the database. You decide what field names and what special checks should be done into the database to reduce the amount of mistakes. To view the table form of the database you click on which table you want to view (video table, video taken out table or the member table click on the label that says TABLES and then double click on what table you want to see. (Diagram on the next page) Then a table appears showing all the records in that file. Below is the table for
Evaluation, Application & Effects
Evaluation, Application and Effects . Compare using ICT to create your system rather than creating it by hand. Using ICT makes producing the presentation much easier. This is mainly because you can change, edit and move things at a touch of a button without having to completely redo the piece of work. You can add colour and special effects using specialist programmes, making it look unique to other presentations. Also if you did it by hand, if you made a mistake, you would need to cross it out which would make the look less impressive and professional, but using a computer you can easily correct it and it will still look perfect. Also if you want to reproduce a leaflet it would be extremely time consuming whilst on a computer, it would be simple. When producing a leaflet by hand, I would probably use a template to make straight bigger letters, and write all the information by hand with a medium-sized pen. For the photographs, I would print them immediately from the computer, onto photographic paper and then cut the pictures out. I would then glue the photos onto the paper in suitable place. This could then be photocopied to be reproduced, in either colour or black & white, and these could then be made available in the Health Centre. 2. Justify your use of ICT to create your system for the Health Centre. Using ICT makes producing the presentation much easier. It is
Ict Software
DIFFERENCES BETWEEN A COMPTERISED AND MANUAL SYSTEM:- * Computers take up less space, filing cabinets are not needed. * Searching for records is quicker on the computer. * More than one person can access data at the same time from the network pc. * The data stays within comp memory won't get misfiled or lost. * Fewer staff are needed to look after the computer system * Reports can be generated very quickly- by an automated processing routine rather than manually. * Cabinets take up lot of space. * Searching for records takes long time. * Setting up a computer system is very expensive. Big systems in large organisation cost millions. * Computers need people to maintain and use them. * Training costs are high and money is wasted if a person leaves. * Computers are not perfect, if there is a system failure or power cut then important data could get corrupted or lost. * It can be easy to copy files and so remove confidential information of the system. The system has to be kept secure from unauthorised user's and hackers. * Need to employ clerical staff to look after filing system. * Reports can be written only, they have to transfer information by hand. * It is time-consuming and there are chances of human error. * Only one person can access the data at the same time. * Computer's are faster and manual work is very time-consuming. * It is neater and
Hire Shop - creating a database.
Hire Shop Article I. Description of task. I'm going to make my shop a musical hire shop. I'll base the project on a local shop that hires out musical instruments, PA systems, lights and amplification systems. The database will be for the owner of the musical hire shop. It will tell him what has been hired out, who has hired it and it will also identify if someone has still got hired out equipment although there time has ran out. At the moment the shop does use a computer which stores the information about what is hired out and who has got it. It's stored as a list, not as a database. I think a database is a lot easier to use and information is easy to access. It will help run the shop more efficiently and information will be shown quicker and easier. Analysis I interviewed the owner of Faversham's local musical hire shop to find out what the shop does and how everything is stored on its computers. I asked if he would benefit from a new database system designed specially for his shop. He told me that a database system would be a lot faster and easier for him to gain efficient information about the customers and what they have hired from the shop. For the full conversation please see appendix A. I e-mailed a questionnaire to the shop, which mainly included what the users of the system want from the database. It showed that the users want an easily
GCSE IT Evaluation of word processing template documents for the Extreme Sports Club.
Evaluation Original Objectives and End User Requests * The template documents must be able to accessed from the homepage within 3x clicks of mouse * Templates for letters and payment reminders will be created and accessible on the homepage. The documents will have a similar professional look. * Automated tools like macros and fill-in fields will allow data to be put in the correct place easily. * The payment reminder should be easy to personalise with the ability to enter specific details in specific places by having the same layout as the payment reminder template but with different information. * All documents must contain the club logo/house style and the date should be updated automatically. * The payment reminder should calculate itself automatically and place information in the correct places. * Data entry should be made so simple that the letters are 100% accurate. * It should take less than 2 minutes to generate a payment reminder * The system must be robust and easy to use for anyone with basic computer skills. * In the payment reminder a table should be embedded from a spreadsheet into Microsoft Word. The table should be able to be viewed clearly Success in terms of Objectives and End User Requests * The template documents must be able to accessed from the homepage within 3x clicks of mouse This objective was successful. Both the letter and payment
I am designing a database to hold information about a book rental business.
Unit 2 Assignment 1 I am designing a database to hold information about a book rental business. The database will feature tables including information about the members of the book club, the books available to rent and the member - book relations. The following outlines what factors are included in each table and for what reasons. Member: * Membership number: To make sure that member has correct membership card. * Rentee: The name of the member. This is so that I know the name of my member. * Date of birth: To make it easier to recognise customers and to help work out suitability of books for this person. * Address: In case member needs to be contacted. If for example they have an overdue book. This is my final table that I have created for information about members of my library. Book Info: * Book Reference Number: The reference number of that specific book. * Title: Title of book. Useful if member wants to hire a specific book * Author: Name of author. Useful if member wants a specific author * Rental Price: The cost to rent this book for two weeks * Original price: How much this book would cost to buy new * Rentee: The name of the person currently renting the specific book * Date Due Back: The date that the specific book is due to be returned This is my final table that I have created for information on the different books available to rent from my
Managing a bar with spreadsheets.
Managing a Bar with Spreadsheets My project will be based on the College Coffee Bar. I will be designing and constructing a spreadsheet that shall assist the owner or manager of the business. The spreadsheet should allow users to store data such as, items being sold, selling and buying costs. It should also make it easy to calculate profits and losses over a period of time. At the moment the company record their data by hand as they do not have a computer. They store these written files in a large cabinet, which take up large amount of space. The company also find it hard to locate specific files/records. As these are written on paper, they can be easily damaged or lost, and can be difficult to transport from place to place. What I am planning to do should be a radical improvement in reflection with the currant method they are using. Here are my tasks and subtasks in order of which I will complete them: Ø To do this I shall have to create a data capture sheet. I think the easiest and most reliable sources of gaining this information required is to interview Elain Ridgeway and Mrs Sawford who both organise catering for school lunches and special events such as concerts. Ø To make this successful I will firstly have to find out what businesses are currently using so I know what I have to better, I will also be able to ask their views and what they think it should include.
Produce a spreadsheet for a successful and potential company "Belle Du Jour".
Description of task In this project I will produce a spreadsheet for a successful and potential company "Belle Du Jour". The company sells products for special occasions such as wedding dresses, bridesmaid dresses, evening dresses and prom dresses etc. They also sell a range of jewelry and accessories for these special occasions. A spreadsheet will be beneficial to this company as they are very enthusiastic about expanding the successful service they provide customers, but at the moment they are not sure whether this is financially possible. The spreadsheet will help them keep track of their finances in a easy to use format. They would like to expand their business by opening a series of shops in the south east of London. This spreadsheet can supervise Belle Du Jour's finances. This will help to keep track of how much is gained and how much is spent. It will allow us to see how much the company's sales are increasing after the website has been uploaded to the internet. I will be looking to include the following features in my design: * A series of linked sheets involving the company's finances. This will make it easier to manage. The finances are clearer to read when they are on separate sheets. * A summary page of the current financial situation. This page will sufficient to use as you can look at the current balance at a glance. * A page or pages allowing
Formal Report for Task3
Formal Report for Task3 Introduction I am reporting about the documents I have produced in the run-up to the opening of El Tapas Bar, the launch of El Tapas Bar and work on documents produced after the opening of the Restaurant. I produced a variety of documents prior to the opening, including an agenda for a business meeting, minutes of the meeting, internal memos relating to the new Company. Then I produced menus for the new Restaurant, an Adult's lunchtime and evening menu, a children's lunchtime and evening menu and a specials menu for both. I produced advertisements for a Manager and a new Head Chef. I produced an article about the restaurant as though I was a food critic. I produced a newsletter as though I was the editor and writers for the Manchester Catering Guild. Findings: For each of the documents, I have initially created a template for the item, and saved it either in My Documents if I was using Word or Excel or in My Templates if I was using Publisher. Then to create each document, I opened the template and produced each individual document. I saved each task in a logical file structure so I could easily find each document. I reviewed each document at the end for any spelling mistakes or grammatical errors or for anything I had missed out. I used Read & Write Gold to correct any spelling mistakes. I have evidenced this in my evidence file with annotated
The project that I have decided to make will be a Final Fantasy Fan Club.
ANALYSIS INTRODUCTION The project that I have decided to make will be a Final Fantasy Fan Club. I have decided to do this as my project because it is something that I am in to, and therefore I will be able to input a lot of information into the club without having to research too deeply into it. I have decided to call my club 'Final Heaven', I have decided on this because it is a 'final' fantasy club, and it will be a 'heaven' for its members as they will be able to chat with other members and receive exclusive information and offers based on Final Fantasy. My club will have two sides to it. The first side will be a data side, where I will create a member database ready for members of my club, and I will also work out all the finances, which go into my club. The second side will be the media side; with this I will design my own advertising campaign, which h will include a TV advert, posters, flyers and a web page. IDENTIFYING THE PROBLEM At the time of typing this I have only ever seen Internet Final Fantasy fan clubs, these only provide a limited amount of resources, and offer nothing that can be taken away, only the opportunity to talk to other Final Fantasy fans, and see pictures and gain advice. I think that although this is good, there is a lot more which could be offered. So I have decided to try and go the extra step and offer more to the Final Fantasy fans than a