Transcript

1 Lab 1 Introduction to Access. Creation of tables Database (DB) is an ordered set of data intended for storage, accumulation and processing by means of a computer. To create and maintain databases (update them, provide access on request and issue data on them to the user), a set of language and software tools called a database management system (DBMS) is used. 1. Access database objects Access database objects include: 1 Tables are designed to store data in an orderly manner. 2. Queries are for searching, retrieving data, and performing calculations. 3. Forms are designed for easy viewing, changing and adding data in tables. 4. Reports are used to analyze and print data. 5. Data access pages are designed to view, enter, update and analyze data over the network or from anywhere on your computer. 6. Macros are used to execute a common set of macros that process data. 7. Modules are designed to describe instructions and procedures in the VBA language. The main object of the database is a table, which consists of records (rows) and fields (columns). At the intersection of a record and a field, a cell is formed that contains data. Each field in the table is assigned a unique name that cannot exceed 64 characters. Each field contains data of the same type. 1 Koshelev V.E. Access Practical Guide. M., S

2 Data types Type Text Field MEMO Numeric Date / Time Currency Counter Boolean OLE Object Field Hyperlink Substitution Wizard Description Used to store character or numeric data that does not require computation. The Field size property specifies the maximum number of characters that can be entered in this field. By default, the size is set to 50 characters. The maximum number of characters that can be contained in a text field, 255 Intended for entering text information exceeding 255 characters; can contain up to characters Designed to store numerical data used in mathematical calculations. On the General and Lookup tabs, you can set properties for a numeric field, including Field Size, Field Format, Number of Decimal Places Used to represent the date and time. The choice of a specific date or time format is set in the Date format property. It is intended for storing data, the accuracy of which ranges from 1 to 4 decimal places. The integer part can contain up to 15 decimal places. Designed for automatic insertion of unique sequential (increasing by 1) or random numbers as the new record number. The number assigned to the entry cannot be deleted or changed. Fields with this data type are used as key fields of the table. Designed to store one of two values \u200b\u200binterpreted as “Yes / No”, “True / False”, “On. / Off " Contains data created by other programs that use the OLE protocol. This can be, for example, Word documents, Excel spreadsheets, pictures, sound and video recordings, and others. OLE objects are linked to or embedded in an Access database. You cannot sort, group, or index fields of OLE objects. Special type for storing hyperlinks. Designed for automatic field detection. It will create a combo box from which you can select data contained in another table or in a set of constant values \u200b\u200b2

3 Creating a database 1. Start Microsoft Access Click the button. 3. Name the new database "Notebook.accdb". 4. On the Create tab of the ribbon, on the Tables toolbar, click the Table Design button. 5. Enter the field names and specify the data types to which they apply. Field name Data type p / p Counter Surname Text Name Text Address Text Index Numeric Phone Text Hobby Text Email e-mail Hyperlink 6. Exit Constructor mode after saving the table under the name "Friends"; do not specify key fields. 7. Open the table "Friends" by double-clicking and fill in 10 lines in it. 8. Add the fields "Patronymic" and "Date of birth", for this: 1) place the cursor on the field before which you want to insert a new column; 2) run the command: ribbon tab Table mode toolbar Fields and columns Insert; 3) by double-clicking on Field1, rename it to "Patronymic", and Field2 to "Date of birth". 9. Switch to the Design mode with the command: tab of the ribbon Home Modes Design. 10. For the field "Date of birth" set the data type Date / Time; in the field properties, select Short Date Format. 3

4 11. Format the table as follows: 4) the grid color is dark red; 5) the background color is blue; 6) text color is dark red, size 12 pt, italic style. 12. Rename the Hobbies field to Hobbies. 13. Delete the entry numbered. Resize the cells so that all data is visible. To do this, just double-click the left mouse button on the border of the fields. 15. Arrange the fields in the following order: Last Name, First Name, Patronymic, Phone, Date of Birth, Hobbies, Address, Zip, Photo, E-mail. 16. Fill in the blank cells in the table. 17. In Design mode, add a field "Marital status", which will contain a fixed set of values: married, not married, married, not married. To create a drop-down list, we will use the Substitution Wizard: 7) set the Substitution Wizard data type; 8) in the dialog box that appears, select the line "A fixed set of values \u200b\u200bwill be entered" and click Next; 9) the number of columns is 1; 10) enter the details of the list married, not married, married, not married; 11) click Finish. 18. Use the drop-down list to fill in the new column. Since the table turned out to be wide, some inconveniences arise when filling out this column: the surname of the person for whom the "Marital status" field is filled in is not visible. To make the last name permanently visible when filling out the table, you must use the Freeze Columns command from the context menu of the Last Name field. 19. Show the work to the teacher. 4

5 Test questions 1. What is called a database (DB)? 2. What is a database management system (DBMS)? 3. What is the difference between Microsoft Excel and Microsoft Access? 4. What Microsoft Access database objects do you know? 5. What is the main object in the database? 6. What are called fields and records in the database? 7. What types of data do you know? 8. How can I rename a field? 9. How can I create a dropdown box? 10. With what extension is the Access database file saved? five

6 Lab 2 Creating relationships between tables 1. Start Microsoft Access Let's create a database "Company". Employees of this organization work with clients and fulfill their orders. If you put all the information in one table, then it will become very inconvenient to work with. It will start repeating data. Every time an employee Ivanov works with a company, you will have to re-register the data about the employee and the client, as a result of which many mistakes can be made. To reduce errors, you can split the source table into multiple tables and establish relationships between them. It will be more rational than before. Thus, you need to create 3 tables: Employees, Customers and Orders. Employees Field name Data type Employee code Counter Surname Text Name Text Patronymic Text Position Text Phone Text Address Text Date of birth Date / Time Salary Money Photo Object OLE E-mail Hyperlink 6

7 Customers Field name Customer code Company name Address Phone number Fax E-mail address Notes Data type Counter Text Text Text Numeric Hyperlink Field MEMO Orders Field name Order code Customer code Employee code Placement date Execution date Amount Completion mark Data type Counter Numeric Numeric Date / Time Date / Time Monetary Logical 3. Separate tables containing information on a specific topic must be linked into a single database structure. Key fields must be specified to link tables. A key consists of one or more fields whose values \u200b\u200buniquely identify each record in the table. The most suitable as a key field is "Counter", since the values \u200b\u200bin this field are unique (that is, do not duplicate). 4. Open the Employees table in Design view. 5. Right-click on the Employee ID field and select the Key field command in the context menu that appears. If you need to set several key fields in the table, you can select them by holding down the Ctrl key. 6. For the Customers table, set the key field Customer Code, and for the Orders table, Set the Order Code. 7

8 7. The Orders table contains the fields Employee Code and Customer Code. When filling them out, some difficulties may arise, since it is not always possible to remember all the enterprises with which the company works, and all employees with a code number. For convenience, you can create drop-down lists using the Lookup Wizard. 8. Open the Orders table in Design view. 9. For the Employee ID field, select the Lookup Wizard data type. 10. In the window that appears, select the command "The lookup column object will use values \u200b\u200bfrom a table or query" and click the Next button. 11. In the list of tables, select the Employees table and click Next. 12. From the Available Fields list, select the Employee Code field and click the arrow button to enter the field in the Selected Fields list. Add the Last Name and First Name fields in the same way and click the Next button. 13. Select the sort order for the list by the Last Name field. 14. In the next dialog box, set the desired width of the drop-down list columns. 15. Select the Hide Key Column check box and click Next. 16. In the last step of the Lookup Wizard, replace the label for the lookup field if necessary and click Finish. 17. Create a drop-down list for the Customer ID field in the same way. 18. After creating the key fields, you can start creating links. There are several types of relationships between tables: 12) in a one-to-one relationship, each key field record in the first table corresponds to only one record in a related field in another table, and vice versa. This type of relationship is not used very often. In- 8

9 where they can be used to split tables containing many fields to separate part of the table for security reasons; 13) in the case of a one-to-many relationship, each record in the first table corresponds to several records in the second, but the record in the second table cannot have more than one related record in the first table; 14) in a many-to-many relationship, one record in the first table may correspond to several records in the second table, and one record in the second table may correspond to several records in the first. 19. Close all open tables, as you cannot create or modify links between open tables. 20. Run the command: ribbon tab Work with databases button. 21. If earlier there were no links between the database tables, then when you open the Data Scheme window, the Add Table window opens at the same time, in which select the Employees, Customers and Orders tables. 22. If relationships between tables have already been set, then to add a new table to the data schema, right-click on the data schema and select Add Table from the context menu. 23. Establish a relationship between the Employees and Orders tables. To do this, select the Employee Code field in the Employees table and drag it to the corresponding field in the Orders table. 24. After dragging, the Edit Links dialog box will open (Fig. 1), in which enable the Ensure integrity condition check box. This will prevent you from deleting records from one table and leaving the associated data from other tables unrelated. nine

Fig. 10 1. Creating a relationship between tables 25. The check boxes Cascade update of related fields and Cascade delete of related records ensure the simultaneous update or deletion of data in all subordinate tables when they change in the main table. 26. Communication parameters can be changed by clicking the Union button. 27. After setting all the necessary parameters, click OK. 28. Establish the relationship between the Clients and Orders tables yourself. 29. The result should be the data schema shown in fig. 2. Fig. 2. Data Scheme 10

11 This example uses one-to-many relationships. In the data schema, they are displayed as connecting lines with special icons next to tables. A one-to-many relationship is marked with a "1" near the master table (which has a primary key) and near the subordinate table (which has a foreign key). A one-to-one relationship is marked with two “1s” (both table fields have primary keys). An indefinite relationship has no signs. If a union is set, its direction is indicated by an arrow at the end of the connector (none of the combined fields are key and have no unique index). 30. In the Employees table, enter the data for seven employees. 31. In the table Clients enter data on ten companies with which this firm works. 32. In the Orders table, fill out several orders received by the company. 33. Show the work to the teacher. Test questions 1. With what can you create tables? 2. What is a key field? 3. How to set multiple key fields? 4. How to establish relationships between tables? 5. What are the relationships between tables? 6. What do "1" and mean in the data diagram? 7. Why is the Substitution Wizard needed? eleven

