I. Laboratory work from data base Access. Microsoft Access Labs Explained Labs with Microsoft

Pedagogical College named after Zh.Dosmukhamedov

DEPARTMENT OF INFORMATICS

LABORATORY ROBOTS

PROGRAM

MICROSOFT ACCESS

RETAILER: Sultanova Gulshat Berikivna

Uralsk -2015

Practical robot number 1

DB creation

Meta robots: Learn how to create a database in MS ACCESS and in a different table in a different way.

Work manager:

Find ways to create database tables.

Familiarize yourself with the main database objects.

Take away the skills of the robots from filling the databases.

Safeguards:

Vimogi to the sound: Subbags of practical work to file at the sight of the LAB 29.doc file on disk (if necessary, enter to another) and issue a call practical work revenge on the control diet

Robot technology:

launch MS ACCESS: enable button START , select from the menu PROGRAMS , then choose MICROSOFT ACCESS .

When you start Access, a dialog box pops up, for help you can do something NEW BASE DANIH, how to save on disk " BUT» under the singing names. After what to show up at the window "DATABASE" , where the year will be created and other objects of the data base, the table itself, drink, form it. Let's get it all right.

DATA BASE CORRESPONDENCE:

Nova base danih / OK

Name the file: = .... / Create

CREATING A TABLE IN CONSTRUCTION MODE:

Objects bazi danih / Tables

Creating tables in design mode

Field name: = Number / data type = lichilnik / description = record number

Field name: = the date / data type = date hour / description = due date

Field name: = The code / data type = textual / description = product code

Field name: = It's come / data type = numerical / description = kіlkіst od. goods

Saving table object in: = invoice /yak table / OK

no

close : Invoice: table / Vidkriti table "Invoice"

Number

the date

The code

It's come

00001

00002

24982

08652

09632

09633

00003

00004

08521

08522

08523

55546

CREATING A TABLE FOR AID MAISTRA:

• Vіknі database / Creation of tables for the help of the master

Dilovi / Zrazki tables / Vіdomostі about zamovlennya

Irrigations / Sale date / > / Rename field: = the date

Irrigations / The code Zamovlennya / > / Rename field: = The code / OK

Irrigations / Kіlkіst / > / Rename field: = Pіshlo / OK / Next

New table name: = Wimogi

Koristuvach signing the key independently / Dali

Select a field with a unique skin record data / Date

Stars … / Tables are not connected / OK / Yes

Change structure tables / Done / (At the end of the day, what happened)

in a row" the date» swipe the key field / Edit / Key field

Add an empty row / Insert / Rows

Field name: Number / data type: numerical

Field name: the date / data type: date hour

Field name: The code / data type: textual

Field name: Pіshlo / data type: numerical /file/ save

Field name: Number / data type: lichilnik /file/ save

close /Vidkriti table « Vimoga »

Number

the date

The code

Pіshlo

00001

00002

24982

08652

09632

09633

00003

00004

08521

08522

08523

55546

CORPORATION OF THE TABLES WITH A WAY OF INTRODUCTION OF DATA:

• Creation of tables by way of introduction of data

View column Field1 / Format / Rename Stovpets / the code goods

Field2 / Change column / Product

Field3 / Rename column / name

Field4 / Rename Stovpets / Price

On the supply, create a key field at once / Hi / save / close

See table " Goods» / Constructor

Field name: Product code / data type: Textual

Field name: Product / data type: Textual

Field name: name / data type: Textual

Field name: Price / data type: penny / Power of the field / Zagalni

Field format / penny

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

Product code

Product

name

Price

00001

Steel 1P

Wooden letters

2500

00002

Steel 5Kr

Wood round round

1300

24982

Stilec

Soft for the office

08652

Stool

Wooden folding

09632

Armchair 4MOF

M'yake for the office

1650

09633

Armchair 1MO

M'yake for repair

1500

00003

Steel 2Zh

Wooden magazine

00004

Steel 6UnS

Universal folding

1150

08521

Shafa 1US

Wooden hanging

1620

08522

Shafa 2pl

Wooden dress

2100

08523

Shafa 4kn

wooden books

1950

55546

Police

Navisna knizhkova

Control nutrition:

What is an Access DBMS?

How to create a new data base in Access DBMS?

What objects are used by Access DBMS?

What else do we ask different types?

Practical robot number 2The creation of links between the objects of the data base. Formy

Meta robots: Learn how to make connections between the objects of the data base. Learn to create forms for the help of the master of forms, to establish the power of forms and objects.

Work manager:

Learn how to say the data of the various tables.

The practice of the creation of forms for the help of Maystra.

Learn to establish domineering forms.

