GCE ICT Data Processing Assignment User Guide Database
Contents
1. contains no data The field Customer Details House Number cannot contain a Null value because the Required property For this field is set to True Enter a value in this field oO FE You should add a number to this field Any number is acceptable up to a length of 15 characters E g 12 This means that the field contains no data You should add text to this field Any name is acceptable up to a length of 15 characters E g High Street 28 Area Fes cent ii ticedlccess Ed This means that the field contains no data Please Enter Area details You should add text to this field Any name is acceptable up to a length of 15 characters E g Belfast This Postcode means that the field contains no data You should enter a postcode into this field E g BT78 OLL This means that the field Contact ie Number contains no data The field Customer Detale Contact Number cannot contain a Null value because the Required property For this field setto True Enter a value in this field You should add a number to this field Any number is acceptable up to a length of 8 digits E g 91235478 29 Field Error Message Reason 7 You have typed in a Forename with 16 characters Only 15 allowed Forename PART IN The field is too small to accept the amount of data you attempted to add Try inserting or pasting less data Surname You have ty2. printing over Due Stack Ikems bo the Microsoft Office Document Image Writer on Microsoft Document Imaging Writer Port cancel 17 Making an Order Not all data entry items are displayed Each item appears when you select the previous item this ensures that you enter data into all necessary fields Choosing the employee choice Make an Order Cee Select Employee Return To Main Menu Choosing the customer choice Make an Order Ss Select Employee Customer Name Doherty John Jones Freddy Return To Main Menu gt Entering the date hired Make an Order Select Employee Customer Hame Return To Main Menu Sarah Jones Se hal Freddy Date Hired 18 When all items are displayed Return To Main Menu Order Number Doherty 0171272008 4 ee dd Stock item to orde SUL Bp i A i i Fedro Bronze Silk Dress Knee Length Ek Complete Order Lucas Blue Designer Blue Cotton Le a I l l oA LDelinkh AE I a E Ir Record 14 4 2 gt PL b of 2 Order Number Number is generated by the computer Employee You are required to select an employee This is the person who makes the customer order Customer You are required to select a customer If it is a new customer you will need to go to the add customer page Date Hired Enter a value date into the date hired field Stock Item Choose a stock item from the list Quantity Enter
3. the number of stock items required Add Stock item to order Add the stock item to the order You can add multiple items to an order 19 Browse Orders Return to Main menu Customer Details Order Details 26 01 2008 Order Number Date Hired J Oo 285 0172008 Order Details Tabs b4 This for can be used to browse through all orders It is grouped by Customer Number The Customer details are displayed and all the customer orders can be viewed Using the tab options you can view all the items relevant to that order You can use the Next Order and Previous Order to go back and fourth through the orders 20 Letters for Over Due Stock Joanne Brown Jalenhue Park Belfast RE Over Due Stock Items E Elegant Attire Dear Customer We are wrintinato inform you that you boroweda ays overdue There is an additional fine of 2 pound for each day over due Your current outstanding balance is s Jun sterling We look forward to hearing from you soon Regards L Regan Manager Elegant Attires This option will create letters for all customers who have over due stock items in their possession All items circled will be updated for each customer It will calculate when the item should have been returned and how many days it is overdue The outstanding balanced is also calculated 21 Customer Invoice Order Number 3 House Forename Surname Street
4. Area PostCode Jones Freddy 22 Cregagh Rooa Belfast BT 4DR Stock Item Number Description Quantity Price Net Price Silk Dress Knee Length 1 272 70 272 70 Total Price fala iO Vat op 17 3 FAT Te Price plus Vat E3a l 4a This option will be generate an invoice from the Orders There will be an invoice for each order created The order number will be displayed The Customer details will appear All stock Items created will be displayed The total price for all stock items for each order only will be totalled The vat will be calculated at 17 5 percent of the total price The Price plus vat will be the total price plus vat 22 Sales in Last Seven Days Date Hired by Month January 2008 Date Hired 28 0 1 2008 Order Number 4 Employee Humber 2 Employee Forename Sarah Employee Surname Jones Stock tem Name Date Hired Quantity Lucas Blue 28 01 2008 J Fedro Bronze 26 01 2008 3 This report displays all orders that were ordered in the last seven days It can be used by managers to see what employees have taken orders The most recent stock that is order can be viewed and the quantities It can be used for Statistics 23 Changing the Password B Nace ICT New CCEA ICT My Recent Documents My Documents My Computer SSS ee Files of type Microsoft Office Access b PEN CALS Open Exclusive Read Only If you plan to change your password you need to open the database and chan
5. GCE ICT Data Processing Assignment User Guide Database Background amp Aims and Objectives Elegant Attire is a small local family business set in Northern Ireland The company specialise in formal Hire for both men and women Their customer base is largely focused on A Level students and they cater for all the needs for the Christmas or end of year affairs Elegant Attire is very aware that this is an extremely important occasion and aspires to ensure full satisfaction of their customers They have always used a paper based system but as their company is expanding they have found it necessary to introduce ICT to help them with their orders and invoicing There has been on a few occasions that stock has not been returned on time to have it washed and ready for another big formal They are hoping that this new system can create easily reminders to send to those A level students who may forget the return date of what they hired Hardware and Software Requirements Hardware Prosessor es aan ae 300MHz IMB cache Hard Disk 20GB 20GB Ay Graphics Card 128MB m o Mouse Software Windows Vista professional Home Opening the Database Jocuments User s Guide ve A Recycle Bin Adobe Reader 6 0 E Learning MSN Installer Resources i S McKinney r Learning Resourc j About Windows Messenger W Windows Catalog an Accessories Administrative Tools T Adobe Adobe Acrobat Profe
6. ck There are three options to choose from in relation to dealing with customer details Add Stock Item This is an ideal method of adding new Stock details to be stored and can be used later to make an order Search for a Stock Item Also it 1s possible to search for stock details if you require contacting them by phone or checking their address Delete a Stock Item Likewise if a stock item is discontinued it is recommended that the details are removed from the system Returned Stock Order You can choose this option when stock that has been hired is returned Update all stock prices by 1 This will update all prices of stock by 1 Print Letters for overdue stock This will print all letters for posting to those customers who have not returned items ordered 14 Stock Main Menu Add a Stock Item Stock Item This is generated by the computer Return to main menu Stock Item You can add text to this field AutoN umber Name Any name is acceptable up to a length of 15 characters E g _ dress supplies Brand Name Add Stock Item You can add text to this field Any name is acceptable up to a length of 25 characters E g Description description of the garment Price You can only numbers to this field Supplier This must be chosen from a list Sizes available This must be chosen from a l
7. en deleting records For example when deleting a Customer if the customer have made an order then it is necessary to delete the order first before the database will allow the deletion of the customer In doing this it ensures that no stock is on hire to a customer that does not exist Return to Main Menu Forename Doherty SUT anie John L h ma g y House NumbDer Se Skreet Coolpark Road Belfast This error message 1s security as it lets you know this customer has placed an order Order must be deleted first 31 Error Messages on the Make an Order There are two fields that may return error messages when making an Order They are e Date Hired e Quantity The first is the Date Hired Field VElccwsl MO ee Gi a Select Employee E Sarah Jones Customer Name 5 Jones Freddy s Date Hired 12 08 JA Choose your Stock from the list Microsoft Office Access Date needs to be todays date or later If you receive this message it means that the date is probably in the past Just delete and enter an appropriate date It should be today s date or a date in the current week Make an Order i Customer Mame Jones Freddy a Date Hired 13 13 08 The value you entered isn t valid for this field For example you may have entered text in a numeric Field or a number that is larger than the FieldSize setting permits CaA Drews Call Nea F annm l m mtble da Eoo me Th
8. eries Replication Workgroup Administrator Reports Startup User and Group Permissions Fages Macro User and Group amp ccounts Macros Actives Controls User Level Security wizard Modules Add Ins Encode Decode Database GutoCorreck Options Favorites Customize S Switchboard Options gt On the main menu select Tools then Security then Set Database Password 23 Set Database Password Password a a Cancel Verify kkkt Type the new password in twice The next time you open the database is will use this new password 26 Troubleshooting Entering the Wrong password When loading the database initially If you accidentally enter the wrong password you will get the following error message Enter the appropriate password to continue Password Required Eg Enter database password A Mot a valid password Error Message for incorrect password 21 Trouble Shooting on the Add a Customer Form Forename Be nenftfirewdlncess x This means that the field Please Enter 4 Forename contains no data 3 You should add text to this field Any name is acceptable up to a length of 15 characters E g Mary Surname This means that the field contains no data You should add text to this field Any name is acceptable up to a length of 15 characters E g Boyle House Uiorentt Office Access I This means that the field Number 7
9. ge the option on opening to exclusive Microsoft Access GCE ICT Database Access 2000 file format fee File Egit View Tool Wi cow Help Spelling F7 Rial 2 Office Links Speech Objects c Tables E Queries Online Collaboration Relationships Analyze Database Utilities Reports Pelle Replication Workgroup Administrator Macros Startup User and Group Permissions Modules Macro User and Group Accounts Groups Actives Controls User Level Security Wizard E Favorites Add Ins Encode Decode Database AutoCorrect Options Customize Options On the main menu select Tools then Security then Unset Database Password 24 Fo Microsoft Access Objects Create Form in Design view Delete Employe Create Form by using wizard Delete Stock 4dd Customer yay Unset Database Password wales aI Reports al Pages 2 Macros amp Modules Groups GE Favorites Browse Details Password Customer Orders subform Customer Orders subform Customer Orders subForm2 Customer Orders subform S Stock Details Customer switchboard Stack switchbo Delete Customer Switchboard li il il il il Ql ic ic il il OC AS alli j gt You are required to verify the current password Microsoft Access Spelling Office Links Speech Relationships E 5 Delete Enmploye Tables anaie i Delete Stock Qu
10. ime you want to finish or have made a mistake and selected the wrong menu optior you can simply click the return to Main Menu button 11 If you are aware of a customer number then you can quickly search for customer details using the search facility Return to Main Menu Enter Parameter Value fx Flease Enter Customer number Search For a Customer a Delete a Customer Type the Customer number into the dialogue box e g 8 Press ok You will be brought to the customer search details page where you can read the record you searched for Customer Details Customer Number Forename Surname House Number Stee Coolpark Road BT 86ND SOF S0b23 12 Delete a Customer Return to Main Menu Coalpark Road elfast IBT 8 END iM Delete his Customer gt CY When you find the customer you wish Click on these buttons to browse to delete click this through the customer records or button select from the list box Microsoft Office Access You are about to delete 1 record s IF you click Yes you won t be able to undo this Delete operation re vou sure you want bo delete these records You are required to click yes if you are willing to delete the record 13 Stock Main Menu Menu Stock Add Stock Item Search For a Stock Item Returned Stack Update all stock prices by 1 Z Delete a stock Item O L E Print letters For overdue sto
11. is message refers to a date that does not exist e g the 13 month Remove the value and re enter an appropriate date 32 The second is the Quantity Field Return To Main Menu r dd Our Poli and 20 items only can be hired Number 7 i You entered a value less that 0 or greater than 20 You can delete this value and enter an appropriate quantity Stock Item You are not allowed to choose the same Stock Item more than once in an order Just choose another Item Microsott Office Access The changes vou requested to the table were not successful because they would create duplicate values in the index primary kev or relationship Change the data in the field or fields that contain duplicate data remove the Index or redefine the index to permit duplicate entries and try again 33
12. ist Add Stock Item Click the add stock item to add details 15 Type the stock number into the dialogue box e g 8 Press ok You will be brought to the stock search details page where you can read the record you E Microsoft Access Search for Stock Select Query ae Edt View Insert Format Records Took Window Hep Type a question A A i te i oc ter ne i i Fed TT Sik Dress Knee my l HR AutoNumber i Use the navigation keys to browse through the stock records When you find the stock item you wish to delete click the delete button Microsoft Office Access You are about to delete 1 record s A If you click Yes you won t be able to undo this Delete operation 4re you sure you want to delete these records a EJ Delete this stock ltem d o All fields are disabled with exception to the Returned tick box ae You will be able to tick this box if the order items have been Customer Number EZE Date Hired returned Employee Number 16 Return to Main Menu update the Price field of all stock stock will be increased Microsoft Office Access by 1 You are about to run an update query that will modify data in your table Are you sure you want to run this type of action query For information on how to prevent this message from displaying every time you run an action query click He The report will be sent to the printer for overdue stock MS Printing X Mow
13. ped in a surname with 16 characters Only allowed 15 characters Microsoft Office Access The field is too small to accept the amount of data you attempted to add Try inserting or pasting less data House You have typed in a house number with 6 numbers Only allowed 5 numbers Microsoft Office Access Number iN The field is too small to accept the amount of data you attempted to add Try inserting or pasting less data Street You have typed in a Street with 16 characters Only allowed 15 characters Area You have typed in a Area with 11 characters Only allowed 10 characters Microsoft Office Access i The field is too small to accept the amount of data you attempted to add Try inserting o pasting less data Postcode You have typed ina Postcode with 8 characters Only allowed microsoft Office Access The field is too small to accept the amount of data vou attempted to add Try inserting or pasting less data 30 Type in a Contact number with 11 numbers Contact Fine Number The field is too small to accept the amount of data you attempted to add Try inserting or pasting less data Gender Select a Gender You are not allowed to type anything other than digits in this field Surname Fei 4 The value you entered isn t valid for this field WY fi example you may have entered text in a numeric Field or a number that is larger than the FieldSize setting permits Error Messages wh
14. r Suton umber Take note that you are not required to enter a customer number this option is disenabled The system will calculate the customer number Filling in the details on the Add a Customer data entry form Return to Main Menu Forename You can add text to this field Any name is acceptable up to a length of 15 characters E g Mary Surname You can add text to this field Any name is acceptable up to a oo length of 15 characters E g Boyle House Number You can add a number to this field Any number is acceptable up to a length of 15 characters E g 12 Street You can add text to this field Any name is acceptable up to a aw length of 15 characters E g High Street Area You can add text to this field Any name is acceptable up to a length of 15 characters E g Belfast You must enter a postcode into this field E g BT78 OLL Contact Number You can add a number to this field Any number is acceptable up to a length of 8 digits E g 91235478 Gender This is a list box and you have two options to select from Male and Female 10 Adding the record amm O I I I O O O U Return to Main Menu igh Road elfast t46 SLL 917564830 Add Customer After you select the final field Gender the Add Customer button will appear and you can click on this and all the details will be added to the database system You have the option to add another customer If at any t
15. rd Menu Microsoft Access Main Switchboard 3 File Edit view Insert Format Records Tools Window Help Type a question for help X Formal Hire Customer T Employee lad Stock Customer Employee Stock Make an Order Letters for overdue Stock Invoices Sales in the Last Seven Days OOU COU OCU WOE Browse Orders This is the Main Menu Switchboard You can choose various options from here All other forms are linked to this point to avoid disorientation Customer Employee and Stock have further submenus Customer Menu After selection of the Customer Option from the Main Menu switchboard you will be directed to the customer sub menu where you choose options specific to dealing with a customer Customer EET here are three options to choose from in relation to dealing with customer details Add Customer This is an ideal method of adding new customers details to be stored and can be used later to make an order Search for a Customer Also it is possible to search for customer details if you require contacting them by phone or checking their address Delete a Customer Likewise if a customer informs the company that they no longer want to be a customer it 1s recommended that they their details are removed from the system Add a Customer Upon selection of the option Add a Customer from the Customer sub menu you are brought to the Add a Customer data entry form LUstomer N Umbe
16. rt menu Core Programs Microsoft Office Access FD Microsoft Access BAR Type a question for help Get External Data we Close Microsoft Save Ctrl 5 Office Online Save S Connect to Microsoft Office Export Online MT File Search Get the latest news about using Access Web Page Preview Automatically update this list From Page Setup More Print Preview ab a Search for Send To Example Print more than one copy 1D 45 Dataprocessing GCE ICT mdb A 2 45 Dataprocessing GCE ICT mdb 3 AS Data Processing GCE ICT mdb 4 D REALDAY DB NWIFHE mdb es ee ae Select from the Main Menu File and then scroll down to select Open Mew CCEA ICT My Recent Documents My Documents cL My Computer File name Files of type microsoft Office Access Choose the Location where the file is stored The database is called GCE ICT Enter the Password The following dialogue box will appear The password is password Password Required I Enter database password Enabling all the functions within the database security Warning Opening N45 Cataprocessing Siobhan45 Data Processing GCE ICT mdb This file may not be safe if it contains code that was intended to harm your computer Do you want to open this File oreante A dialogue box will appear then and you will be required to click Open Main Switchboa
17. ssional Adobe Premiere 6 LE an Apple an Apple Software Update an 4rt and Design T Blackcat fan Core Programs an Creative 0 FinePixviewer T Teacher Tools m winzip I Adobe Reader 6 0 Windows Media Player 33 Windows Messenger E windows Movie Maker an iTunes T Philips Digital Audio Player ran Sony Ericsson a Adobe Photoshop Album Starter Edition 3 0 Internet Explorer ay Learning Resources P Microsoft Office Aci amp Microsoft Office Access Snapshot ViewelCreate databases and programs to track and manage your information by using Microsoft Office Access a Microsoft Office Document Imaging 2 E mail FUIIFILM Learning NI ran Games Internet E IcT Z Microsoft Office Document Scanning Internet Explorer A Pod 38 Microsoft Office Excel 2003 ay Microsoft Office Wor Van Library Microsoft Office InfoPath 2003 T Logotron Microsoft Office Outlook 2003 is Solitaire m Macromedia Microsoft Office PowerPoint 2003 an Macromedia Studio Mx Microsoft Office Publisher 2003 Windows Media Playe fan MatchWare W7 Microsoft Office Word 2003 Microsoft Office Accel 2 Microsoft Office CD winzip 9 0 T MicroStaff WINASPI E Calculator M Private Folders an QuickTime an QuickTime for Windows abt ctirld M Research Machines an Science T Screen utility Symantec Client Security From the desktop load Microsoft Office Access In this case it is found under the sta
Download Pdf Manuals
Related Search