12 Lab 3 Selecting Data Using Queries Queries are the primary means of viewing, filtering, modifying, and analyzing information that is contained in one or more tables in a database. There are various types of queries, but the most common are fetch queries, so let's start our acquaintance with them. 1. Open the Firm database you created earlier. 2. Run the command: Create ribbon tab Query Wizard Simple Query. 3. In the dialog box that appears (Fig. 3), specify the Employees table and select the Last Name, First Name, Phone fields. Click "Next. Figure: 3. Create a simple query 4. Enter the query name Phones and click Finish. You will be prompted to view the phone numbers of employees. 5. Try to create the next query using the Designer, for this run the command: ribbon tab New Query designer. 12

13 6. In the Add Tables dialog box, select the Customers table and click the Add button and then the Close button. 7. To transfer the required fields to the request form, double-click on them with the left mouse button (Fig. 4). Figure: 4. Creating a query in Design mode 8. To sort the records in the Company name field in alphabetical order, select ascending from the Sort drop-down list. 9. Save the request with the name "Client Addresses". 10. Create a request "Birthdays" yourself, where you can view the birthdays of employees. 11. Let's say we want to know which employee has a birthday in the current month, for example, in April. To do this, open the query in Design mode. 13

12. In the line Criteria for the field "Date of birth" enter the value * .04. *. In this record, * means that the date and year of birth can be any, and the month is the 4th (that is, April). After that, the request window should look like it is shown in Fig. 5. Fig. 5. Creating a Query 13. Close the Designer and view the result. If there are no records in the Birthdays query, then there are no people born in April in the Employees table. Add a few people born in April to the Employees table and see how the query changes. Queries are automatically refreshed each time it is opened. 14. If we need to find out which of the employees was born in May, we will have to create a new request or change the condition in the existing request Birthdays. This procedure is inconvenient and time-consuming. If you have to frequently execute a query, but each time with new conditions values, use a query with a parameter. When you run such a request, screen 14

15 displays a dialog box for entering a value as a selection condition. To create a request with a parameter, the user needs to enter the message text in the Condition for selecting the request form (Fig. 6). Figure: 6. Creating a query with the parameter 15. The entry Like [Enter the date] means that when you open the query, a dialog box will appear (Fig. 7) with the text “Enter the date” and a field for entering a selection condition. If you enter the condition * .04. *, Then the query will display a list of employees born in April. Run the query again and enter the value * .05. *, See how the query has changed. Figure: 7. Window for entering selection conditions 15

16 16. Modify the "Phones" query so that when you run it, a dialog box with the message "Enter your last name" appears. Since you need to display a specific last name in the query, you don't need to write the word Like in the selection condition. 17. Change the "Phones" query so that when it is launched, not only the surname, but also the name of the employee is requested. 18. Create a request "Completed orders" on your own, containing the following information: the name and surname of the employee, the name of the company he works with, the completion mark and the order amount. Take query data from several tables. 19. In the selection condition for the Boolean field Completed status, enter Yes to display only completed orders in the query. 20. Make sure the Completion Flag column is not displayed. 21. Create a request Order Amount, which will display orders worth more than RUB. 22. Change the request so that the order amount is from to RUB. For these queries, you can use the comparison operators\u003e,<, =, >=, <=, < > and logical operators And, Or, Not, etc. 23. Sometimes in queries it is required to perform some calculations, for example, to calculate income tax of 13% for each transaction. To do this, open the Order Amount request in Design view. 24. In an empty column of the query design, right-click on the Field cell and select Build from the context menu that appears. You will see the Expression Builder window (Fig. 8), which consists of three areas: the expression field, operator buttons and expression elements. At the top is the expression field, in which it is created. Items entered in this field are selected in the other two areas of the Builder window. sixteen

17 25. In the left list, open the Requests folder and select the Order Amount request. In the middle list, highlight the Amount field and click the Insert button. The ID of this field appears in the Expression field of the Builder. 26. Click on the * button and enter 0.13 (see Figure 8). Thus, we will calculate the income tax of 13%. Figure: 8. Expression Builder 27. Press the OK button, after which the value "Expression1: [Sum] * 0.13" will appear in the Field property cell. 28. Replace Expression1 with Tax and close the Constructor. 29. Open the request and see what you get. 30. Using the Expression Builder, add a Profit field to the Order Amount query, which will calculate the order revenue (that is, amount minus tax). 31. Create a query Managers, by means of which in the table Employees find all the managers of the company. 32. Show the work to the teacher. 17

18 Security questions 1. What are queries for? 2. What types of queries do you know? 3.What can you use to create queries? 4. What is a parameter query used for? 5. How can you make calculations in queries? 6. What does the entry in the query condition "\u003d 50" mean? 7. Can you create queries based on multiple tables? 18

19 Lab 4 Using Forms in a Database Forms are database objects designed to view data from tables and queries, to enter data into a database, correct existing data, and perform specified actions. A form can contain graphics, pictures, and other embedded objects. It is possible to enter data into tables without using any forms. But there are several reasons that make forms an indispensable means of entering data into a database: 15) when working with forms, access to tables (the most valuable in the database) is limited; 16) different people may have different access rights to information stored in the database. They are provided with different forms to enter data, although the data from the forms can enter the same table; 17) it is easier to enter data into a form than into a table, and more convenient, since, as a rule, one table record is displayed in the form window; 18) in most cases, information for databases is taken from paper forms (questionnaires, invoices, invoices, certificates, etc.). Screen forms can be made an exact copy of paper forms, thereby reducing the number of errors in input and reducing staff fatigue. You can create forms based on several tables or queries using the Wizard, using the AutoForm tool, “manually” in Design mode, saving the table or query as a form. The form created in any way can then be modified in Design mode. Let's consider some of the listed methods. 1. Run the command: ribbon tab Create toolbar Forms Other forms Form wizard. 2. In the Create Forms dialog box, select the tables (queries) and fields that will be placed on the form. Click the Next button. 23

20 3. In the next dialog boxes of the wizard, select the appearance of the form, style, set the name of the form. Click the Finish button. 4. With the help of the Wizard, create the forms Employees, Customers, Orders, Managers. 5. Open the Employees form in Design view. This mode is intended for creating and editing forms. 6. Place the elements in the order convenient for you, change the size and color of the text. 7. Add the text Company employees to the form heading. 8. Add a Button object to the form note (ribbon tab Constructor toolbar Controls). 9. After you "draw" the button with the pointer, the Create buttons dialog box will appear on the screen (Fig. 9). Figure: 9. Create buttons on a form 10. In the Form Tools category, select the Close Form action, and then click Next. 11. Select a picture or text to place on the button. 12. In the last dialog box of the Button Wizard, give the button a name and click Finish. 24

21 13. The Button Wizard has written a procedure for this button in Microsoft Visual Basic. You can view the event handling procedure using the Event handling command of the button context menu. 14. Create the Exit Application, Search Record, Delete Record buttons on your own. 15. Sometimes on the form it is required to place several pages containing data from various sources, reference or auxiliary information. A set of tabs can be used for this purpose. 16. Create an empty form. 17. To add a set of tabs to the form, click the Tab button on the Controls toolbar. First, only two tabs will be added with the formal names Tab 1 and Tab Add another tab. 19. Rename the tab labels so that they display the names of the data that will be located in them: Employees, Managers, Help. 20. Go to the Employees tab and drag the Employees form onto it from the database. 21. In the same way, place the Managers form on the Managers tab. 22. On the Help tab, put some tips for working with the database. 23. Save this form with the name Company employees. 24. In Microsoft Access, you can create button forms. They contain only buttons and are intended to select basic actions in the database. To create a button form, select the Button Form Manager command on the Working with Databases ribbon tab. 25. If there is no button form in the database, you will be prompted to confirm its creation. Click Yes in the confirmation dialog. 25

22 26. You will see the Button Forms Manager, in which click on the Create button. 27. In the Create dialog box (Figure 10), enter a name for the new button form and click OK. Figure: 10. Setting the name of the button form 28. The name of the new button form will be added to the Pages of the button form list in the Button form manager window (Fig. 11). Highlight the name of the new button form and click the Change button. Figure: 11. Button Forms Manager 29. In the Edit Button Form Page dialog box, click the New button. The Edit Button Form Element dialog box will appear (Fig. 12). Figure: 12. Creating buttons on the form 26

23 30. In the Text box, enter the caption text for the first button on the button form, and then select a command from the drop-down list in the Command box. In the Form field, select the form for which this command will be executed. 31. Add the Customers, Orders, Exit buttons in the same way. 32. In the Button Form Manager dialog box, select the name of your button form and click the Default button. The inscription "(by default)" will appear next to the button form name. 33. To finish creating the button form, click on the Close button. 34. The result should be the form shown in fig. 13. Fig. 13. Main Button Form 35. Add a drawing to the form. 36. In order for the main button form to appear on the screen when starting the application, in the main menu, press the Access Options button (Fig. 14). For the current database, set the "button form" view form. 27

Fig. 24 14. Setting Access Parameters 37. Show the work to the teacher. Test questions 1. What are the forms for? 2. Why is the form an indispensable tool in the database? 3.What can you use to create forms? 4. On what basis can you create forms? 5. How to create a button on a form? 6. How can you place several tables and queries on one form? 7. How to create a main button form? 28

25 Lab 5 Creating Reports Reports are designed for printing information. Often the data in them is in tabular form. In contrast to printouts of tables or queries, a report provides more opportunities for sorting and grouping data, it provides the ability to add totals, as well as explanatory labels, headers and footers, page numbers, styles, and various graphic elements. There are several ways to create reports in an Access database: 19) using the Report Wizard; 20) based on tables or queries; 21) in Constructor mode. 1. In the database window, run the command: ribbon tab Create toolbar Reports Report wizard. 2. Select a table (or query) from the list that will be used as a data source (for example, the Client Addresses query). 3. In the Generating Reports dialog box that appears (Fig. 15), move all available fields to the "Selected Fields" area. Figure: 15. Report Wizard 29