Safeguards:

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 30.doc file on the disk (if necessary, put it on another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

INSTALLATION OF LINKS IN MIZH TABLES:

Objects bazi danih / Tables

Service / Schemes danih / At the vіknі "Adding tables"

Tables / Invoice / Add

Vimoga / Add

Goods / Add / Close

Stars / Change calls / New…

Leo table / invoice / Rights table / Goods

Leviy Stovpets / The code / Right side / Product code / OK

(Zvernіt respect, schob "Type of vіdnosiny" buv one-to-rich )

United… / Merge less and less records, for some, the fields of both tables are combined / OK / Create

Stars / Change calls / New…

Leo table / Goods / Rights table / Vimoga

Leviy Stovpets / The code goods / Right side / The code / United…

Association only quiet records , in some ways the fields of both tables are folded

OK / Blueprint type: one-to-rich /Create

Directly change the link at the presence of the link to help you with the table "Goods", for which: go to the table " Goods»; levoruch in front of the skin row, a sign appeared + ”, if you click on the new mouse with the left button of the mouse, then you will see subtable іz danimi z “Invoice”, for the same product. shob make it easier to get information you can write a sip of water, but sometimes it’s better to make calls that you made.

FORMI

Forms allow you to enter data in database tables without direct access to the tables themselves, so that - tse zasib for entering data . Sens form in order to give coristuvachevі those fields, as you need to remember. Tsim i is a handy form. For additional forms of data, you can not only introduce, but also visualize, so you can look back based on records tables.

MISSION FORM FOR HELP MAISTRA FORM

Objects of base data / Form / Create a form for the assistance of the master

Tables and requests / Goods

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

Im'ya form: = new product

Designate: Enter the form for review or data entry

Done (div. fig. 3.2)

Rice. 3.2

Set the authority forms that allow you to add entries.

INSTALLATION FORM POWER:

View the "New product" form / constructor

View / power / Dani

Permission to change / Hi

Permission to leave / Hi

Allow me to add / So

close shape / Save change/ Vidkriti New product form

This form allows you to add more entries to the "Goods" table. In the "New product" form, enter the following data (div. below).

Product code

Product

name

Price

00005

Style 11OS

Wooden office

2750

24983

Stilec 13OFK

Soft wrapping for the office

00011

Shelving 1Kn

wooden books

2600

08653

Stool 2Cr

Wooden round

Control nutrition:

Navіscho to serve the Formy structure?

How does the form have a transition between records?

How to invoke the dialogue of the powers of the object?

Practical robot number 3Creating Forms in Design Mode

Meta robots: Learn how to create forms like a designer.

Work manager:

Form design practice.

Close the shortcuts for creating forms in the designer mode.

Safeguards: Collection of descriptions of practical work with MS Access; personal computer, software security: DBMS MS Access

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 31.doc file on the disk (if necessary, transfer to another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

CREATING SHAPE IN DESIGN MODE:

Rice. 3.4

the date

The code

It's come

00001

00002

00005

00011

08653

Form "Nova Vimoga" can be revenged:

free fields

field zі list

little ones

date that hour

heading "Wimoga" (View / Headline…)

scrolling lines

In qiu form you enter data, ale so schob forward entries were changed.

the date

The code

Pіshlo

00001

00002

00005

00011

08653

Control nutrition:

What elements can be inserted in the form like a constructor?

New to serve Form Builder?

Yaki types of data can be saved from the fields. Bring an example.

Practical robot number 4Drinks: basic concepts and the creation of simple drinks

Meta robots: to learn how to create simply drink like a designer and with a helper master. Review of results.

Work manager:

Learn how to make a simple request in a different way.

Learn to review the results.

Safeguards: Collection of descriptions of practical work with MS Access; personal computer, software: DBMS MS Access.

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 32.doc file on the disk (if necessary, transfer to another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

ask take the required data from the table she slaps them with a handy look. You can save the charge, so that you can get the information from the next robot. For additional input, you can rewrite data according to a given algorithm, create new tables based on the simplest calculation of them, and your primary data are overwritten with the same ones. To find out what is currently in stock, you need to do two simple things: Came to the warehouse» ta « Went from warehouse”, just to sum up information about the number of goods from the table invoice» ta « Vimoga».

CREATION OF THE PICTURE "GET INTO THE WAREHOUSE":

Tables / invoice / Add / close

View / Group operations

Field / The code

Group operations / Grouping

Sorting / for sprouts

Field / It's come / Grouping /

1. Make a request for the assistance of the master.

CREATION OF THE PICTURE "PIYSHLO Z KLADU":

Data Base Objects / Request

Creation ask for the help of the master

Tables and requests / Vimoga

Available fields / The code / > / Pіshlo / > / Dali

Sub-bag / Podbags … / sum / Dali

I'm asking / Pіshlo zі warehouse / Change the layout of the request / Ready

Sorting / for sprouts

Others have a field / Pіshlo / close / save change

After that, as you prompted us to drink, it is necessary to change the way that the stench works. For whom, in the “Invoice” and “Vimoga” tables, enter the following data:

the date

The code

It's come

00001

00002

24982

08652

09632

the date

The code

Pіshlo

00001

00002

24982

08652

09632

Control nutrition:

What is called a request?

What types of drinks?

Need to select available fields in the request?

Practical robot number 5
Creation of "folding" drinks

Meta robots: learn how to make requests over kіlkom tables and requests.

Work manager:

Learn how to be mathematical in the structure of requests.

Practice work from the context menu.

Vivchennya grupovyh operations on zapochi.

Safeguards: Collection of descriptions of practical work with MS Access; personal computer, software: DBMS MS Access.

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 33.doc file on the disk (if necessary, transfer to another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

FOLDING RECORDING OVER THE TABLE AND RECORDINGS:

Data Base Objects / Request

Creating a request in design mode

Adding tables / Tables / Goods / Add

Ask / It's come on the stock / Add

Went from warehouse / Add / close

View / Association parameters / Create

Left table / Goods / Rights table / Came to the warehouse

Liviy Stovpets / The code goods / Right side / The code / OK

View / Parameters association / Assign friend option/OK

View / Parameters association / Create

Lev table / Came to the warehouse / Rights table / Went from warehouse

Liviy Stovpets / The code / Right side / The code / OK

Zv'yazok, scho z'appearing see (left mouse button)

View / Parameters association / Assign friend option/OK

Field: The code goods / Name of the table: Goods / Sorting: on growth station

Field: name / Name of the table: Goods

Field: Price / Name of the table: Goods

At the offensive field, click right bear button / encourage …

Wow it came := »

At another vіknі podvіynymi klatsannyam say " ask »

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

Ushogo came: = [Arrived at the warehouse]!

At the fifth field, click right bear button / encourage …

At the upper part of "Pobudovacha viraziv" enter " It went together: \u003d »

ask / « Went from the warehouse» / Sum-pishlo / Paste

Responsible to visit offensive viraz:

It went all at once: = [It went out of the warehouse]!

Shoste field / encourage … / « Out of stock:= »

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

« Went from the warehouse» / Sum-pishlo / Paste / OK

Some field / encourage … / « Total:= »

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

« Went from the warehouse» / Sum-pishlo / Paste

Viraz, sho viyshov take it from the round bow / « * »

Tables / Goods / Price / Paste

Responsible to visit offensive viraz:

To sum:= ([Arrived at the warehouse]!-[I went from the warehouse]!

)*[goods]![price]

Zapit " In stock"to allow you to inadvertently slander, skіlki і what kind of goods came to the warehouse, pіshlo zі warehouse, that chi іnshoy product was left for the same sum. You can give on request sort, for example, by product code.

Control nutrition:

Need to ask for a vibrate?

How to call out context menu?

How to create a field that counts?

Practical robot number 6Call: creation, modification and vikoristannya

Meta robots: learn what to call, learn how to create a call for an assistant maistra in the designer mode.

Work manager:

Learn how to make an auto call.

Learn how to create a call, which is to display data in tables like a document, with the help of Maystra.

Learn how to create sounds in the constructor mode.

Safeguards: collection of descriptions of practical work with MS Access; personal computer, software: DBMS MS Access.

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 34.doc file on the disk (if necessary, transfer to another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

Access allows you to create and send stickers. Behind their powers, that structure call rich in what they are similar to forms, ale recognized for seeing data not on the screen, but on the friendly attachment, then. Printer. Note the notes in the fact that the data in them are grouped and displayed on paper with special design elements characteristic of other documents, for example, headers, footers, side numbers, the hour of the call is just.

CREATING ZVITIV:

The simplest and easy way creation of calls, all auto calls. There are two options: autocall at stovpetsі auto call string.

MAKING AN AUTO CALL AT STILBETS:

Vіkno "Database" / Call / Create

Autocall: at stovpets

Yak dzherelo danih vibrati table " invoice " / OK

Your sound is ready. Autosound in a line way is created in a similar way, only as if it were necessary for them to select a table " Vimoga » ta save yak « Zvіt vimoga ».

CREATING CALL FOR ADDITIONAL MAISTRA ZVITIV:

Vіkno "Database" / Call

Creation of calls for the assistance of the master

Tables that ask / Table " Goods »

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

Tables and requests / Request: "In stock"

Available fields / Usyogo came / > / It went at once / > / Lost on the bag / > /Dalі

Available equal grouping / Product code / > / Product / > /

It all came / > / It went all at once / > /

Grouping … / Grouping intervals / Zvichaynі / OK / Yes

I'm calling " Sub-bag sound " / Ready

CREATING THE SIGN IN CONSTRUCTION MODES:

For the help of the designer, it is possible to build “from scratch” or to supplement the essential, creations in the previous ways.

Call / Create / Constructor

Yak dzherelo danih vibrati ask « In stock »

File / Side parameters… / Sidebar / Albomna

View / header / In the elements panel, select " wrote »

Crop Header 15 rosemary font blue color « Zvit according to the warehouse for 2001 .»

Header area robiti six write vertically (14 font size, blue color, italic) Product code », « name », « Price », « Usyogo came », « Together gone », « Lost on the sumu ».

View / Sorting and grouping

Field/viraz / Product code / Sorting order / behind growth station

power groups / group header / So

At the next row

Field/viraz / name So

Field/viraz / Price / For rostannyam / Groupi Header / D a

Field/viraz / Usyogo came So

Field/viraz / Together gone / For rostannyam / Header of the group / So

Field/viraz / Lost in sum / For rostannyam / Header of the group / So

In the field of data paint a sign for an additional line, which is made up of six columns and one row. Then, at the skin center, create across the field as a result of which the table may come (div. below).

Product code

name

Price

Usyogo came

It went at once

Lost in sum

See field " Price » / View / power /Layout/Field Format/ penny

To footer area insert date і room sides .

Insert / Side numbers.

Side N of M / footer / View / Pravoruch / OK

Insert / Date that hour... / new date format no hour / ok

The date will appear at the title of the star, virzhete yoga ta insert area of ​​the footer at the upper left corner.

To the acceptance area zvіtu insert dіagram "Rukh goods"

Insert / Diagram … / Request / In stock / On sale

Fields dіagrami: / Product code / Usogo arrived / Razom pіshlo / Lost product / Dalі

Vibrati histogram / Dali

Press the left button of the bear on " It went at once » ta not admitted reschedule yoga in field area Sum_All came ”, as a result of which a new field “Sum_At once went” can be added to this region.

Repeat this operation for “Out of goods” / Dalі

Field of sound / Daily / Diagram fields / Daily / Dali

Name the diagram " Ruh goods " / Ready

If the diagram was removed, we decided to accept it, it is necessary:

Go to the window of the database / Vikno /database/Zapiti/" On the warehouse » / Vіdkriti

Edit / Vividity all entries / Correction / Copy / Close the request "In stock"

Go to window / Vikno / Sound / Hanging seam on the diagram

Z'appear table with danimi / Vidіlіt data see x

Stand in the first center / Edit / Paste

see inappropriate stovptsi : « name », « Price » ta « To sum »

close vikno "Datasheet"

Turn the diagram to your taste

Control nutrition:

What is called a star?

How to change the sight of the sky?

How to edit the rosemary and roztashuvannya watering and writing in the sky?

How to decorate the sound with colors, effects?

Practical robot number 7

Work with subtables and installation of filters

Meta roboti: learn how to install subtables, learn what a filter is, learn how to create filters and change them.

Work manager:

Learn to create subtables and see them.

Learn how to create and set up a filter to select the necessary information.

Learn to be virazed at the structure of the filter.

Safeguards: collection of descriptions of practical work with MS Access; personal computer, software: DBMS MS Access.

Vimogi to the sound: Submit a practical work bag at the sight of the LAB 35.doc file on the disk (if necessary, transfer to another) and issue a call for practical work to avenge the check on the control diet

Robot technology:

With the sub-tables you already mentioned when links were established between the tables, but the sub-table appeared automatically, now you create it yourself. Subtable can be created as a table and inputs, and as a for the main sub-tables. Vaughn varta seeing specific data on the screen.

CREATING PIDTABLES:

Objects data base "Tables » / « Goods » / Vіdkriti

This table should already be placed under the table, about what to say the sign (+) on the cob of the skin row.

Vіdkryte subtable / Click the left button of the bear on the icon (+)

Insert / Subtable… / Tables / Vimoga

Podlegli fields / The code / Main fields / The code / OK

On food, create a link at once, give a hint, " Hi »

An angry sign (+) may appear in front of the row. Now the “Goods” table can be placed on two pіdtables, having clicked on yakі you can look over, skіlki came that pіshlo of that chi іnshoy product. You can also enter danі in the pіdtable you can also enter danі, which will be automatically entered in vіdpovіdnі tablesі, so that you can reconcile yourself with a friend to enter the tab for the product with the code 00005 next danі:

the date

Pіshlo

Task 1: View subtable.

VISIBLE PIDTABLE:

Objects bazi danih "Zapiti" / Came to the warehouse / Vіdkriti

Insert / Subtable… / ask / Went from warehouse

Podlegli fields / The code / Main fields / The code / OK

Look over the data, then shut up subtable

Format / Subtable / visuality

Close, save change

Filters recognized for search and selection of records in tables or forms, as you look at a given moment. Іsnuє kіlka raznovidіvі іltrіv: tse filter vіdіlennya, іklyuchіtі vіdіlennyа, extensions filter, filter і t.d.

Task 2: Create a filter and change it.

CREATING FILTER WITH VISIONS:

Objects data base "Tables » / « invoice » / Vіdkriti

Napriklad, you need to know about the product with the code “00001”

Vidіlіt product code 00001

Entries / Filter / Filter by seen

The invoices lost records, characteristic only given product Tse does not mean that all other data was deleted. To bring the invoice into the cob view, you need to remove the filter.

Entries / Visibility filter

TURN ON VISIONS: Similarly to the front only, all the data will be displayed on the screen, the Crimea is quiet, which was seen.

CHANGE FILTER BUTTON: For the help of the button, you can select records for the given number of fields.

Entries / Filter / change filter

wrap data how many waterings and wonder what you see

Filter /Stop the filter

Entries / Visibility filter

FILTER FOR:

Press right the bear button in the table area

Filter for : [Code] = 00001 and [Received] = (50) / Press Enter

Entries / Visibility filter

Task 3: Create filter extensions.

ADVANCED FILTER CAPACITY:

Entries / Filter / Filter extensions…

Field: Date / Please click on the field right bear button /

Stay on the offensive viraz:

[Invoice]![Date] > #01.04.01# And [Invoice]![Date]< #30.04.01#

Filter /Stop the filter

Close, save change

Control nutrition:

How do you know what table chi will already clear the subtable?

New filter assignments?

How to create a table filter for some kind of field?

How to induce Viraz in the Filter object?

1.1 Laboratory work No. 1: Data base creation, which is compiled from one table

Objectives of work:

1. get to know the basic concepts of the database;

2. Learn how to create a database table like Constructor;

3. master the transition from the Constructor mode to the table mode;

4. master the basic methods of filling and editing data base tables;

5. learn about simple sorting of table values;

6. get to know the notes by sight,

7. Learn to save and secure the data base;

8. learn how to read tables.

Etapi roboti

It is acceptable that you need to prepare the simplest version of the data base, if all the information is taken from one table.

2. Designing the structure of possible database tables.

The table can be created in the Design mode. At n_y - 5 pol_v (declaration number, product name for TNZED, kіlkіst, cіn for one product) and 7 records.

3. Creation of a database schema.

For the obviousness of one table, the data base schema is simple: it is composed of one set of tables, tobto. її you can not work on purpose.

4. Entering data at tables.

Which option will have less than one table. The table can be created in the Design mode, and loaded - in the Table mode, moving around in the middle after the additional arrows, tab keys or bears.

Task 1. Enter a new data base and create a table structure with information about the goods of the militant organizations of the Russian Federation.

Wiklichte Access. For which girl, click on the pictogram Microsoft Access . In front of you, you can see the whole system of searching for data bases, hovering over fig. one.

Rice. 1 Data base management system

To create an empty database, you need to create the following:

1. Distributed New empty database vibrati New database near the central part of the ear bud (Small 1) or use the button to speed up, select the item from the menu Create.

2. A new database of data will appear at the left part of the world. In the Name field, the file needs to enter the name of the new data base, so enter your name in the name of the data base. (Mal. 2).

Rice. 2 Expanded New data base

To select a folder in which to save the data base file, you need to select it with the button.

Press the button Create. A new database is opened with a single empty table and the program switches to the table editing mode, the views in fig. 3.

Rice. 3 New database window

3. In the Constructor mode. For this, press the icon Modes - Constructor at the top left corner. Enter table name Information about the product. Switching to the robotic mode is performed by an additional button. Mode, which is located on the page, on the tab.

4. Enter the word Declaration number and press .

5. Zrobіt yogo key - type of data Lіchilnik. Be-yakiy іnshiy vybiraєtsya for the help of the fall menu.

Guessing. The transition from the middle to the middle is done in one of the ways: with a bear; I will press on the key; arrows; keys.

6. Save the fields in the Constructor with data from the table. 1. Zagalnі power field zalishaєmo for zamovchuvannyam (like the program itself).

Table 1

8. Switch to table mode. For whom, speed up in one of the following ways:

Click on the button Mode - Table mode;

Close the window of the Constructor, open the table "Information about the product" - click on the icon of the table "Information about the product";

Press the left button of the mouse on the table “Information about the product” and select the Table mode.

The introduction of data is to be added to the regime, filling up the tables. Field value Declaration number will change automatically.

9. Save the database with the values ​​of the table. 2. Stovpets price per item memorize independently.

Table 2

10. Save the entered data by pressing the "Save" button. As a result, you took a table, with which you can work out.

Task 2. Learn about the functions: save, close, reclaim.

2. Clicking on the lower button Close in the right upper codend open the table, close the table.

3. Open the table Information about the product.

Task 3. Sort table values.

Respect. In order to sort the values, it is necessary to put the cursor in the list of columns, what to sort, and click on the button: for growing or for falling. (Mal. 4)

Rice. 4 Sorting and filtration

Sorting can be done by clicking on the arrow in the order from the field name (Sk. 5).

Rice. 5 Sorted by field Product name for TNZED

Sort by:

1. Dani at the field Product name for TNZED– in alphabetical order (place a marker on whether the name of the item is the name of the product for TNZED and click on the bear on the button).

2. Data at the field Kіlkіst.

Task 4. Seek the search for notes for a reason.

1. Insert a text cursor near the field Kіlkіst.

2. Click on the button Know, which allows you to know the record for the entered values. As a result of which the dialogue will appear, presented in fig. 6.

Rice. 6. Vіkno

3. Type the number 5 in the field Zrazok and press the Know button.

Respect. If it is necessary to know such a similar record, then click the bear on the button Know distance. Poshuk at the flow field, as if a senior ensign was installed. In a different way, I searched for all the fields. You can secure the register from whom.

After the completion of the work, click on the button close.

1.2 Laboratory work No. 2: The creation of a database that is made up of two tables

Objectives of work:

1. learn to see tables;

2. learn how to create database tables like tables;

3. learn to create independently the key field;

4. learn how to create data entry forms:

5. Close the names to fill in and edit the data base tables.

Stages of work:

1. Designing the structure of the database.

Let's create a folding version of the data base. It will have two tables: Information about the product and Declarant.

2. Construction of empty database tables.

Faster in another way to create tables, and in itself - Table mode. The tables of information about the goods will have the following fields: number of the declaration, number of the declarant, name of the product TNZED, kіlkіst, price per product unit. The fields Code of the declarant, Name, First name, By father, address are saved in the next table Declarant.

3. Creation of a database schema. AT to this particular type the tables are tied with a "one-big" link. Links should be inserted for empty tables. Like the tables of zapovneni, they can blame the problems of the hour of the meeting of the calls and the authorities of the fields.

4. Entering data from tables.

Let's create a data entry form. For the obviousness of the related tables, the order in which they are filled in is important.

Hid roboti

Task 1. Enter the initial data base, prepared for the last lesson

1. Call the program access.

2. Open the database.

Task 2. View the table Information about the product

1. Go to table name.

2. Press the key.

3. On the request for confirmation of the completion of the table, give confirmation So.

3. Create table Declarant

1. Select a tab Virobnitstvo - Table.

Change the fields. To change the name of the page, you need to double-click the mouse button on its name, enter a new name for the page and press the key Enter. The new name will be saved automatically, and if you change the name, it will be updated.

2. Enter the name of the field: Code of the declarant, Name, Name, By father, address.

Declarant by clicking on the button Save.

The table will look like this (Mal. 7).

Rice. 7 Table creation window

4. Go to Mode Constructor, by clicking on the button Constructor, and wonder how the fields are set: the field Declarant code- Type of data personal, prizvische, Im'ya, According to the father, Addresses- Textual

Task 4. Create a table Product information

1. Press the bear on the button Virobnitstvo - Tables.

2. Enter the name of the field: number of the declarant, number of the declarant, name of the goods for TNZED, kіlkіst, price for one product.

3. Save table with names Information about the product, by pressing the File - Save button.

4. Go to Mode Constructor and wonder how the fields are set. Field Declaration number already automatic assignments are key, the field type is numeric, the field Product name for TNZED- text, fields Number of the declarant, quantity– numeric, field price per item- Financial. 3 field Declarant's number rose special. Yogo type is numeric. The main characteristics of the field are not changed. In addition, the value of this field is not required to be typed manually, but to choose from the list, which should be entered in the table Declaration. For whom in mode Constructor in The dominance of the field Next, indicate what space can be added here for the offensive scheme: select bookmark Substitution, element type keruvannya – Field with a list dzherelo ryadkiv - Declaration. Subtract the values ​​of the elements as shown in the small. eight.

Rice. 8 Table in design mode

Change Number of columns by 2, so that it is not only the number of the declarant, but the number of the declarant.

5. Save money.

6. Close the table.

As a result, your robots will take two unlinked tables. It is necessary to create a scheme of data from links.

Task 5. Create a data schema

To insert a link between the tables, the fields of these tables must be crossed. Revisiting, creating, editing, and revisiting links are reflected in the scheme of data. To enter the data scheme, it is necessary to speed up the button Data scheme on deposit Work with databases.

1. Press the button - Data scheme.

2. At the end, what happened Adding tables see table Declarant and click on the button Add. See table Information about the product and click on the button Add. Vіknі Data scheme z'appear umovny view tsikh table. Click on the button close Vіkna Addition of tables.

3. Larger tables Information about the product so that you can see all the fields.

4. Put the bear on the field Declarant code in tables Declarantі, without letting the bear button in, drag її onto the field Declarant's number in tables Information about the product. Let the bear out. Z'appear dialogue Vіkno Zv'yazku, presented on small. nine.

Rice. 9

5. Highlight icon Ensuring the integrity of data. It’s impossible to grow, as if both fields of the task are not the same.

6. Highlight icon Cascading view of po'yazanih fieldsі Cascading renovation of the connected fields. I have made it so that when the record is deleted or updated, the declarant’s code in the table Declarant all records from the tables will be deleted or updated Information about the product, where were the standard numbers.

7. Click on the button Create. Z'appear zv'yazok "one-bagatiom." The data scheme is shown in Fig. ten.

Rice. 10 One-to-a-bag data scheme

8. Close the data schema by pressing the button close at the upper right kuti vіkna that vіdpovіvshi is firmly on the food for the savings of the data scheme.

Task 6. Fill in the Declarant table with values

1. Open the table Declarant in mode tables.

2. Fill in with records from the table. 3. Field Declarant code be stored automatically.

Table 3

3. Save the table and close it.

Task 7. Create data entry forms

To create a form for an additional tool

1. Open the table Information about goods in table mode.

2. Go to tab fold the one in the group Formy click the mouse button on the tool The form. The form is automatically created and displayed in the layout mode (Sketch 11).

Rice. 11 Automatically folded shape

3. Close the form. Before closing, a window will appear about saving the form.

4. Press the button So.

5. At the end, what happened saving enter name in form layout Information about the product and press the button OK.

Task 8. Add to the data base a record, vicorist form

1. Fill in the form with data, pointing to the table. 4.

Respect. The transition from the input field to the step field is carried out with a key or a bear. To go to new record next click on the button.

Table 4

2. Save the entered data.

3. Close the form.

4. Open the table Information about the product. Perekonaytes, scho z'appeared new entries in the table.

6. By pressing the bottom button close at the top right corner, close the table.

Task 9

1. Open the table Declaration.

2. Correct the call of Petrovska O.P. on Petrov.

3. Save the table.

4. Close the table Declaration.

5. Open the table Information about the product.

6. Change your mind, what have changed.

7. close the table Information about the product.

Zavdannya 10. Reverse the cascade of the povyazanih fields.

1. Open the table Declaration.

2. View the first entry (see rows and press).

3. Wait for the turnaround food.

4. Close the table Declaration.

5. Open the table Information about the product.

6. Reconsider that the records have faded.

7. close the table Information about the product.

Submit your declarations:

Open tables Information about the product , Declarant і form Information about the product on the screen.

Task 11. Finish working with the Access program.

1. Win the team The file is out.

2. As you have edited in the database, there will be information about the savings of changes. Give advice on the new one firmly.

1.3 Lab work #3

Objectives of work:

learn to design and create folding databases.

Stages of work:

1. Designing the structure of the database.

2. Construction of empty database tables. Create a collapsible version of the data base that is folded from three tables: i Details of the declarant.

3. Creation of a database schema. In this type of table Information about the goods, Declarant combined with a link "one-rich", tables Declarantі Details of the declarant- Sound "one-to-one."

4. Entering data from tables. Create a data entry form.

5. Vykoristannya bazi danih for practical tasks.

Hid roboti

Task 1. Open the initial data base, created on the last day

Task 2. Delete all entries in the Declarant tables, leaving the structure

1. Open the table.

2. Go to all entries.

3. Press. Press the button So at the confirmation of the withdrawal. (You can vikonati command Golovna- Tab Entries and press the button Vidality record).

4. Close the table, saving її.

Respect. If you enter data into the table, in which key field you have the type of name, then the name will be changed from the number that was assigned to the remaining record. So that the numbering starts again from 1, hit the command File - Management–Squeeze that restore data base. Check, so that the program worked.

3. Create a table Details of the declarant

1. Mode Constructor enter the following fields: The code(data type) - key field , Fields with names of the place of the people, community, country of permanent residence, type of document, which confirms the person, series No. – the type of data is textual, and the date of birth is – Date hour.

3. Switch to Table mode by pressing the Table mode button.

4. Close the table, save first. As a result, you reject three tables, two of which are connected, and the third - none.

Task 4. Correct data schema

1. See before distribution Work with databases, click on the button Data scheme. Show up dialogue window – Data scheme.

2. Right click - Add table. At the window Add tables see the table Details of the declarant and click on the button Add, and then – behind the button close vikna Adding tables.

3. Put the bear on the field The code at the table, not allowing the bear button, drag it onto the field Declarant code in tables Declaration. Let the bear out. Show up dialogue window Stars.

4. Ensign Safeguarding the integrity of data. It’s impossible to grow, as if both fields are not the same.

5. Click on the button Create. Z'appear zv'yazok one to one. Tse means one entry in the table Declarant check one record for the table Details of the declarant. The data scheme is shown in Fig.12.

Rice. 12 Chart of data

6. Close the data schema, saving її.

Explanation. Now post the task of entering entries at the same time in different tables: Declarantі Details of the declarant. It is possible, obviously, to try to enter the values ​​into the skin table okremo, but it’s better to check both tables for entering data at once. It is easy to enter the values ​​through a specially created form, into the existing fields of all necessary tables. Data is entered in the form, and the results are loaded into tables.

Task 5. Create a data entry form

1. Go to tab fold the one in the group Formy press the button Other forms. From the list that is revealed (Mal. 13) choose an instrument Master of Forms.

Rice. 13 List of other forms

2. Vіkryєtsya vіkno Creation of forms(Mal. 14).

Rice. 14

3. Select all fields from the table Declarantі Details of the declarant. For whom to choose the name of the table Declarant in the field Tables/requests. The result has a list of fields in the window Available fields. Click on the >> button to move all fields in the list.

4. Let's choose table names Details of the declarant in the field Tables/requests and again click on the button >>.

6. Leave old look form in one step(vibrations for zamovchuvannyam).

8. Choose the desired style (for example, Zvichina).Click on the Dal button.

9. Enter name form: Zahalnaya form. Click on the button Ready. As a result, you discard the form, in which you can change the actual data and enter new values. Take values ​​from that table, as it is necessary (part of the value – into one table – to the next).

Task 6. Load data tables

Respect. The Code and Declarant Code fields are filled in automatically.

1. Table data Declarant induced at the table. 5, and table data Details of the declarant at the table 6.

Table 5

Table 6

2. Close the table, first saving її.

Open the table Declarant and Details of the declarant and perekinaytes, scho z'appeared in them. Close tables. Save table Information about the product.

Task 7. Learn how to filter

1. Open the table Details of the declarant.

2. For filtering, use a group of commands Sorting and filter on deposit Golovna(Mal. 15). To increase and remove the created filter, use the button Stop the filter. To remove the filter, use the button Dodatkovo that point Clear all filters.

Rice. 15 Group of commands Sorting and filtering of the Main tab

3. To create a simple filter, select the following action: click on the button – Stop the filter

4. Activate the page for which you need to create a filter. Click the bear on the field Rick of the people. The selection arrow will appear on the active field. Click on the arrows.

5. The list of all field values ​​must have an ensign See everything. Next, you need to set the values ​​of the field, so you need to enable the filter.

6. Set the flags for 1952 and 1987.

7. Press the button OK. As a result, records will be selected, in which field values ​​are chosen with one of the values ​​assigned by the ensign.

8. Say your choice. For which it is necessary to press the button, as it is now called Visible filter.

9. Click on the button – Change filter.

10. Change filter. It is permissible to indicate between the change values. In the field Rik people click on the arrow . At the field, what happened, choose Date filters – After… and dial 1.01.1985 .Click on the button OK, you take away the table, in which there are records with the fates of the people more than 1985.

11. In order to take away the records of the declarants, for those of the people of the country, they start with the letter “І”, it is necessary to click on the arrow, which is known to be instructed from the field City of people. Vіknі choose Text filters - Start with z - Type the letter "І".

12. Independently choose City of people, which do not begin with the letter "K".

Dovidkova information. Virazi at the filter can add up the exact values, like vikoristovu Access for matching in that look, in which the stench is introduced. Numbers should be entered without intermediates, for example, 22. The text may be placed at the foot, for example, “Gorodetsky”. Dates are interspersed with # symbols, for example #10.01.99#. Elements of expression can be tied with operators:

arithmetic: *+, -, /^:

alignment:<, <=, >, >=, =, <>;

logical: And (I), Not (Hi), Or (Abo);

Like – for vikoristannya logic replace in virazah;

In – for the purpose, to clear the element of data from the list of values;

And – to select the value from the sing interval.

Subject:

The creation of the base of data.

Pobudova tables at the database.

Meta robots:

Learn to form the structure of tables, enter and edit data, assign a key for linking two tables.

Vikonanny roboti:

The main structural document in Accessє tables. Skin table to replace records of a different mind, for example, about students. Leather record of the table to contain all the necessary information about the oxidative element of the data base.

On the basis of the table, there are suggested forms, calls and zapitiv.

The database can be used as a table.

At the vіknі vіdkrytoї dannyh database press on tabs "Tables" and press the button "Create".

Select from the dialogue window list "New table" table creation method:

Table mode- Creation of tables in table mode;

Constructor- Creation of tables for the help of the table designer;

Meister table- Creation of tables for the help of the master table;

Import tables- Creation of tables by way of importing data from an existing file or other data base;

Create a table for help Constructors. Seen at the window "Constructor" ta squeeze "OK".

In the window, enter the name of the fields, select the type of data and indicate the power of the fields.

At the column Im'ya fields field names are set:

1. Number; 5. Submission;

2. Call; 6. Date of birth;

3. Im'ya; 7. Group;

4. By father;

Tables can have two fields with the same names.

For the skin field, which is turned on before recording, please specify data type.

data type determines the type of information that should be taken from each field. The type of data is selected from the column data type .

For zamovchuvannyam data type is set Text.

To change the type of data, you need to click in one of the middle columns data type . At the right part of the middle, a button for the list will appear, clicking on it to open the list with available data types.

At the column Description you can enter enough comments up to the skin field. Tsya operation is neobov'yazkovoy.

The task of the parameters of the fields must be checked sequentially, tobto. for the skin field At the beginning, you need to enter the name, then the type of data and, if necessary, a comment.

To go to the required center, you can win the mouse, the keyTab and in the end of the entry you can press the key Enter .

Black Trikutnik at the stovptsі the marking is zlіva vkazuє on that row, which has a cursor.

After designating all the fields in the table, specify one field for the selection as the primary key field. It is not allowed to enter records into the table that are repeated.

Primary key may be assigned to the table constructor mode.

In this table, the field of the primary key has a field"Number".

Who needs:

see field "Number" chi just put the cursor there;

push the button Key field on the standard toolbar from the image of the key or

menu "Edit" "Key field"

W

left view given field a small image of the key will appear - the sign of the primary key field.

Key field

The whole table will be prepared during the design of the table specification.

Who needs:

menu "File" "Save"

If the table is saved up, a dialog will appear on the screen

vikno "Safety". For whom you need to enter the name of the tableSTUDENT .

Introduction and editing of data in table mode.

At the created table, the data can be entered both directly in the tabular form for locking, and also with the help of the specially divided screen form of the coristuvach. Editing records and correcting pardons in these tables can be the same for the skin of the two designated modes.

To enter data in a table, you need to enter the data base.

At the data base, click on the name of the table STUDENT .

AT

the table is empty for entering data.

Uzdovzh of the upper edge of the vіkna roztashovanі the names of the fields in the tables.

The skin field matches the sing of the table.

Leather record borrows one row from the table.

The introduction of data at the table table is written from the keyboard. After you finish entering data in the remaining field of the Access record himself go to the first field of the new record and check for the data entry.

After entering the data, the table must be closed.

For which it is necessary to enter a binary command

menu "File" "Close"

Entry

AT to the current world provide information that will require savings, more money. To this reason, the selection of databases is an invisible part professional activity people.

The simplest data bases can be created without going into special software tools: for example, Excel spreadsheets. Ale є kіlka vіdmіnnosti between them. First, database management systems (DBMS) are developed with a security method efficient processing more information, more, more, less, how to cope spreadsheets. In another way, the DBMS can easily link two tables in such a way that for the stench it is represented by one table. It is impossible to implement such a possibility in spreadsheets. І, thirdly, the DBMS minimizes the overhead of the data base. For cієї well mark the tables, what to avenge the data, what they repeat, break into sprats of tied tables.

Irrespective of those that the world has impersonal database management systems, all stench may be similar. For this reason, we chose the Microsoft Access 2007 DBMS to enter the package Microsoft office. Os-

new Access recognition - to give a simple and accessible way to create such databases, as you need. Regardless of the simplicity of the DBMS, it allows you to create programs to achieve a collapsible structure. Behind the bajannyam, the system can be developed and nalashtovuvati by powerful forces, vicorist Visual programming basic.

Another advantage of Access is the integration of Word, Excel and other programs of the Microsoft Office package. Data are easily imported and exported from one supplement to another.

Methodical instructions include five laboratory experiments.

Lab Robot #1 Acquaintance with Access. Table set

Database of data (DB) - the collection of data, recognized for saving, accumulating that money for additional EOM, is ordered. For the creation and maintenance of data bases (their updating, security of access for requests and the appearance of data for them) program contributions titles database management system (DBMS) 1 .

Access Database Objects

Before Access database objects lie:

1. Tables - recognized for orderly data collection.

3. Forms - recognized for manual revision, change that additional data in the tables.

4. Call - wink for analysis and other data.

5. Data access pages- are recognized for review, introduction, updating and analysis of data through a measure or from any place on a computer.

6. Macros - hacks are often used for typing a set of macros to change data processing.

7. Modules are used to describe instructions and procedures in my VBA.

The main object of the data base is a table that is composed of records (rows) and fields (stowpts). On the periphery of the record, the fields are settled in the middle, for which the data is cleared.

The skin field of the table is supposed to have a unique name, as it can contain more than 64 characters. Skin field to revenge data of one type.

Textual

Memo field

number

date hour

penny

logical

Master of substitutions

tipi danih

Description

Victory for the collection of symbolic or numerical data, which will not be required to be calculated. The power of the rozmir of the field is determined by the maximum number of characters that can be entered in

field. For locking, the rosemary is set at 50 signs. Maximum number characters that can be placed in the text field, – 255 text information, for obscure pre-

what to hang 255 symbols; You can save up to 65536 symbols of Destinations to save numeric data, which are counted in mathematical roses. On the tabs Global and Substitution, you can set the power of the numeric field, among

field world, field format, number of decimal places

Victory for the presentation of dates at that hour. Select a specific date format or hour to be installed in power

Date format

Appointments for the collection of data, the accuracy of the representation of which varies from 1 to 4 characters after Komi. Number of parts can be up to 15 decimal places. Assignments for automatic insertion of unique sequences.

valnyh (increased by 1) or vipadic numbers like the number of a new entry. The number of entries cannot be deleted or changed. Fields with this type of data are matched as key fields of the Assignment table to take one of two values, interpreting

tovanih yak “So / Ni”, “Truth / Nonsense”, “Uvіmk. / Vimk." Retrieve data created in other programs, like the OLE protocol. Tse mozhe buti, for example, Word documents, electronic Excel tables, little ones, sound and video recordings and in. OLE objects link to an Access database or are passed to it. Sorting, grouping and indexing fields of OLE objects is not possible

Special type, purpose for saving hyperposilan automatic appointment fields. With this help, a field with a list will be created, from which you can choose data to be placed in another table or a set of constant values

Creations of bazi danih

2. Click on the button.

3. Enter the name of the new data base - "Notebook.accdb".

4. On the inset lines Create on the toolbar of the Table press the button K table constructor.

5. Enter the names of the fields and enter the types of data, to such a stench lie.

6. Seek out of the Design mode, first saving the table for names"Friends"; do not set key fields.

7. Open the table"Friends" under the clapping of the mouse and remember 10 rows from them.

8. Add the fields “By father” and “Date of birth”, for which:

1) insert the cursor on the field, before which it is necessary to insert a new one

2) Click on the command: lines tab Table mode → toolbar

rumentіv Fields and stovptsі → Insert;

3) clicking on the buttons Field1, rename yoga to "By father", and Po-

le2 - "Date of birth".

9. Switch to the Design mode with the command: lines tab Head-

naya → Modes → Constructor.

10. For the "Date of birth" field, set the data type Date/hour; in

choose the power field Short date format.

11. Format the table like this: 1) grid color - dark red; 2) background color - black;

