Database Structure - Lagan College

Database Structure - Lagan College

Database Structure 1 of 11 Boardworks Ltd 2010 This lesson will cover: The basic structure of a database. Setting up a database using field names. Understanding different data types. Icons key:

For more detailed instructions, see the Getting Started presentation Flash activity. These activities are not editable. Teachers notes included in the Notes Page Student task accompanies this slide 2 of 11 Web addresses Functional Skills check Printable activity Boardworks Ltd 2010

Why do we need structure? If data is in a structured format it can be retrieved easily. Why else is structure important? 3 of 11 Boardworks Ltd 2010 Database structure A database is made up of: Tables Tables are composed of all the records in a database.

Records Records are usually the rows in a database, they are divided into fields for ease of use. Fields Fields are normally the columns. Each record is made up of many fields (like name, address etc.) to enable searches to be performed more easily. 4 of 11 Boardworks Ltd 2010 Database structure

If we take an electronic address book as an example: Your address book is the table. Every row contains one record. 5 of 11 Fields are the sections into which the data is divided. Boardworks Ltd 2010

Label the database 6 of 11 Boardworks Ltd 2010 Database software Many software packages exist to create databases. The most common software for basic databases is Microsoft Access, but other software will have the same features as this. Computerized flat file databases are the equivalent of a written

table or ledger, but the data is more secure and a lot tidier. Computerized databases make it much easier to find records and can quickly produce reports and labels. 7 of 11 Boardworks Ltd 2010 Beginning a database When creating a database, the first thing you will need to do is enter in your field names.

You do this by choosing: Create table in Design view You can then add in the fields that you require for your database. These will appear as the column headings along the top row of your database. 8 of 11

Boardworks Ltd 2010 Data types When creating your fields, you also need to specify the data types that will go in these fields. The data types which you are most likely to use are: Text For inputting text. Number For numbers, decimals and percentages. Date/Time For dates and times. Currency For financial sums and amounts. AutoNumber Automatically

adds in a sequential number. Yes/No For selecting yes/no or true/ false entries. 9 of 11 Boardworks Ltd 2010 Which data types? 10 of 11 Boardworks Ltd 2010

True or false 11 of 11 Boardworks Ltd 2010

Recently Viewed Presentations

  • Lecture II - Tel Aviv University

    Lecture II - Tel Aviv University

    Lecture 12 Auditory Binaural Pathway Neural Auditory pathway Auditory Nerve Cochlear Nucleus Medial Superior Olive Lateral Superior Olive Lateral lemniscus Inferior Colliculus Medial geniculate nucleus Primary auditory cortex Schematic Representation of the Brainstem Auditory Pathway Brainstem ...
  • 2- Meter Sideband Operating

    2- Meter Sideband Operating

    Yagis are pointed NW to NE and signals sound raspy with a buzzing sound. Digital modes are ineffective. It requires high gain Yagi antennas with reasonable power (150 watts+), but has been completed with low power and low gained antennas....
  • Restriction Enzymes

    Restriction Enzymes

    Restriction Enyzmes - molecular scissors able to cut DNA HOW DO RESTRICTION ENZYMES WORK? Usually cut DNA at a "palindrome" such as GAATTC. Palindrome - word or phrase when spelled backwords, spells the same word or phrase Ex. BOB MADAM...
  • What We Have Learnt From The 20th Century

    What We Have Learnt From The 20th Century

    產業環境管理理念的發展趨勢 顧洋 台灣科技大學化學工程系
  • 355 Geoscience for Elementary Educators

    355 Geoscience for Elementary Educators

    355 Geoscience for Elementary Educators Author: Sciencea2z Last modified by: Sciencea2z Created Date: 3/17/2008 6:43:22 PM Document presentation format: On-screen Show Company: Science From A To Z Other titles: Times New Roman Arial Calibri Constantia Wingdings 2 3_Flow 2_Flow Lets...
  • Building Academic Vocabulary in the High School Classroom

    Building Academic Vocabulary in the High School Classroom

    2 thoughts about building academic vocabulary you will take back to share with a colleague are… 1 thought about building academic vocabulary you will embed into your teaching practice is… * * Learning Intention We are learning how to effectively...
  • Health and Human Services - Governor Tom Wolf

    Health and Human Services - Governor Tom Wolf

    In recognition of the growth of the aging population, the need to connect services at the community level with the Medicaid program is greater than ever. These synchronized efforts will enhance and allow for the expansion of home and community-based...
  • The United States of America

    The United States of America

    Marshall Court. It is not the first, but most important early Supreme Court . Marshall Court. It marks the first expansion of the . role of the Supreme Court . It's decisions began the expansion of the role of the...