26 4. Using the Report Wizard, create the Birthdays report. Use the Employees table as the data source. 5. If you want to print mailing labels, Access provides this option. To do this, select the Clients table and run the command: ribbon tab Create toolbar Reports Labels. 6. In the dialog box that appears (Fig. 16), specify the size of the sticker, system of units, type of sticker and click Next. Figure: 16. The Create Labels dialog box 7. At the next step of creating the report, set the font, size, text color and style. Click "Next. 8. Select the margins to be displayed on the label. For example, Company Name, Address, Phone and Fax. If you want to display specific text on each sticker, enter it into the sticker prototype. 9. If necessary, change the name of the label report and click Finish. 10. Sometimes reports need to calculate totals, average, minimum or maximum values, and percentages. To do this, start the Report Wizard and specify the Order Amount request as the data source. thirty

11. In the dialog box of the Wizard, in which the order of sorting records is set, click the Totals button (Fig. 17). Figure: 17. Calculation of totals in reports 12. In the Totals dialog box (Fig. 18) for the Amount and Tax fields, check the boxes in the sum column to calculate the total amount. Figure: 18. Calculating the total values \u200b\u200bof the sum 13. Then follow all the steps of the wizard and click Finish. 14. Create a Birthdays report using the Birthdays query as a data source. 31

28 15. Create a report Completed orders, which will include information about the company and the amount of the order. Calculate the grand total, average (Avg) and maximum amount for each firm. 16. Show the work to the teacher. Test questions 1. What are the reports for? 2. What methods of creating reports do you know? 3. How can the totals be calculated in the reports? 4. What totals can be calculated in the reports? 5. How do I print mailing labels in Access? 32

29 Tasks for self-fulfillment Option 1 1. Develop a database "Electronic library", consisting of three tables with the following structure: Books book code (key field), author, title, publication year, number of copies. Readers library card (key field), surname, name, patronymic, address. Issued books book code, library card, date of issue, date of return, date of actual return. 2. Establish relationships between tables. 3. Use a query to select all books from 1990 to 2007. 4. Create a query with a parameter to select books by a specific author. 5. Create data entry forms, reports, and a main button form. Option 2 1. Develop a database "Grocery store", which consists of four tables with the following structure: Products product code (key field), product name, product quantity. Goods receipt goods code, date of receipt, purchase price of goods per unit, supplier code. Sale of goods item code, month of sale, quantity sold per month, selling price of the item. Suppliers supplier code (key field), supplier name, supplier address, supplier phone. 2. Establish relationships between tables. 33

30 3. Using the request, select products with prices ranging from 100 to 450 rubles. 4. Create a query with a parameter to select products sold in a specific month. 5. Create data entry forms, reports, and a main button form. Option 3 1. Develop a database "Session", consisting of four tables with the following structure: Students student code (key field), last name, first name, patronymic, course, group. Exams student code, date, discipline code, grade. Offsets student code, date, discipline code, credit. Disciplines discipline code (key field), discipline name, number of hours. 2. Establish relationships between tables. 3. Use a query to select students who passed exam 4 or Create a query with a parameter to select students who did or did not get credit. 5. Create data entry forms, reports, and a main button form. Option 4 1. Develop a database "Wholesale warehouse", consisting of four tables with the following structure: Warehouse product code, quantity, date of receipt. Products product code (key field), product name, shelf life. Applications application code (key field), organization name, product code, required quantity. 34

31 Goods issue order code (key field), item code, released quantity, date of goods issue. 2. Establish relationships between tables. 3. Using the request, select goods, the quantity of which is from 50 to 200 pieces. 4. Create a request with a parameter to select goods received at the warehouse of a certain number. 5. Create data entry forms, reports, and a main button form. Option 5 1. Develop a database "Applicants", consisting of four tables with the following structure: Application form applicant number (key field), last name, first name, patronymic, date of birth, graduated secondary educational institution (name, number, locality), date graduation from an educational institution, the presence of a red diploma or a gold / silver medal, address, phone number, specialty code. Specialties specialty code (key field), specialty name. Discipline discipline code (key field), discipline name. Entrance exams applicant number, discipline code, examination score. 2. Establish relationships between tables. 3. Make a request to select students who passed exams without triples. 4. Create a query with a parameter to select students applying for a specific specialty. 5. Create data entry forms, reports, and a main button form. 35

Option 6 1. Develop a database "Transport", consisting of three tables with the following structure: Transport car brand, state number (key field), fuel consumption. Applications application code (key field), date of application, name of the cargo, amount of cargo, point of departure, point of destination. Delivery p / p, date and time of departure, date and time of arrival, application code, vehicle license plate, distance traveled. 2. Establish relationships between tables. 3. Using the request, select applications with the amount of cargo from 100 to 500 kg. 4. Create a request with a parameter to select vehicles by car make. 5. Create data entry forms, reports, and a main button form. Option 7 1. Develop a database "Sports equipment rental", consisting of three tables with the following structure: Clients client code (key field), last name, first name, patronymic, telephone, address, passport data, deposit. Warehouse equipment code (key field), name, quantity, collateral value, balance. Rental p / p, client, equipment, date of issue, return period, mark on return, rental payment. 2. Establish relationships between tables. 3. Create a request to select equipment with a collateral value of up to RUB. 36

33 4. Create a query with a parameter to select customers who returned equipment. 5. Create data entry forms, reports, and a main button form. Option 8 1. Develop a database "Bank", consisting of three tables with the following structure: Clients client code (key field), last name, first name, patronymic, passport, phone, address, salary. Types of loans loan code (key field), loan name, interest rate, terms of provision. Provided loans, p / p, client, loan, date of provision, term, date of repayment, amount, mark on refund. 2. Establish relationships between tables. 3. Create a request for the selection of clients who have taken out a loan from up to rubles. 4. Create a query with a parameter for selecting loans at an interest rate. 5. Create data entry forms, reports, and a main button form. Option 9 1. Develop a database "Travel company", consisting of four tables with the following structure: Clients client code (key field), last name, first name, patronymic, telephone, address, passport. Employees employee code (key field), last name, first name, patronymic, position, phone number, address, passport data. 37

34 Tourist routes route code (key field), name, description of the route, country, ticket price, number of days, type of transport. "Orders" order code (key field), client, route, employee (manager who placed the order), date, payment mark. 2. Establish relationships between tables. 3. Create a request to select routes with a cost from to RUB. 4. Create a query with a parameter to select customers who have chosen a certain type of route. 5. Create data entry forms, reports, and a main button form. Option Develop a database "Polyclinic", consisting of four tables with the following structure: Doctors doctor's code (key field), full name, position, specialization, work experience, address, telephone. Diseases p / p (key field), name of the disease, recommendations for treatment, preventive measures. Patients patient code (key field), full name, address, telephone number, insurance policy, passport. Diagnosis p / p (key field), patient, disease, attending physician, date of treatment, date of recovery. 2. Establish relationships between tables. 3. Select dentists and orthopedists using the request. 4. Create a query with a parameter to select patients with a specific type of disease. 5. Create data entry forms, reports, and a main button form. 38

CREATING DATABASES IN MICROSOFT ACCESS 2007 Practical work 1. Introduction to Access. Database creation. Creating tables 1. Start Microsoft Access 2007. 2. Click the button. 3. Give a name to the new

N 1 CREATION OF DATABASES IN MS ACCESS. Tables and Relationships In the modern world, the amount of information that needs to be stored increases every second. Therefore, the use of databases is an integral part of the professional

Laboratory work 1 STUDY OF THE POSSIBILITIES OF MICROSOFT ACCESS 2013 WHEN CREATING TABLES Objectives of the work: 1. To study the procedure for creating tables with specified attributes and data using MICROSOFT ACCESS 2013.

Laboratory work 2 STUDY OF POSSIBILITIES OF MICROSOFT ACCESS 2013 WHEN CREATING RELATIONS BETWEEN TABLES Objectives of the work: 1. To study the procedure for creating relationships between tables using MICROSOFT ACCESS 2013.

Tasks for self-fulfillment Option 1 1. Develop a database "Electronic library", consisting of three tables with the following structure: Books - book code (key field), author, title,

1 Lab 2 Creating relationships between tables 1. Start Microsoft Access 2007. 2. Create the "Company" database. Employees of this organization work with clients and fulfill their orders. Us

UGLTU DEPARTMENT OF INFORMATION TECHNOLOGIES AND MODELING Informatics Methodical instructions on laboratory work for full-time and part-time students in the direction 38.03.05 Business -

Laboratory work 4 "Creating relationships between tables" Purpose of work: studying the technology of creating the structure of a relational database in Microsoft Office Access 2007 1. Brief theoretical information Word

1 Lab 3 Selecting Data Using Queries Queries are the primary means of viewing, filtering, modifying, and analyzing information that is contained in one or more tables in a database.

Specialty 100400.62 "Tourism" Educational discipline "Information networks and databases" Practical lesson 7 Exploring the possibilities and order of using MS Access 2007 when creating relationships between tables

Practical Activity 17 "Selecting Data Using Queries" 1. Open the previously created database "Organization" 2. Run the command: New ribbon tab Query Wizard Simple Query. 3. In the appeared

Laboratory work 3 RESEARCH OF THE POSSIBILITIES OF MICROSOFT ACCESS 2013 WHEN SELECTING DATA USING REQUESTS Objectives of the work: 1. To study the procedure for creating requests for selecting data using MICROSOFT ACCESS 2013.

Specialty 100400.62 "Tourism" Academic discipline "Information networks and databases" Practical lesson 8 Studying the possibilities and order of using MS Access 2007 when selecting data using queries

Laboratory work 4 RESEARCH OF THE POSSIBILITIES OF MICROSOFT ACCESS 2013 IN CREATING AND USING FORMS IN THE DATABASE Objectives of the work: 1. To study the procedure for creating and using forms in MICROSOFT ACCESS 2013.