3) text color – dark-black, rozmіr – 12 points, image – italics.

12. Rename the field"Hobi" at "Zakhoplenni".

13. Delete record under number 8.

14. Change the rozmir komіrok so that all the data can be seen. For whom it is enough to double-click with the left button of the mouse on the border of fields.

15. Stash the fields in this order:"No", "Prizvische", "First name", "By father", "Phone", "Date of nationality", "Zakhoplennya", "Addresses", "Index", "Photo", "El_poshta".

16. Restore empty table boxes.

17. Add a field for Design mode"Family camp", In the future, there will be a fixation of a set of values ​​​​- friendly, unfriendly, friendly, not friendly. To create a list that is being opened, we will vikoristovuvat-

wati meister substations:

1) set data type Master of substitutions; 2) at the dialogue window, what happened, choose a row “Will be introduced fik-

scoring scoring value " and press the button Dali ; 9) number of columns - 1;

10) enter data in the list - foreign, foreign, friends, not friends; 11) press the Done button.

18. For the help of the list that is being opened, fill in a new step. If the table was wide, then when filling this column, they blame the acts of incompetence: you can’t see the name of a person, for which the field is filled"Family camp". So that the ghost was constantly visible at the hour of filling the tables, it is necessary to speed up the team Close the columns from the context menu of the "Prizvische" field.

