1 / 131

ICDL

it. internet. windows. ICDL. presentation. word. database. spread sheet. Microsoft Access. First step. Form. Table. Report. Relationship. Main operations. Print. Query. First step. Create a new blank database

yehudi
Download Presentation

ICDL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. it internet windows ICDL presentation word database spread sheet

  2. Microsoft Access First step Form Table Report Relationship Main operations Print Query

  3. First step • Create a new blank database • Create a database using the option that will enable you to build your database using pre-set options. • Save this database as Company into desktop. • Log on to the database named library with the username osman and password ali*56 • Which two of these statements about relational database are true? • Close the Company database without closing Microsoft access. • Use Microsoft Access Help to find information about format painter. • Use click and drag to sort these labels into the correct boxes.Click SUBMIT when you have finished. • Which one of the following is not a database? • Which two of the following is not a database?

  4. Create a new blank database First step

  5. SUBMIT Try again

  6. Create a database using the option that will enable you to build your database using pre-set options. First step

  7. SUBMIT Try again

  8. Save this database as Company into desktop. First step

  9. SUBMIT Try again

  10. Log on to the database named library with the username osman and password ali*56 osman ali*56 First step

  11. SUBMIT Try again

  12. Which two of these statements about relational database are true? • A non-relational database can be searched mores efficiently than a relational database. • A relational database is easier to maintain than a non-relational one. • In relational database the need for data duplication is increased • Smaller linked tables are harder to manage than one big one. • A relational database is one that contains linked tables. SUBMIT First step

  13. Close the Company database without closing Microsoft access. First step

  14. SUBMIT Try again

  15. Use Microsoft Access Help to find information about format painter. First step

  16. SUBMIT Try again

  17. Data base Not a Data base Use click and drag to sort these labels into the correct boxes.Click SUBMIT when you have finished. Sales catalogue Student register Novel Shopping list Customer Records SUBMIT First step

  18. Which one of the following is not a database? • A telephone directory. • A sales catalogue. • A newsletter. • A price list. SUBMIT First step

  19. Which two of the following is not a database? • Student register. • Mail order catalogue. • Newsletter. • Novel. • Bank statement SUBMIT First step

  20. Table • Enter the field name Customer Name into the empty row.When you have finished, move the insertion point to the Data Type column. • Change the enter in the Firstname field of this record to Islam.Move to the next field in this record when you have finished. • Please delete the selected field value, Ahmed, from its record. • Enter the name mai into the first name field. • Using click and drag, move the selected column to between the salary and address column. • Navigate quickly to the last record in this table • Enter a record for a full-time employee name Ahmed Ali into this table. • Save and close this table. • The address field will be used in a lot of searches, so we should index it. Create a suitable index for this field.

  21. Specify that date of birthday field in this table display in the format 10 September 1989. • Which one of the following statements about setting the field size property in a table is True? • Enter the validation rule to ensure that entries into this field must be numbers greater than 30 . Press Enter when you have finished. • Enter the validation rule to ensure that entries into this field must be either the words Full-time or Part-time. • Select the data type that will automatically assign a unique employee ID number to each new employee.Move to the next cell when you have finished. • The customerID field contains a unique reference for each customer . This field will be used in a lot of searches, so we should index it. Create a suitable index for this field. • How many fields would be necessary to store this record and enable maximum flexibility for data retrieval?

  22. Enter the field name Customer Name into the empty row.When you have finished, move the insertion point to the Data Type column. Table

  23. SUBMIT Try again

  24. Change the enter in the Firstname field of this record to Islam.Move to the next field in this record when you have finished. Table

  25. SUBMIT Try again

  26. Please delete the selected field value, Ahmed, from its record. Table

  27. SUBMIT Try again

  28. Enter the name mai into the first name field. Table

  29. SUBMIT Try again

  30. Using click and drag, move the selected column to between the salary and address column. Table

  31. SUBMIT Try again

  32. Navigate quickly to the last record in this table Table

  33. SUBMIT Try again

  34. Enter a record for a full-time employee name Ahmed Ali into this table. ali ahmed Full-time Table

  35. SUBMIT Try again

  36. Save and close this table. Table

  37. SUBMIT Try again

  38. The address field will be used in a lot of searches, so we should index it. Create a suitable index for this field. Table

  39. SUBMIT Try again

  40. Specify that date of birthday field in this table display in the format 10 September 1989. Table

  41. SUBMIT Try again

  42. Which one of the following statements about setting the field size property in a table is True? • If you change the First Name size proerty to 20, existing data will not change. • If you decrease the First Name field size, data will not be lost. • you can’t change the First Name field size because the table contains data. • If you increase the field size for the First Name field, the data will be processed faster. SUBMIT Table

  43. Enter the validation rule to ensure that entries into this field must be numbers greater than 30 . Press Enter when you have finished. Table

  44. SUBMIT Try again

  45. Enter the validation rule to ensure that entries into this field must be either the words Full-time or Part-time. Full-time or part-time Table

  46. SUBMIT Try again

  47. Select the data type that will automatically assign a unique employee ID number to each new employee.Move to the next cell when you have finished. Table

  48. SUBMIT Try again

  49. The customerID field contains a unique reference for each customer . This field will be used in a lot of searches, so we should index it. Create a suitable index for this field. Table

  50. SUBMIT Try again

More Related