DEPARTMENT OF EDUCATION AND SCIENCE OF THE TYUMEN REGION STATE AUTONOMOUS PROFESSIONAL EDUCATIONAL INSTITUTION "TYUMEN FORESTRY TECHNICUM" NV Bortsova, OV Zhuravleva Control system

MICROSOFT ACCESS: LINKS, CALCULATED FIELDS, CREATING A BUTTON FORM OF A DATABASE I. TABLE RELATIONS Modern databases usually consist of many tables linked together. One of the goals of creating a good structure

MINISTRY OF EDUCATION AND SCIENCE OF THE RUSSIAN FEDERATION Federal State Autonomous Educational Institution of Higher Professional Education NATIONAL RESEARCH TECHNOLOGICAL

Laboratory work 5 RESEARCH OF THE POSSIBILITIES OF MICROSOFT ACCESS 2013 WHEN CREATING AND USING REPORTS IN THE DATABASE Objectives of the work: 1. To study the procedure for creating and using reports in MICROSOFT ACCESS

1. Explanatory note 1.1. Requirements for students The student must have the following initial competencies: basic provisions of mathematical and natural sciences; possess the skills of body work;

BASICS OF WORKING IN MICROSOFT ACCESS. DATABASE DESIGN. DATABASE CREATION. CREATION OF FORMS, REPORTS, INQUIRIES 1. Designing databases 2. Creating a database 3. Creating forms, reports, queries

1 Practical work 18 "Using forms in the database" Initial database "ORGANIZATION" Task-1: 1. Using the Wizard, create the forms Employees, Clients, Orders by including all the available fields.

Specialty 100400.62 "Tourism" Academic discipline "Information networks and databases" Practical lesson 6 Studying the possibilities and order of using MS Access 2007 when creating tables Educational questions

Ministry of Education of the Tver Region GBOU SPO Tver College named after A. N. Konyaeva "Tasks for performing independent work in MS Access 2007 in the discipline" Information technology "for the specialty

MINISTRY OF EDUCATION OF THE RUSSIAN FEDERATION FEDERAL STATE BUDGETARY EDUCATIONAL INSTITUTION OF HIGHER EDUCATION "IVANOVSK STATE POLYTECHNICAL UNIVERSITY" DEPARTMENT OF INFORMATION

Lecture plan: Working with database objects in MS ACCESS 1. Working with tables. 2. General information inquiries. 3. Working with forms 4. Working with reports. 2 Question 1 Ways to create tables: 1. in table mode; 2.in

2 DBMS ACCESS The database management database Access is one of the programs - applications of the integrated Microsoft Office package. The boot file for a program named msaccess.exe is usually located

LABORATORY WORK 2 CREATING FORMS IN MS ACCESS Objectives of the work: studying the main ways of creating forms using MS Access; creating calculated fields in MS Access forms. The content of the theoretical minimum.

TEST: "DBMS ACCESS 2007 - CONTROL TEST". Task # 1 How many fields are selected to be included in the generated REPORT Choose one of 5 answer options: 1) 1 2) 2 3) 3 4) 4 5) 5 Task # 2 Will the specified

Laboratory work 4 Basics of working with data arrays in the Access DBMS Purpose of work: 1) acquisition of skills to work on creating a database and its main objects; 2) sorting data in tables and others

MINISTRY OF AGRICULTURE OF THE RUSSIAN FEDERATION.

1.1. Basics of working with databases 1.1.1. Databases and database management systems. Data models Database (DB) is a named collection of structured data related to a certain

Practice 3 Create a Form A form is a database object that you can use to enter, modify, or display data from a table or query. Forms can be used to manage

Work 2. Creation of the "Students" database Task 1. Creation of the structure of a new table. Use the table designer to create the Students table. 1. Start the MS Access DBMS program and create a new DB

Workshop on working with the database. Task 1. Create a new database and create a table structure with information about the students of the "Computer School". Operating procedure. Start Microsoft Access. In the Microsoft dialog box

Practical work on Access 2007 grade 10. TASK 1. CREATION OF A MULTI-TABLE DATABASE. Purpose of work: To acquire skills and abilities when working with tables: create tables using a constructor, set

LABORATORY WORK 1 Creation of a new database. Creation of a database using templates Purpose: to develop skills and abilities to create a new database and database based on templates. Lead time:

Database management system OpenOffice.org Base For your information: Databases (DB) are a type of software designed for storing and processing information. For example, the "library" database can store

MOU "Lyceum 43" Saransk Methodical development "RESEARCH OF ACCESS DBMS WHEN CREATING AND EDITING A DATABASE" By computer science teacher Zhebanov A. A. Saransk 2014

"Informatics and information and communication technologies in professional activity" specialty 44.02.01 "Preschool education" 2.6 course, 24.24 (9), 64 (1.2, 3) groups teacher Gerasimova

NATIONAL AVIATION UNIVERSITY Department of Applied Informatics Coursework Topic: Microsoft Access DBMS Creation and processing of databases Purpose of work: theoretically and practically master the basic techniques of work

Laboratory work 11. Formation of queries to the database in the MS Access DBMS The purpose of the work is to acquire the skills of creating various types of queries to the database. To defend the laboratory work, the student must submit

➀ Information systems and data banks. The most important condition for ensuring the effective functioning of any organization is the presence of a developed information system. An information system is a system

Designing a database of Internet purchases Let the Internet shop carry out bulk purchases of goods from trading bases in Moscow and nearby regions to satisfy requests from customers. When purchasing large

Getting Started with Access Access is a database application or database management system (DBMS). Computer databases are used in almost all areas of activity. Skill

Federal Agency for Fisheries Federal State Budgetary Educational Institution of Higher Professional Education "Astrakhan State Technical University" Development

Introduction to ACCESS First of all, Access is a database management system (DBMS). Like other products in this category, Access is designed to store and retrieve presentation data in a convenient form.

WORKING WITH THE MICROSOFT ACCESS DATABASE MANAGEMENT SYSTEM 1 KEY TERMS Query - Queries are powerful tools for manipulating data stored in Access tables. Using queries, you can view,

1 Practical exercise 16 "Using relationships between tables" 1. Start Microsoft Access 2007. 2. Click on the button: 3. Create a database "Organization", whose employees work with clients

Chapter 8 Creating and Using Forms As noted in Chapters 1 and 2 of this book, database objects such as forms are primarily designed to work on only one record at a time.

4. Databases 4.1. Databases and data models. Basics of design of relational databases Database (DB) is a named collection of structured data related to a specific subject