19. Show the work of vikladach.

Laboratory work No. 2 Creation of links between tables

1. Launch Microsoft Access 2007.

2. We create the data base "Firma". Spivrobitniki tsієї organіzatsії pratsyyut іz kієntami ї vykonuyut їkh zamovlennya.

If you place all the information in one table, you will become more unhandy for the work. Have nіy rozpochnitsya repeat danikh. Shchoraz, if Ivanov’s interviewer will work with any firm, he will have to write down the data about the interviewer and the client again, as a result of which you can start impersonal pardons. In order to change the number of pardons, you can split the cob table into a sprat table and insert links between them. Tse bude rational, lower earlier.

In this order, it is necessary to create 3 tables: Spivrobitniki, Clients and Zamovlennya.

3. Okremі tables, scho mіstatіyu іnformatsiyu z singі those, nebhіdno zv'yazati on єdina structure of the database. For zv'yazuvannya table following tasks key fields. The key is composed of one or more dekilkoh fields, the meaning of which unambiguously determines the skin of the table entry. The most suitable as a key field є "Lichilnik", so as a value

in This field is unique (to be included repeat).

4. Open the table Spivrobitniki in the Constructor mode.

5. Right-click the mouse on the field Caller code and in the context menu, select the Key field command. If it is necessary to insert a few key fields in tables, then you can see them by pressing the Ctrl key.

