Creating a database consisting of two tables

• 1 слайд

  Lab 6:
  
  System database. Fundamentals of database management systems: concept, characteristics, architecture. Data Model. Normalization.
  

• 2 слайд

  2
  Objectives
  learn how to create a table with the help of templates and tables Designer tables;
  • Provide the correct input of data into the table;
  • learn how to perform the sorting of records in the table.
  

• 3 слайд

  3
  Microsoft Access is a powerful relational database application that you can use to store all kinds of data from a simple list of recipes to a catalog with tens of thousands of products. After the data is stored in an Access database, it's easy to;
  Find the related data;
  Analyze, manage, manipulate, and retrieve the data;
  Display the information as a chart, graph, or Web page;
  Print or publish user friendly reports;
  Automate auto repetitive tasks;
  Export the data to other programs such as Microsoft Excel and Microsoft Word.
  

• 4 слайд

  4
  Аs stаted eаrlier, the Nаvigаtion pаne stores the objects in your dаtаbаse: tаbles, queries, forms, reports, mаcros, аnd modules. Objects аlwаys displаy with аn icon to the right. The icon tells you the object type:   tаble,  query,   form,  report,  mаcro, аnd   module.
   Tаbles. In Аccess, dаtа is stored in tаbles. А tаble is а set of columns аnd rows, with eаch column referred to аs а field. Eаch vаlue in а field represents а single type of dаtа. Eаch row of а tаble is referred to аs а record.
  
  
  

• 5 слайд

  Queries.You use queries to retrieve specific dаtа from your dаtаbаse аnd to аnswer questions аbout your dаtа. For exаmple, you cаn use а query to find the nаmes of the employees in your dаtаbаse who live in а pаrticulаr stаte.
  Forms.Forms give you the аbility to choose the formаt аnd аrrаngement of fields. You cаn use а form to enter, edit, аnd displаy dаtа.
  Reports.Reports orgаnize or summаrize your dаtа so you cаn print it or view it onscreen. You often use reports when you wаnt to аnаlyze your dаtа or present your dаtа to others.
  Mаcros.Mаcros give you the аbility to аutomаte tаsks. You cаn use а mаcro to аdd functionаlity to а form, report, or control.
  Modules.Like mаcros, modules give you the аbility to аutomаte tаsks аnd аdd functionаlity to а form, report, or control. Mаcros аre creаted by choosing from а list of mаcro аctions, whereаs modules аre written in Visuаl Bаsic for Аpplicаtions.
  5
  

• 6 слайд

  6
  

• 7 слайд

  7
  Creating a database consisting of two tables
  
  
  Task 1. Create a database - Training facilities.
  1. Start Microsoft Access database program. To do this: Start - All Programs - Microsoft office - Microsoft office Access 2007.
  2. In front of you opens the following form of window (Figure 8):
  3. Select the new database. Then enter the file name - Training facilities and click Create. You will see a window similar to the following (see Figure 9): Training facilities.
  
  
  

• 8 слайд

  Task 2. Create a table "Groups".
  1. Create a table named "Groups" with the Table Designer. To do this, run the following command: Create - Table Designer.
  2. Fill in the Name field the following data (column headers): Study group, teacher and therefore the data type for them: Study group - numeric, Teacher - TEXT. Make the "Study Group" key by placing the cursor on the name field and click on the button Key field  .
  3. Save the table as " Group" by clicking on the button Save .
  4. Close the table.
  
  8
  

• 9 слайд

  Task 3. Creating the table "List".
  
  1. Create a table named "List" using Table Designer. To do this, run the following command: Create - Table Designer.
  2. Fill in the Name field the following data (column headers): code, name, patronymic, year of birth, class, Study Group. Choose from the drop-down list of numeric data type for the field "Code". Make the "Code" key, moving the cursor on the name field and click on the button Key field . Type of data fields "Name", "Name", "Middle" - text, the fields "Year of Birth", "School", "class" - numeric. Set the field's data type "training group" number. General field properties do not change. Choose Substitution tab, type control - combo box, the source lines - Groups. Get the values ​​of the elements, as shown in the figure (Figure 10).
  3. Save the table as "List" by clicking on the button Save .
  4. Close the table.
  
  9
  

• 10 слайд

  10
  Task 4. Create a data scheme.
  1. In the ribbon menu choose the tab Working with databases , click the data Scheme. Appears window data Scheme.
  2. In the window that appears, Adding a Table select a table "Groups" and click the button Add, select the table "List" and then click the button Add. In the data scheme will be conditional form of these tables. Close window Adding table.
  3. "List" table Enlarge the window so that you can see all the fields.
  4. Position the mouse cursor over the field name "Study Group" in the table "Group" and, without releasing the mouse button, drag the mouse cursor to the "Study Group", "List" table. Release the mouse button. The dialog box Change Association, represented in the figure (Figure 11).
  5. Select Ensuring data integrity. It can not be done if the field types "Study Group" set is not the same.
  6. Check the cascade update related fields. This will lead to the fact that when you change the group number in the table "Group" automatically changes the number in the "List" table.
  
  
  

• 11 слайд

  7. Check the cascade delete relationships. This will lead to the fact that when you delete a record with the number of groups "Groups" table will delete all records from the table "List", in which there were corresponding group numbers.
  8. Click Create. You will see the connection, "one-to-many". The schema is shown in Figure (Figure 12).
  9. Close the chart data by clicking the button in the upper right corner of the window and answered in the affirmative to the question of data retention scheme.
  11
  

• 12 слайд

  12
  

• 13 слайд

  13
  1. Save your entries. Name form - List. Close the form.
  2. Go to the window Table. Open the table List. Make sure that in the table there are new entries.
  3. By clicking on the button Save to save the current table.
  4. Close the table.
  7. Check the Target cascade update related fields.
  1. Open table the "Group".
  2. Correct the number of study groups at 201, 202, 203, 204, 205. Save the table.
  3. Open the table "List". Make sure that the value of the field "Study Group" changed. Close the table "List".
  

• 14 слайд

  Task 8. Control of cascade delete related fields.
  1. Open table the "Group".
  2. Delete the first record (Select the first row, call the context menu with right-click of mouse and select Delete entry).
  3. Answer yes to the removal request. Close the table "Groups".
  4. Open the table "List". Make sure that disappeared from the record group 201 number.
  Present to teacher: table Groups, the table List on the screen, List form.
  Task 9. Closing the Access program.
  1. Choose File - Exit.
  2. If you are editing in the database, you are asked to save changes. Answer in the affirmative.
  
  14
  

• 15 слайд

  15
  Key terms. Puzzle
  

• 16 слайд

  16
  

• 17 слайд

  17
  

• 18 слайд

  18
  

• 19 слайд

  19