Topic: Practical work 14-2 Creating a database, consisting of one table. Entering data into the table. Using forms. Purpose: Learn how to create databases in MS Acces (create tables and forms,

Task 4. Creating and editing forms and reports The purpose of the task: To learn how to create and edit forms and reports. The previously developed database "Journals" is used. Sequencing:

Laboratory work 2 "Creating a relational database" Purpose of work: studying tools for managing databases in Microsoft Office Access 2007 1. Brief theoretical information In the modern world, a person

LABORATORY WORK N 1 BASIC PRINCIPLES OF WORK IN Microsoft Access 97 PURPOSE OF THE WORK The purpose of the work is a general acquaintance with the Microsoft Access 97 database and the acquisition of skills in using the reference

LECTURE 7 Microsoft Access program. Lesson plan: Introduction Database. Database structure. Creating a database using Microsoft Access. Working interface and main menu of Microsoft Access. Filling the first

Work 6 Creation of complex forms and reports Purpose of work: to learn how to create complex forms and reports. Content of work: 1 Development of a complex form 2 Development of a complex report 3 Development of a button form-menu

Task 3. Creating and editing queries Purpose of the task: To learn how to create and edit queries to the database. The previously developed database "Journals" is used. Sequencing:

Practical work 18 Topic: CREATION OF TABLES IN MICROSOFT ACCESS DBMS Purpose of the lesson. Study of information technology for creating a database in a database management system (DBMS) Microsoft Access. The task

9. LABORATORY WORK 9 9.1 Creation of a database of a commercial company MS Access Purpose of work: to study the technology of creating databases in MS Access. Learn to create tables, link them between

@ DB, DBMS 1. A data structure characterized by subordination of lower-level objects to upper-level objects is called A. tabular B. relational * C. hierarchical D. network 2. Distinctive

P. 1 of 109 BAXIŞ Testlər / 1625 # 01 # Y15 # 01 qiyabi / 1625 # 02 # y15 # 01qiyabi / baxış TEST: 1625 # 02 # Y15 # 01QIYABI Test Fənn Təsviri Müəllif Testlərin # vaxtı Suala vaxt Növ 1625 # 02 # 02 # Y15 - Verilənlərin

Theme: creation of reports.

Purpose of work:

ü learn how to create reports using the Report Wizard;

ü make changes to ready-made reports using the Designer;

ü master the basic techniques of making inscriptions on envelopes and stickers.

Theoretical part.

ReportIs a flexible and effective tool for organizing viewing and printing of summary information. In the report, you can get the results of complex calculations, statistical comparisons, as well as place pictures and diagrams in it. The user has the opportunity to develop a report independently (in the Constructor) or create a report with Masters, i.e. semi-automatically.

The practical part.

Exercise 1. Open your database.

Task 2. Create a report with Report wizards.

Open the tab Creature,menu Reports.

Select Report wizard and table "Personal data".

· Select the required fields that will participate in the report, click the "Next" button.

· In the new window, select the fields to be grouped so that the "Last name" field is specified first, click the "Next" button.

· At this step, sort the data alphabetically, click the "Next" button.

Select a layout view Stepped and click on the "Next" button.

· Select a report style: Openand click on the "Next" button.

· Set a name for the report: "Report1" and click on the "Finish" button. You will be taken to the report view mode.

· Close the report by agreeing to save.

On my own Create two more reports on queries - "Query 3" and "Query 5", choosing from different layouts: block ; structure choosing from different styles. Save the reports as "Report 2" and "Report 3".

Task 3. Create Blank report to a table-based column "Statement of performance" and save it with the name "Performance".

Use the Constructor to change the color, size, and font of the title letters.

Task 4. Create mailing labels.

Open the tab Creature,menu Reports.

· Select the table "Personal data", the command Stickers.

· In the next window select the font, font size, weight and color, again click on the "Next" button.

· In the next window create a prototype of the sticker by typing the word PERSONALITY and selecting the appropriate fields, click on the "Next" button.

· In the next window, specify the fields for sorting (Surname, First name), click on the "Next" button.

Enter a name for the report "Stickers" and click on the "Finish" button.

Review the Labels (Figure 8).

Figure 8

Show all reports to the teacher.

Tests for ACCESS 2007

Test work number 1

Objective: to consolidate the knowledge gained in the process of performing previous work on creating tables, on entering data into tables, on creating a database schema, on using a database.

Stages of work

Database structure design.

The database will consist of three tables: Videotapes, Genre and Country. Corresponding fields in the table Videocassettes become lookup fields from other tables.

Building empty database tables.

Create a video cassette table in the Design mode. It will have six fields: Title of the film, Genre, Lead actor. Country, Language and Duration. The Movie Title field is a key (unique field). The Country table has only one Country field, and the Genre table has only one Genre field. These fields are key.

Database schema creation.

Entering data into tables.

Tables are filled first Country and Genre, then - table Videocassettes. You can fill in the mode tables, or you can create an input form.

Database usage.

First, the request is created, and then the report. The next step is to create a button form for working with the database.

Working process

Exercise 1... Create a new empty database.

Call the Access program.

Click the icon New database... In field File name enter the word for the database name Video libraryand save in your folder.

Click the button Create.A window with the main elements of the database will appear on the screen.

Task 2. Create the structure of the Genre table in Design mode.

Select mode Constructor

Enter field name Genre and the data type is text. (The data type is selected using the drop-down menu).

Make the Genre field a key by placing the cursor over the field name and clicking the key button on the toolbar.

Genre.

Task 3. Create the structure of the Country table in Design mode.

Select a tab Creature, command Table

Select mode Constructor

Enter field name Country and the data type is text.

Make a field Country key.

Save the table as Country.

Task 4. Create the structure of the Videotape table in Design mode.

Select a tab Creature, command Table

Select mode Constructor

Enter the name and type of the field according to the table:

Make a field Movie title key.

For the field Country select a bookmark Substitution wizard, control type - Combo box, source of strings - Country.

For the field Genre select a bookmark Substitution wizard, control type - Combo box, source of strings - Genre.

Save the table as Videocassettes.

Assignment 5... Create links according to the data schema.

Click on the tab Working with the database, button - Data schema. A window will appear Adding a table. Highlight tables Genre, Videotapes, Country and click on the button Add.

Click the button Close window Adding a table. In the window Data schema a conditional view of these tables will appear.

Place the mouse over the field name Genre in the table Genre Genre in the table Videocassettes. Connections.

Turn on icon

Turn on

Turn on Cascading deletion of related fields.

Click the button Create. A link will appear One-to-many.

Place the mouse over the field name Country in the table Country and without releasing the mouse button, drag it onto the field Country in the table Videocassettes. Release the mouse. A dialog box will appear Connections.

Turn on icon Ensuring data integrity.

Turn on Cascading update of related fields.

Turn on Cascading deletion of related fields.

Click the button Create. A link will appear One-to-many.

Task 6. Fill in the supporting tables.

Fill the table Genre data: action, comedy, tragedy, fiction.

Fill the table Country data: Russia, USA, France, England, Hungary.

Task 7. Create a form to fill out the Videotapes table.

Create a form in any way convenient for you

Assignment 8... Fill in the Videotape table using the form you received.

Populate the database with the data from the following table:

Movie title	Leading actor	Genre	Country	Language	Duration
The matrix	Keanu Reeves	Fiction	USA	English	136min
Highlander	Christopher Lambert	Action movie	USA	English	120 minutes
Titanic	DiCaprio	Tragedy	USA	English	120 minutes
Mask	Jim carrey	Comedy	USA	English	60 minutes
Terminator	Schwarzenegger	Action movie	USA	Russian	60 minutes
Commandos	Schwarzenegger	Action movie	USA	Russian	60 minutes
Junior	Schwarzenegger	Comedy	USA	Russian	60 minutes
Toy	Pierre Richard	Comedy	France	French	60 minutes
Height	Vladimir Vysotsky	Artistic natural	Russia	Russian	60 minutes

Task 9. Use the Query Wizard to retrieve all the videotapes featuring Schwarzenegger in action movies.

Build a Simple Query Based on the Videotape Table

In line Selection condition, located under the field Genre, dial Action, and under the field Main performer roles - Schwarzenegger.

Save the query with a name Schwarzenegger in action films.

Task 10. Prepare the "Schwarzenegger in Action" report for publication.

Prepare a report based on the request.

Save the report with the name Schwarzenegger in action films.

Task 11. Create a form to request Schwarzenegger in action movies.

Create a form with Form wizardsbased on the generated request.

Save the form with a name Schwarzenegger in action films.

Task 12. Create a button form for working with a database.

Call the window Button Form Manager(the tab Working with databases).

Click in the window Button Form Manager button Change, and in the opened dialog box Changing the page of a button form - button Create. As a result, a dialog box will appear Changing an element of a button form.

In field Text dial Schwarzenegger in action films.

In field Commandselect Opening the form for modification.

In field Button form select Schwarzenegger in action films.

Click the button OK.

Similarly, create another button form element Videocassettes, for opening a form Videocassettes in change mode.

Create a close database button in mode Exit the application.

Close dialog boxes Modifying a Button Form Page and Button Forms Manager.

Discover Button formin mode Constructor, change the caption to Video library, save the form.

Test all buttons on the button form. After pressing the button Exit you quit Access.

Dosmukhamedov Pedagogical College

DEPARTMENT OF INFORMATICS

LABORATORY WORKS

PROGRAM

MICROSOFT ACCESS

DEVELOPER: Sultanova Gulshat Berikovna

Uralsk -2015

Practical work No. 1

Database creation

Objective: Learn to create a database in MS ACCESS and tables in it in a different way.

Work tasks:

Master the ways of creating database tables.

Get acquainted with the basic objects of databases.

Get the skills to fill in databases.

Providing means:

Report requirements: The results of practical work should be presented in the form of a LAB 29.doc file on disk (if necessary, printed) and a report on practical work containing answers to control questions should be drawn up

Work technology:

Running MS ACCESS: activate button START , from the menu that appears, select PROGRAMS , then choose MICROSOFT ACCESS .

When you start Access, a dialog box opens with which you create NEW BASE DATA, which will be stored on disk " AND»Under a certain name. Then a window will appear "DATABASE" , where later all other database objects will be created, namely tables, queries, forms, etc. Let's start in order.

DATABASE CREATION:

New database / OK

File name: \u003d…. / Create a

CREATING A TABLE IN DESIGNER MODE:

Objects Database / Tables

Creating a table in design mode

Field name: \u003d room / Data type \u003d counter / Description \u003d record number

Field name: \u003d date / Data type \u003d date Time / Description \u003d receipt date

Field name: \u003d The code / Data type \u003d text / Description \u003d product code

Field name: \u003d Has come / Data type \u003d numerical / Description \u003d number of units goods

Saving a table object to: \u003d Invoice / as table / OK

no

Close : Invoice: table / Open Invoice table

room

date

The code

Has come

00001

00002

24982

08652

09632

09633

00003

00004

08521

08522

08523

55546

CREATING A TABLE WITH A WIZARD:

• In the window database / Creating a table using the wizard

Business / Sample tables / Order Details

Sample fields / Date of sale / > / Rename field: \u003d date

Sample fields / The code Order / > / Rename field: \u003d The code / OK

Sample fields / amount /\u003e / Rename field: \u003d Gone / OK / Next

New table name: \u003d Requirements

User determines the key independently / Further

Select a field that is unique for each data record / Date

Connections … / Tables are not connected / OK / Next

Edit structure tables / Finish / (In the window that appears)

In line " date"Cancel the key field / Edit / Key field

Add blank line / Insert / Strings

Field name: room / Data type: numerical

Field name: date / Data type: date Time

Field name: The code / Data type: text

Field name: Gone / Data type: numerical / File / Save

Field name: room / Data type: counter / File / Save

Close /Open table « Demand »

room

date

The code

Gone

00001

00002

24982

08652

09632

09633

00003

00004

08521

08522

08523

55546

CREATING TABLES BY ENTERING DATA:

• Creating tables by entering data

Select the column Field1 / Format / Rename Column / the code goods

Field2 / Rename Column / Product

Field3 / Rename Column / Name

Field4 / Rename Column / Price

When asked to create a key field now / No / Save / Close

Select the table " Products» / Constructor

Field name: Product code / Data type: Text

Field name: Product / Data type: Text

Field name: Name / Data type: Text

Field name: Price / Data type: Monetary / Field properties / Are common

Field format / Monetary

Highlight the field "Product code" / Edit / Key field

Product code

Product

Name

Price

00001

Table 1P

Wooden writing

2500

00002

Table 5Kr

Wooden dining round

1300

24982

Chair

Soft for the office

08652

Stool

Wooden folding

09632

Armchair 4MOF

Office soft

1650

09633

Armchair 1MO

Soft for relaxation

1500

00003

Table 2Ж

Wooden coffee shop

00004

Table 6UNS

Universal foldable

1150

08521

Cabinet 1US

Wooden hinged

1620

08522

Wardrobe 2PL

Wooden dress

2100

08523

Cabinet 4Kn

Wooden bookcase

1950

55546

A shelf

Hanging book room

Test questions:

What is Access DBMS?

How to create a new database in Access DBMS?

What objects does Access DBMS work with?

Why are data types assigned?

Practical work No. 2Creation of links between database objects. Forms

Objective: Learn to create links between database objects. Learn how to create forms using the form wizard, set properties of a form and its objects.

Work tasks:

Learn to link data from different tables.

Practice of creating forms using the Wizard.

Learn to set form properties.

Providing means:

Report requirements: The results of practical work should be presented in the form of a file LAB 30.doc on disk (if necessary, printed) and a report on practical work should be drawn up containing answers to control questions

Work technology:

ESTABLISHING RELATIONSHIP BETWEEN TABLES:

Objects Database / Tables

Service / Scheme data / In the appeared window "Add table"

Tables / Invoice / Add

Demand / Add

Products / Add / Close

Connections / Change links / New…

Left table / Invoice / Right table / Products

Left column / The code / Right column / Product code / OK

(Note that Relationship Type is one-to-many )

An association… / Combining only those records in which the related fields of both tables match / OK / Create a

Connections / Change links / New…

Left table / Products / Right table / Demand

Left column / The code goods / Right column / The code / An association…

An association only those records in which related the fields of both tables are the same

OK / Relationship Type: one-to-many / Create a

The table "Products" will help you to make sure that there is a connection, for this: enter the table " Products"; on the left in front of each line there was a sign “ + ", If you left-click on it, it will open subtable with data from the "Invoice", specifically for this product. To facilitate the use of information you can write several queries, but sometimes it is more convenient to create a link, which you did.

FORMS

Forms allow you to enter data into database tables without directly accessing the tables themselves, in other words - it is a data entry tool . The point of the form is to provide the user with only those fields that he needs to fill out. This is why the form is convenient. Using forms, data can not only be entered, but also displayed, that is, you can view existing table records.

CREATING A FORM WITH THE FORM MASTER

Database Objects / Forms / Create a form using the wizard

Tables and Queries / Products

Available fields / The code goods / > / Product / > / Name / > / Price / > /

Form name: \u003d New product

Flag: Open a form to view or enter data

Done (see Figure 3.2)

Figure: 3.2

Set the properties of the form to allow adding records.

SETTING FORM PROPERTIES:

Select the form "New product" / constructor

View / Properties / Data

Allow changes / No

Allow deletion / No

Allow adding / Yes

Close form / Retaining changes / Open form "New product"

This form allows only adding records in the "Products" table. In the "New product" form that appears, enter the following data (see below).

Product code

Product

Name

Price

00005

Table 11OS

Wooden office

2750

24983

Chair 13OFK

Soft rotating office

00011

Shelving unit 1kn

Wooden bookcase

2600

08653

Stool 2Kr

Wooden round

Test questions:

What is the structure of the Form for?

How does the form navigate between records?

How do I call the object properties dialog?

Practical work No. 3Creating forms in design mode

Objective: Learn to create forms in design mode.

Work tasks:

The practice of designing forms.

Reinforce your skills in creating forms in design mode.

Providing means: Collection of descriptions of practical work on MS Access; personal computer, software: MS Access DBMS.

Report requirements: The results of practical work should be presented in the form of a file LAB 31.doc on disk (if necessary, printed out) and a report on practical work should be drawn up containing answers to control questions

Work technology:

CREATING A FORM IN DESIGN MODE:

Figure: 3.4

date

The code

Has come

00001

00002

00005

00011

08653

The New Requirement form must contain:

free fields

field with a list

picture

date and time

heading "Requirement" (View / Title ...)

scroll lines

In this form, you will enter data, but so that the previous records are not changed.

date

The code

Gone

00001

00002

00005

00011

08653

Test questions:

What elements can be inserted into a form in design mode?

What is Form Builder for?

What types of data can be stored in the fields. Give examples.

Practical work No. 4Queries: Concepts and Making Simple Queries

Objective: learn how to create simple queries in design mode and using the wizard. Viewing the resulting data.

Work tasks:

Learn how to create a simple query in different ways.

Learn to view the resulting data.

Providing means: Collection of descriptions of practical work on MS Access; personal computer, software: MS Access DBMS.

Report requirements: The results of practical work should be presented in the form of a LAB 32.doc file on disk (if necessary, printed) and a report on practical work should be drawn up containing answers to control questions

Work technology:

Inquiries extract desired data from tables and provide them to the user in a convenient form. The request can be saved to use this information in future work. Using queries, you can transform data according to a given algorithm, create new tables with performing the simplest calculations in them, while the primary data remains unchanged. To find out what is currently in the warehouse, you need to create two simple queries: “ Came to the warehouse"And" Out of stock", Which will simply summarize information about the movement of goods from the tables" Invoice"And" Demand».

CREATING A REQUEST "COME TO WAREHOUSE":

Tables / Invoice / Add to / Close

View / Group operations

Field / The code

Group operations / Grouping

Sorting / Ascending

Field / Has come / Grouping /

1. Create a request using the wizard.

CREATING A REQUEST "OUT OF THE STOCK":

Database Objects / Queries

Creating a request using the wizard

Tables and Queries / Demand

Available fields / The code / > / Gone /\u003e / Next

The final / Outcome … / Sum / Further

Request name / Gone with warehouse / Change request layout / Done

Sorting / Ascending

In the second column, the field / Gone / Close / Save changes

After you've built these queries, you need to make sure they work. To do this, enter the following data in the Invoice and Requirement tables:

date

The code

Has come

00001

00002

24982

08652

09632

date

The code

Gone

00001

00002

24982

08652

09632

Test questions:

What is called a request?

What types of requests are there?

Why are the available fields selected in the query?

Practical work number 5
Creating "complex" queries

Objective: will learn to create queries over multiple tables and queries.

Work tasks:

Learn to build mathematical expressions in a query structure.

Practice of working with the context menu.

Exploring group operations in queries.

Providing means: Collection of descriptions of practical work on MS Access; personal computer, software: MS Access DBMS.

Report requirements: The results of practical work should be presented in the form of a file LAB 33.doc on disk (if necessary, printed) and a report on practical work containing answers to control questions

Work technology:

CREATING A COMPLEX QUERY OVER A TABLE AND QUERY:

Database Objects / Queries

Create a query in design mode

Adding a table / Tables / Products / Add to

Requests / Has come on warehouse / Add to

Out of stock / Add to / Close

View / Combine options / Create a

Left table / Products / Right table / Came to the warehouse

Left column / The code goods / Right column / The code / OK

View / Options associations / Flag second option / OK

View / Options associations / Create a

Left table / Came to the warehouse / Right table / Out of stock

Left column / The code / Right column / The code / OK

The emerging connection highlight (left mouse button)

View / Options associations / Flag second option / OK

Field: The code goods / Table name: Products / Sort: by ascending

Field: Name / Table name: Products

Field: Price / Table name: Products

In the next box, click right mouse button / Build …

Total arrived: \u003d »

In the second window, double-click " Inquiries »

Select " Came to the warehouse » / Sum-came / Paste

In total: \u003d [In stock]!

In the fifth box, click right mouse button / Build …

At the top of the Expression Builder, enter " Total left: \u003d »

Inquiries / « Left the warehouse " / Sum is gone / Paste

You should get the following expression:

Total left: \u003d [Out of stock]!

Sixth field / Build … / « Item left: \u003d »

Inquiries / « Came to the warehouse » / Sum-came / Paste / « – »

« Left the warehouse " / Sum is gone / Paste / OK

Seventh field / Build … / « Amount: \u003d »

Inquiries / « Came to the warehouse » / Sum-came / Paste / « – »

« Left the warehouse " / Sum is gone / Paste

The resulting expression put in parentheses / « * »

Tables / Products / Price / Paste

You should get the following expression:

Amount: \u003d ([Arrived at the warehouse]! - [Left the warehouse]!

) * [goods]! [price]

Request " In stock»Will allow you to visually see how much and what kind of goods came to the warehouse, left the warehouse and the amount of this or that product left. The data in the request you can sort, eg, by product code.

Test questions:

What are sampling requests for?

How is the context menu called?

How do I create a calculated field?

Practical work number 6Reports: creation, modification and use

Objective: learn what reports are, learn how to create reports using the wizard and in design mode.

Work tasks:

Learn to create an auto report.

Learn how to create a report that displays table data in the form of a document using the Wizard.

Learn how to create a report in design mode.

Providing means: a collection of descriptions of practical work on MS Access; personal computer, software: MS Access DBMS.

Report requirements: The results of practical work should be presented in the form of a file LAB 34.doc on disk (if necessary, printed) and a report on practical work containing answers to control questions should be drawn up

Work technology:

Access lets you create reports and mailing labels. By its properties and structure reports are a lot like shapes, but intended for data output not on the screen, but on printer, i.e. a printer. The difference between reports is that the data in them is grouped and displayed on paper with special design elements typical for printed documents, for example, headers and footers, page numbers, report creation time, etc.

CREATING REPORTS:

The easiest and easiest way to create reports is auto report. It comes in two options: auto report to columnand auto report tape.

CREATING AN AUTO REPORT IN A COLUMN:

Window "Database" / Reports / Create a

Auto reports: to column

Select the table “ Invoice " / OK

Your report is ready. Autoreport using the tape method is created in the same way, only select the table " Demand "And save as" Report requirement ».

CREATING A REPORT USING THE REPORT WIZARD:

Database window / Reports

Create reports using the wizard

Tables and Queries / Table " Products »

Available fields / Product code / > / Product / > /

Tables and Queries / Request: "In stock"

Available fields / Total received /\u003e / Total left /\u003e / Amount left /\u003e / Next

Available grouping levels / Product code /\u003e / Product /\u003e /

Total arrived /\u003e / Total left /\u003e /

Grouping … / Grouping intervals / Conventional / OK / Next

Report name " The final report »/ Done

CREATING A REPORT IN DESIGNER MODE:

Using the designer, you can develop a report "from scratch" or modify an existing one created by previous methods.

Reports / Create a / Constructor

Select as data source request « In stock »

File / Page settings… / Page / Landscape

View / Heading / Select " Inscription »

Make a headline 15 size font blue colors « Warehouse report 2001 .»

In the header area make six inscriptions vertically (14 font size, blue, italic) " Product code », « Name », « Price », « Total came », « Total gone », « Left on the sum ».

View / Sorting and grouping

Field / expression / Product code / The sort order / By ascending

Group properties / Group header / Yes

In the next line

Field / expression / Name Yes

Field / expression / Price / Ascending / Group Title / D and

Field / expression / Total came Yes

Field / expression / Total gone / Ascending / Group Title / Yes

Field / expression / Amount left / Ascending / Group Title / Yes

In the field of data draw the plate using lines consisting of six columns and one row. Then, in each cell, create a field, which should result in the following table (see below).

Product code

Name

Price

Everything came

Total gone

Amount left

Select the field " Price » / View / Properties / Layout / Field Format / Monetary

To the footer area insert date and number pages .

Insert / Page numbers ...

Page N of M / footer / alignment / Right edge / OK

Insert / Date and time… / full date format no time / OK

The date will appear in the header of the report, cut out him and insert to the footer area to the upper left corner.

To note area insert the "Goods movement" chart

Insert / Diagram … / Inquiries / In stock / Next

Chart fields: / Product code / Total arrived / Total left / Product left / Next

Choose histogram / Further

Click on left mouse button on " Total gone "And not letting go transfer it to the field area " Sum_Total received ", As a result of which a new field" Amount_Total gone "should be added to this area.

Repeat this operation for "Product left" / Next

Report field / Absent / Chart fields / Absent / Further

Name the diagram “ Movement of goods »/ Done

In order for the resulting diagram to match the selected data, you must:

Go to the database window / Window / database / Queries / " On stock »/ Open

Edit / Highlight all entries / Edit / Copy / Close request "In stock"

Go to the report window / Window / Report / Double silk on the diagram

A table with data will appear / Highlight data and remove them

Go to the first cell / Edit / Paste

Delete unnecessary columns : « Name », « Price "And" For the amount »

Close window "Data table"

Convert the chart to your liking

Test questions:

What is called a report?

How can I change the view of the report?

How do I edit the size and location of fields and labels in a report?

How to format a report with color, effects?

Practical work number 7

Working with sub-tables and setting filters

Objective: learn how to set up sub-tables, understand what a filter is, learn how to create filters and change them.

Work tasks:

Learn to create and delete sub-tables.

Learn to create and apply a filter to select the necessary information.

Learn to build an expression in a filter structure.

Providing means: a collection of descriptions of practical work on MS Access; personal computer, software: MS Access DBMS.

Report requirements: The results of practical work should be presented in the form of a LAB 35.doc file on disk (if necessary, printed) and a report on practical work should be drawn up containing answers to control questions

Work technology:

You have already met with subtables when establishing relationships between tables, but then the subtable appeared automatically, now you will create it yourself. Subtable can be created both for tables and queries, as well as for existing sub-tables. It is designed to display specific data on the screen.

CREATING A SUBTABLE:

Objects database "Tables » / « Products »/ Open

This table already contains a subtable, as indicated by the (+) sign at the beginning of each line.

Discover subtable / Left-click on the (+) icon

Insert / Subtable ... / Tables / "Requirement"

Subordinate fields / The code / Main fields / The code / OK

Now answer the question to create a connection, “ No »

A (+) sign should appear on the left before the line. Now the table "Products" contains two sub-tables, by clicking on which you can view how many items have come and gone. In the sub-table, you can also enter data that will be automatically entered into the corresponding tables, in order to make sure of this, enter the following data in the second sub-table for the product under the code 00005:

date

Gone

Exercise 1: Delete the subtable.

DELETING SUBTABLES:

Objects database "Requests" / Came to the warehouse / Open

Insert / Subtable ... / Requests / Out of stock

Subordinate fields / The code / Main fields / The code / OK

Review the data, then close subtable

Format / Subtable / Delete

Close by saving changes

Filters are designed to search and select records in tables or forms that you are currently viewing. There are several types of filters: filter by selection, exclude selection, advanced filter, filter for, etc.

Assignment 2: Create a filter and modify it.

CREATING A SELECTION FILTER:

Objects database "Tables » / « Invoice »/ Open

For example, you need data on the product under the code "00001"

Highlight product code 00001

Recordings / Filter / Filter by selection

The invoice contains records that are characteristic only for this product, this does not mean that all other data has been deleted. To bring the invoice to its original form, you must remove the filter.

Recordings / Remove filter

EXCLUDE SELECTION:Similar to the previous one, only all data will be displayed on the screen except those that have been selected.

CHANGE FILTER BUTTON:Using this button, you can select records based on data from several fields.

Recordings / Filter / change filter

Please select data multiple fields and see what happens

Filter / Apply filter

Recordings / Remove filter

FILTER FOR:

Click right by clicking in the table area

Filter for : [Code] \u003d 00001 and [Arrived] \u003d (50) / Press Enter

Recordings / Remove filter

Quest3: Create an advanced filter.

CREATING AN ADVANCED FILTER:

Recordings / Filter / Advanced filter ...

Field: {!LANG-e27880c5a7dfd5bbe3d492f2f049587f!} {!LANG-a4a7c4fcc33a87e068e61602675a458a!} {!LANG-3cb2cf4e11b265c050da4970d2451c9f!}

{!LANG-68642a204c96589ca6ea0146fbdabfd8!}

{!LANG-8fa8aac353eee92a359c52ac3570fbf1!}< #30.04.01#

Filter / Apply filter

Close by saving changes

Test questions:

{!LANG-07df72b98f9d4a4c2a9ba681a445a5a3!}

{!LANG-0adba22f955388442541e513870f7e00!}

{!LANG-29031be5299ce87d953a131cbe080905!}

{!LANG-770ec00734812b9712d12675b6737057!}

{!LANG-6db725ae0ca536d3a7eef77641ce8d5a!}

{!LANG-4e2854a6733cd4b71c8f50966e236bf4!}

{!LANG-80826979a45565bf302e85d8181e9ced!}

{!LANG-4345dedde2a266afbf7075f407771001!}

1) {!LANG-1cb4a1c1566e5d2d30d89eb58b7e7f6b!}