6. For the Clients table, set the key field Client code, and for the tables Enchantment - Enchantment Code.

7. Table To clear the fields Caller code and Client code. With their zapovnennі can be blamed for the difficult ones, for those who don’t have to remember all the enterprises, with which the firm and all spivrobitniks work

h code number. For clarity, you can create lists with help

schyu Maistri pіdstanovok.

8. Open the table Zamovlennya in the mode of the Designer.

9. For the field Caller Code choose data type Substations master.

10. At the window, select the command "Object" stovpets pidsta-

novki "wikoristovuvatime value from the tables or zapoku » and click on the button Dali.

11. Select a table from the table list Spіvrobіtniki and click on the button

12. In the Available fields list, select the Callback code field and press the button with the arrow to enter the field up to the Selected fields list. So just add the fields Name and Name and click on the Dal button.

13. Select the sort order for the list by field Call.

14. For the next dialog window, set the required width of the list columns.

15. Set ensignAttach the key stovp" and press the button

16. On the restMaistri substations For the consumer, replace the text for the field of settings and press the button Done.

17. Similarly, create a list that expands for the field

Client code

18. After the formation of key fields, it is possible to separate the formation of links. Іsnuє kіlka types vіdnosin between tables:

1) when "one-to-one" skin record of the key field in the first table contains only one record in the related field of the second table, and navpaki. Vіdnosini of this type are not often vicorated. Іno-

