1 / 19

Do it now activity

Do it now activity. Activity: A travel agent is trying to create a database to collect information about people who are booking a flight. He is having a few problems and needs your help!

nevina
Download Presentation

Do it now activity

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. Do it now activity Activity: A travel agent is trying to create a database to collect information about people who are booking a flight. He is having a few problems and needs your help! Look at the information below, then match each Data box to the correct Field box. For example, the Data ‘Morecambe’ matches the Field ‘Town’. FIELD DATA Morecambe Town 44 Cost Dr. First Name £149.99 Postcode Paul House Number LA1 4FH Title 11/12/2005 Date booked

  2. Activity: How did you do? Your next task is to enter the Data Type for each Data/Field pair by clicking on the box and typing a word from one of the following options: TEXTNUMBER CURRENCYDATE/TIMELOOKUP* For example, the Data/Field pair Morecambe/Town has the Data Type ‘Text’. * The data type Lookup is when you can only enter a choice of data. DATA FIELD DATATYPE Morecambe Town Text 44 House Number Dr. Title £149.99 Cost First Name Paul Postcode LA1 4FH Date booked 11/12/2005 When you are ready, go to the next slide.

  3. DATA FIELD DATATYPE Text Morecambe Town Number 44 House Number Lookup Dr. Title Currency £149.99 Cost Text First Name Paul Text Postcode LA1 4FH Date booked Date/Time 11/12/2005 Take a look at the answers below. Did you enter the correct Data Types?

  4. Learning AIM I can create a database which is fit for purpose

  5. Learning objectives • Create a database • Input information into your database and check it for errors

  6. Learning objectives I can create a database which is fit for purpose By the end of the lesson you will be able to FiltersData Queries Database Reports Interrogate

  7. Learning objectives I can create a database which is fit for purpose Creating a database • Detective Turner and his team of detectives have been busy interviewing people. The team has now interviewed everyone using your questionnaire. This information is taking a long time to sort through, and they are having difficulties finding the information they need. • By the end of this tutorial you will be able to: • Create a database • Input information into your database and check it for errors FiltersData Queries DatabaseReports Interrogate

  8. Database theory

  9. What is a database used for? • A database is a computerised system for storing large amounts of information in electronic format. • It allows the user to find specific records, and sort and filter the data stored within it to provide useful reports.

  10. How does a database store information? A database is built from tables of data, each table contains records, and each record contains fields. A record is a complete set of information about a person or thing. For example: one person’s name, date of birth, address. A fieldis one piece of information such as Surname.

  11. Record Can someone identify a Field Name? Can someone identify a Record? Field Name

  12. Field Names Data Types Surname Text Number AutoNumber Date/time Yes/no Currency Forename House number Street Town Postcode Telephone number Date of birth

  13. Naming fields Fields usually have a maximum of three words in their name. For example, the question ‘What is your surname?’ would have the Field Name ‘Surname’. Now decide what the following Field Names could be. ‘What number is your house?’ could have a Field Name of: ‘What is your date of birth?’ could have a Field Name of: House number Date of birth

  14. Learning objectives I can create a database which is fit for purpose get started Download the document from Weebly. Make short, one or two word versions of the questions. These we will use for field names. First to finish gets principal reward! Go through the embedded document from Weeblyto learn about database theory. FiltersData Queries DatabaseReports Interrogate

  15. Learning objectives I can create a database which is fit for purpose Design field names and question types Download the document from Weebly called data types. design a database Now you need to go to: Programs -> Microsoft Office -> Access 2010 to begin designing your database. Watch the short video below to see how to do it. FiltersData Queries DatabaseReports Interrogate

  16. Learning objectives I can create a database which is fit for purpose Design field names and question types http://www.youtube.com/watch?feature=player_embedded&v=W17YbJ9-yX8#t=22 FiltersData Queries DatabaseReports Interrogate

  17. Learning objectives I can create a database which is fit for purpose Add your information from your questionnaire! You can now enter the information from the three questionnaires that your classmates completed in Tutorial 2. Watch Skills Demo 3e on entering information onto your database first. Now it's your turn to enter your data. Remember to save the table again when you have entered all the information FiltersData Queries DatabaseReports Interrogate

  18. Learning objectives I can create a database which is fit for purpose Round it up!! Now play an interactive game to test student knowledge of data types! FiltersData Queries DatabaseReports Interrogate

  19. Learning objectives I can create a database which is fit for purpose I can … FiltersData Queries Database Reports Interrogate

More Related