2) {!LANG-23c8ccab171735f073fb6d190c4be745!}

3) {!LANG-6cd9e019e6fa72920c526861064a0b6a!}

4) {!LANG-4975b214705784a2f9cb983da2f677c8!}

5) {!LANG-7b7e91512cfbd4b8e9856a6cb530a891!}

{!LANG-d72d84b71e3a2fa31d3bf129684db9d2!}

6) {!LANG-6431e0d37a08019f91dfe17846831cea!}

7) {!LANG-6781782ac501de2132881f8003a2773a!}

8) {!LANG-5624380cebb01326aaa3b3438602612e!}

{!LANG-de104c90a80c7d62229bb19147c68d18!}

Table{!LANG-897343fd8fe94b595cc1bf23007e5136!}

Table{!LANG-de376244dad5286b921282dc74bf2f8a!}

{!LANG-720af12f7b66bd6737a171559cf8e494!}

9) {!LANG-12215700c1f3274e4af6ffcf690a063a!}

10) {!LANG-42969ce35b1cf8384ad28d4cf11a53fa!}

11) {!LANG-221b8c221e08530496b17f6c3fc40d7c!}

12) {!LANG-2968528c8d056296381c81ba93753ce7!}

13) {!LANG-0fea02a18589d0305e2936248b1c4efc!}