g їх it is possible to win for the bottom of the table, to sweep a lot of watering, for the addition of part of the table for the sake of safety;

2) shodo "one-to-rich" a skin record in the first table confirms the number of records in another table, and a record in another table cannot be more than one related record in the first table;

3) shodo "Bagato who's up to bagatoh" one record in the first table can confirm the number of records in the other table, and one record in the other table can confirm the number of records in the first table.

19. Close all open tables, shards cannot be created, or you can change links between open tables.

20. Click on the command: lines tabRobot with databases →

21. Even before the daily calls between the tables of the base were not, then when the The scheme of data is displayed one hour at a time Adding a table

qi , for whom to choose tables Spivrobitniki, Clients that Zamovlennya.

22. If links between tables were already set, then to add a new table to the data schema, right-click the mouse on the data schema

і select the item from the context menuAdd table.

23. Insert link between tables Spіvrobіtniki i Zamovlennya, for which select the field Code of the spіvrobіtnik at the table Spіvrobіtnik i transfer it to the other field near the table of Zamovlennia.

24. After dragging the dialog windowZmina zv'yazkiv

(small 1), to whom to increase the ensign Safeguarding your mind. Tse allow zapobigti vpadalnya vydalnya zadnієї z odnієї tanovі, yakі po'yazanі z them data іnshih іnshih іnshih іnshih zapisku zav'azku.

