OCR Nationals in ICT 2010 Unit 01 Using

  • Slides: 18
Download presentation
OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) OCR Nationals in ICT Unit 01: Using ICT in Business AO 6(a) – Using databases (Editing) Pupil Name

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) Show to add records to your database: These changes will be made accurately Screen print your database before you add any new records, showing the number of records currently in the database. BEFORE Adding a record Before adding a record

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) Show to add records to your database: Screen print your database after you have added new records, showing the new records and current number of records. AFTER Adding a record After adding a record

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) Show to edit records to your database: These changes will be made accurately Screen print database before you change any data, annotating which records you will change and why? BEFORE Editing a record Before editing a record

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show to

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show to edit records to your database: Screen print database after you have changed the data, show which records have changed. AFTER Editing a record After editing a record AO 6(a) – Using databases (Editing)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) Show to delete records from your database: These changes will be made accurately Screen print the database before you delete any records, showing which records you will delete and current number of records. BEFORE Deleting a record Before deleting a record

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(a) – Using databases (Editing) Show to delete records from your database: Screen print the database after you have deleted a record, show the current number of records. AFTER Deleting a record After deleting a record

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(b)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(b) – Using databases (Queries) OCR Nationals in ICT Unit 01: Using ICT in Business AO 6(b) – Using databases (Queries) Pupil Name

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example of a single search criteria query: What is the purpose of your query? Describe the criteria you will use to carry it out. Show and explain your query design screen Query one design AO 6(b) – Using databases (Queries)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show the

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show the results of your single search criteria query, include the number of results Query one results AO 6(b) – Using databases (Queries)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example of a single search criteria query with a sort: What is the purpose of your query? Describe the criteria you will use to carry it out. Show and explain your query design screen Query two design AO 6(b) – Using databases (Queries)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(b)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(b) – Using databases (Queries) Show the results of your single search criteria query with a sort, include the number of results Query two results

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business An example of a multi-criteria query with a sort: What is the purpose of your query? Describe the criteria you will use to carry it out. Show and explain your query design screen Query three design AO 6(b) – Using databases (Queries)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show the

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Show the results of your multi-criteria query with a sort, include the number of results Query three results AO 6(b) – Using databases (Queries)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(c)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business AO 6(c) – Using databases (Reports) OCR Nationals in ICT Unit 01: Using ICT in Business AO 6(c) – Using databases (Reports) Pupil Name

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 1:

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 1: Screen print a report created using the results from query one. AO 6(c) – Using databases (Reports)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 2:

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 2: Screen print a report created using the results from query two. Address Labels. AO 6(c) – Using databases (Reports)

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 3:

OCR Nationals in ICT (2010) : Unit 01 Using ICT in Business Example 3: Screen print a report created using the results from query three. Table Format. AO 6(c) – Using databases (Reports)