14) {!LANG-b96a2bcd11c5e0675269d4192fb02f67!}

{!LANG-53852b49061b06842dea15ef9bb31633!}

{!LANG-6710626c81299e86150273b8b1693a12!}

{!LANG-65798fa58deca628b703eb46494c4afa!}

{!LANG-4faf53528e79bc0754b97f934385bac7!}

{!LANG-97b4843ad3e08a49ffb1e46638d0c4df!}

{!LANG-5a837b228492f0b8f0b789d85253c4f9!}

{!LANG-763e13debf5e52ded5f7f01fdc89462b!}

{!LANG-6bc256e92e3a807f9130905c3d886b59!}

{!LANG-d673172e40e297da4f3866db29de2080!}

15) {!LANG-602e7fd29a02d4a0e97147426894ac15!}

16) {!LANG-565509cbb06dc254463ff79b9fe857ec!}

17) {!LANG-5138b783e517fe1b0e133404455d1746!}

18) {!LANG-a4537505613476a66deaddbc2a83a7d9!}

{!LANG-7e2cb2f0ae95b8e6a9603947be91eb90!}

{!LANG-4345dedde2a266afbf7075f407771001!}

1) {!LANG-fd6a929c014923bf37a96938ecf6614c!}

2) {!LANG-41d36b78adc6d77f9a78b4fa8afbefb0!}

3) {!LANG-2b4738f998089671db174d55154ecd0b!}

4) {!LANG-86fd8a1bec82f54d1f81ec05c7f7495a!}

5) {!LANG-e1442f6e65f4ab6badbaa5fad1c2411b!}

6) {!LANG-c6b78f0008c85f04576f333b833dfdf1!}

7) {!LANG-e58d4432ab3b7585c81267f1f03180a5!}

8) {!LANG-1265a20cf2965de95e78503fccaee3f3!}

9) {!LANG-f34299d80f92d307cc74bf74a13380f7!}

{!LANG-906eb3fbc50ae20f5994be1620019537!} Invoice

{!LANG-6f14a5af52c30d4f1d3e881cf5f3b321!} {!LANG-81c7ab33250df58c71be5e4bd96f0d43!}

{!LANG-647435e1cc0ff20243b9416eccb9dbd7!} {!LANG-48ff2cf0365e4fca6a2f99928aee87ea!}

{!LANG-ee3f00fc31ae7abbe29820a37bc0acd7!} Product

10) {!LANG-fa061ca033773ff487f7ad4a06d29932!}

11) {!LANG-4e27e2a839d58a8b82143f0fff9b0452!} {!LANG-11b43139744b412791425b8f863db848!}

12) {!LANG-2ab91125481113904f93ab46155a763b!}

13) {!LANG-f7981dd802a850b19b0225f8e8fb86d7!}

{!LANG-695aba7792da8bd13a56deff313599ca!}

{!LANG-4345dedde2a266afbf7075f407771001!}

1) {!LANG-77c837327701c62a6babcf9e150010f9!}