Rice. 1. Creating a link between tables

25. Orders ensure one-hour updates or data removal for all subordinate tables for її changes in the head table.

26. The connection parameters can be changed by pressing the button United.

27. After setting all the required parameters, press the button

OK.

28. Link between tables Clients and Zamovlennya to install independently.

29. As a result, the data scheme is to be entered, presented on

Rice. 2. Scheme of data

Laboratory work with Ms Access

Laboratory work No. 1: "Creation of data base "Nakladni"

Part I. The creation of the base of data.

Hid roboti

1) Start MS Access 2007 DBMS by executing the command: StartProgramsMicrosoft OfficeMicrosoft Office Access 2007.

2) Select "New data base".

3) Specify a new database named "Invoices" and create it.

4) Open the table in the Design mode, for which, on the "Head" tab, select the required mode.

5) Fill in the form by entering the field names, selecting from the list of field types, and specifying field names.

$- key field in the table

6) Select the keys of the table, for which you can see the key field (fields) and click on the button "Key field" on the "Constructor" tab. Close the form and fill in the tables with the name “Oderzhuvachi”.

7) Select the command: Creation  Table Builder.

8) Create three more database tables: "Product", "Invoice", "Released".

Table "Product"

table"Invoices"

table"Released"

Give respect:

9) To edit the required tables, you need to see in the list of tables and select the “Designer” mode.