2) {!LANG-1515b94fa1f3db42a5528142802fc688!}

3) {!LANG-4d285223f4b351a8ae81651df497e188!}

{!LANG-9ddab977fea5d61d2a9ceafd87f4e8c0!}

{!LANG-e8a6216b811df98821cacc8683083b2e!}

{!LANG-6c4686d945601907d2c288ebf6e92760!}

{!LANG-5b6d1a384a1b36382b9559c8b8f921a4!}

4) {!LANG-96b640dff43a291e76dd4eebe9848a6a!}

5) {!LANG-cb22943251540f0f63ba89af485cd0e9!}

{!LANG-220c5b7d7eaf53084e514cda49e80166!}

{!LANG-0e90d8c25a3d60e5f6271c02318dfdcc!}

{!LANG-cd4be36327f40afb53d166f695f5c1f9!}

{!LANG-4345dedde2a266afbf7075f407771001!}

1) {!LANG-014e205512eacdefc9eba806c342c204!}

2) {!LANG-d3cbc2eeef00ddd3b403a9886a4ba16d!}

3) {!LANG-655529ee4165719c1d8e12ce64428eff!}

4) {!LANG-969fff8fe9dd0093512ef72af6bf64b2!}

5) {!LANG-4429df7a5e7b108e02e136c9f2d6b573!}

6) {!LANG-dc4dddfbc8f52364c2fecc8ea081a668!}

ACCESS

{!LANG-959fa5052e972db8a42b4ceb576b4c1f!}

Theme: {!LANG-81dc7539db1c56fb0a31ccf20f14668f!}

{!LANG-248654549acda6562fcb99c8f95cdb42!} {!LANG-5488e61bc83c28b44db740dbd458c511!}{!LANG-4c19a4a6e33931bb486d9bf49f2e8b71!} {!LANG-202e1738a209fb98515e5dbec98e9326!} .

Objective:

{!LANG-d4082cde11fb841ce6c69fd58de99d0b!}

{!LANG-2564176dd30f6678e5babdd74225e6ae!}

{!LANG-910773dfe51d73d4f9b223f3565fed7d!}

{!LANG-289b6c3d79d08a6f9fe7147fd555b355!} {!LANG-1bb7eda8fae6a98637145f3e229d5300!} {!LANG-0bdf91642143c91f362284c281c0309c!} {!LANG-3d54c70f047b79854aa263ab8be4bbee!} {!LANG-cf512980b439162be6af190a17c25eb6!} ».

{!LANG-889cc0f6258e73d930b222e59fb9c0f8!}

{!LANG-d1cf5cdb03b4ce221297aacac9143087!} {!LANG-202e1738a209fb98515e5dbec98e9326!} . {!LANG-ff2f7a5af243afbe9ce968318f6e9d78!}{!LANG-c53cc04ad7ceb5db1701402f257010f6!} {!LANG-8506e8be09a1cc207e22520285e18198!}« OK ».

{!LANG-5834af3d6fab97985a3937ea694424f7!} {!LANG-5488e61bc83c28b44db740dbd458c511!} .

{!LANG-e3d11ec9b8f78958268f0e6baa0fdd17!} {!LANG-932441c1e4391ffb2e487143b1cd151c!} {!LANG-0cdf9542b843849801ab99192cb8b51c!} {!LANG-633a58529754f4b52b742926c61a423e!}

{!LANG-ddb1cad0b6d5f5193cb992d62e578d88!} {!LANG-344b4b7e0b52d86f2e5e2549e5448f97!}{!LANG-f1f1b73c60eb11b6c15e067fbd3465f4!}

{!LANG-40a1a336f981ebd37a8ede839e14f93b!}{!LANG-15f019db2f0cdfd9ac85d7a9bfafb73b!} {!LANG-a3518097a5ae33510b2bcd6ff4c3e9cb!} {!LANG-7fa538f5491cac5ef5f45539b900669c!} {!LANG-7823ed8b6a6b244ef68d4742e99b71b7!} “ OK”.

{!LANG-5c0407b5442b26cc83c87365e329bda5!}

{!LANG-59668cce7c74f54f6cd4c069211dae05!} {!LANG-3e7ba202b0beb978a77fa3f9c037e93d!} {!LANG-9d1abd6fa762a74357021f69961da725!}

{!LANG-c4aca91d3f538a8d62869089a77a9edb!}

{!LANG-728c37018704270a86866350689cdc4b!}

{!LANG-85ab44ee06a0c0bbbd1eaf8b399efbe3!}

{!LANG-ad904318eb0c09768622e17b91a3cf97!}

{!LANG-6eb6c5d250c201d6728070ee6a731512!} {!LANG-0b0b3233d70b9afa71460f04eb58a789!}

{!LANG-527cc5fd364ff5f3ae6d0cca6f542e34!}{!LANG-9e5df5f6dda36996d4d81662f13ff977!} {!LANG-527cc5fd364ff5f3ae6d0cca6f542e34!} .

{!LANG-5fac933c1c82db569b95172f9f37cd97!} {!LANG-5488e61bc83c28b44db740dbd458c511!} {!LANG-a744e8644a751cbe8afca80f210f5559!}

{!LANG-a57961568ee74993aa338c93206302e8!}

{!LANG-b5fe18d5b94ac069ed3830fb18c6fb90!} {!LANG-a3f61e20de9a81c12d64c7008dcc2a4f!}

{!LANG-63de7f578a05543f7381a80bb2e4fc12!} {!LANG-76eba2e26aa9a220da0319b1ccb022b6!}

{!LANG-577b22956e4b9f8baf94e470d840f886!} {!LANG-8bc594131d66bc6250a92f8d52148538!}

{!LANG-a2130ebce325b81d0ffefde7c411ed66!} {!LANG-39235e42cd662d66a0c6be2638a734cb!}

{!LANG-2689defaa6d32022f7f189f706324f8b!} {!LANG-5488e61bc83c28b44db740dbd458c511!} .

{!LANG-68a9d9569890364364dc32993bcf79c7!}

{!LANG-3e7ba202b0beb978a77fa3f9c037e93d!}

{!LANG-527cc5fd364ff5f3ae6d0cca6f542e34!}

{!LANG-4150c52e2fd3f569a735a06379b0b141!}

{!LANG-0ed93715050c868e3b1780e4df3a5e27!}

{!LANG-28ac7592af84e818ff0c166e477dda1e!}

number

Text

3

{!LANG-d5676273cdc51046b1d95eb692bd0283!}

{!LANG-f25dd53921040720250dfd010453ab2f!}

{!LANG-57a5c5e0dbfd0beb5173dc4cc54573e4!}

{!LANG-bcde26c8e7885ff4bb1b8e2a9bcca9c6!}

{!LANG-541b013a4c5692b0d3f3b099f8c7ddc4!}

{!LANG-f25dd53921040720250dfd010453ab2f!}

{!LANG-5218d600b2e769677c58628b0fae3f16!}

{!LANG-bcde26c8e7885ff4bb1b8e2a9bcca9c6!}

{!LANG-e73546317658639bddb24edcbeb01267!}

{!LANG-f25dd53921040720250dfd010453ab2f!}

{!LANG-5218d600b2e769677c58628b0fae3f16!}

{!LANG-bcde26c8e7885ff4bb1b8e2a9bcca9c6!}

{!LANG-8f8ad8389c847e32db34f37a7255ef2a!}

{!LANG-f25dd53921040720250dfd010453ab2f!}

{!LANG-5218d600b2e769677c58628b0fae3f16!}

{!LANG-bcde26c8e7885ff4bb1b8e2a9bcca9c6!}

{!LANG-ddcd8dcfaa67208f659c389c26b61b83!}

Text

3

{!LANG-90c628b9b88b357bcd596c7eaa244975!}{!LANG-2272912000e22fb54d530c08ed9bf9cf!}

{!LANG-8c9176284285ac32285435dbc29c0050!}

{!LANG-9dea831a521f7127c5f9693920019d9b!} {!LANG-93466a957ff5193eb45f997d20571672!}{!LANG-f66263557898dc1686806f985702c6ac!}

{!LANG-5268257d62d8504b3d53dec3ff9548b5!} Key field {!LANG-3c8820ffb6ffe486956948caf27069e9!}

{!LANG-43d872fa487565f26ca3a885e0a51dd7!}{!LANG-4752291241718b03c9d4f8b08e5a77bb!} {!LANG-f4d8552cb383405152f78230c7c3dcf6!}

{!LANG-26766f6aaa65f5ad166af6e040a678da!}

{!LANG-a243a9bd447f30538c3890b50466dd08!}

{!LANG-8b80e12fa89f463e422c44160f78bc02!} {!LANG-a1fccd920f9d41d89f2ee1eeee383358!}

{!LANG-c3af4ae7620503a657c1d266f1d48546!}

{!LANG-e33143a373a3b0d98de2ff2a7e7faa53!} {!LANG-5488e61bc83c28b44db740dbd458c511!}{!LANG-0e3dc19c45c659290866823c5cc1e777!} {!LANG-6ebe71e941dc988b1e5c3cb11167e20c!} .

{!LANG-38b7eb626a8b684bb7b5a2d210993ebe!}

{!LANG-7625f97a033cc086c4b9d5271a84f711!}

{!LANG-225b9b49b869becb8a7f3e9bd0edcd46!} {!LANG-4c6ed3f1d10408fae9e2ecddef05bce5!} {!LANG-db5648cf0fb07dbb60a4ac28ab5a03b5!}

{!LANG-03dcafe333c82340c93035b493f76fcc!}

{!LANG-05896d24a9a77ce96f257b461a50850e!} {!LANG-5488e61bc83c28b44db740dbd458c511!}.

{!LANG-590d6c910a779496372f62770615f3a6!}

{!LANG-8a932912520e4479398a7de99954b5a8!}

{!LANG-5a39c0e07d7a0ab5062f07367ee8707f!}

{!LANG-0844479571a18313a3c90f72bac13d60!}

{!LANG-4e18428d8b7a8c5d505b46857ee18677!}