10) Select the command: Database Robot  Data Scheme.

11) Add all tables of database "Invoices".

12) To insert a link between two tables: place the cursor on the link field in the head table, and drag it to the second link field in the suborder table.

13) At the beginning of the dialogue, reverse the type of connection and set the ensign.

14) Create all necessary database links as shown in the diagram.

Data schema editing:

To add a table, open the context menu on an empty area and select "Add table".

To delete a table, see the table and press the Delete button on the keyboard

To delete the links, see the links and press the Delete button on the keyboard

To change the link type, go to the link and open the context menu.

When changing the type, the link should be changed, which type is selected automatically and it is restored

"one-to-one" - how two key fields are linked or unique indexes

“one-rich” - just one field key or a unique index

"someone rich to rich" - in all other ways.

15) Close and save the data scheme.

16) To automate the entry of data, organize lists that are opened for each field. Create for the field "IPN" of the table "Invoices" a substitution from the field "IPN" of the table "Oderzhuvachi". For this, open the Invoice table in Design mode, see the IPN field and select the Substantiation tab. Save all the necessary parameters as shown in the thumbnail:

17) Similarly, add two more substitutions: in the "Number" field of the "Issued" table, in the "Number" field of the "Invoice" table; in the "Product" field of the "Approved" table from the "Product" field in the "Product" table.

18) Save change.

Part II. The creation of forms is the filling of bazi danih.

Hid roboti

1) Go to the table "Otrimuvachi" and select the command: CreationKilka elements.

2) New form for entering and editing data to show up in Design mode. Close and save її under the name "Otrimuvachi".

3) Open a new form in the form mode.

4) Enter the information about the medications.

5) Also create a form for the "Products" table.

6) Now let's create the "Invoice" form, like a folding structure. Koristuvach mother sound on the right behind paper documents, not tables. The rozrobnik is to blame for this by looking at the screen near the hour of entering information to the paper document. For tsgogo є form, yakі zruchnіshe sdvoryuvat Maystrom, and edited by the Constructor.

7) Select the command: Creation Іnshі formsMaster of forms.

8) Select the tables and fields in the order in which the stench appears on paper invoices:

9) Indicate the necessary table (or request) and the change of the required watering, give an opinion on the nutrition of Maystra.

Number, date, IPN from the table invoice

Oberzhuvach, addresses from the table Oberzhuvach

Goods, quantity from tables Released

Od. vimiryuvannya, price from the table Product

10) After pressing the "Dal" button, select the type of presentation "Invoice" and submit the form.

11) Show the old look of the right form - tabular.

12) Style - Standard.

13) For the help of the designer, bring the form to the required look.

Part III. Data processing. The creation of zapitіv and zvіtіv.

Hid roboti

1) Select the command: Creation  Request Constructor.

2) Add all necessary tables and requests to the data request scheme. Install links between them. At the request form (lower part of the window) to drag the mouse to the fields from the table. Form dodatkovі um. Save your request. To look at the result of the request, check it out. As a result of the request, those records will be displayed on the screen, as if they confirm the mind set.

3) Call for a vibrator.

Request 1. Select the goods, which are measured in pieces.

Request 2. List of waybills, written off at 2009 roci.

Request 3. List of Moscow firms that bought sour cream. The request is made up of three tables: Obtained, Released, Invoices.

Request 4. List of goods that have been added to the invoice with the number to be entered from the keyboard.

4) Write down the fields that are counted. To create a new field, the value of which is calculated behind the formula, it is necessary to start the form at the starter of the form by prompting the wizard, the context menu, or entering the formula from the keyboard.

5) Create pіdbag zapochi, yakі serve to calculate the maximum and minimum values ​​of the field from the selected records, the sum of the fields from the selected records, the number of selected records total. For the creation of bag requests, the Group Operations button on the toolbar is used.

Request 6. Number of Moscow firms

Request7. List of consignment notes from sub-bag sums for the consignment note. The request is stored in three tables: Goods, Released, Invoices.

Part IV. Viewing information, making calls.

Hid roboti

1) The creation of the stars is more likely to be carried out for the assistance of Maystra, and then, for the need, edit the sound by the Constructor. The data for the call are requested in the Dialog of Maystra and can be removed as a table, so you can ask. Data from the stars can be grouped, sorted, and also can be picked up by bags outside the border fields.

2) Create a call to avenge the list of invoices from pіdbag sums.

3) Navigate to Request 7 and start Call Meister.

4) For help Maystra select all the fields Request 7 and set all the necessary parameters.

5) Correct the creations from the Constructor by changing the heading to "List of waybills".

6) Create such names: list of goods, list of purchasers, data about invoices number 1.