Description of the presentation with adjacent slides:

1 slide

Slide description:

Database management system Microsoft ACCESS Viconal: Pavlova O.O. Gr. 331-LD Perevirila: G.A. Tunakova Presentation

2 slide

Slide description:

Access DBMS Objects Tables are the main objects of the database. The tables contain: all data, in the base, the structure of the base (fields, їх types and characteristics). Ob'єkt (tab) tables

3 slide

Slide description:

Ob'єkti Access DBMS Power supply - tsi ob'єkti, which serve for the use of data from the table and for the benefit of the handy watchers. For additional power supply, one can check such operations as given for a given criterion, їkh sorting and filtering. For additional power supply, it is possible to check the revision of the data for the given algorithm, open new tables, automatically display the data tables, imported from the dzherel, show the simplest calculations in the tables and the bugs. Ob'єkt (bookmark) to power up

4 slide

Slide description:

Ob'єkti Access DBMS Forms - tsesti on the introduction of danih chi to a look danih. Nadayut koristuvachevі koshti for keeping the quiet waters, as it is necessary to lay it down. One hour at a time from the form, it is possible to expand the special elements of management (clerks, lists, remixes, warrants and іnshi), which can be opened, for the automation of the introduction. Form tab

5 slide

Slide description:

Ob'kti of the Access DBMS. Sign up for transferring data to a printer (for example, a printer). They have special calls for the group of donations, how to get involved, and for the delivery of special elements of registration, typical for hand-made documents (top and bottom footers, page numbers, service information about the current time). Macros automate the display of a specific database operation without a program. Modules are provided with programs in Visual Basic, which can be used for customization, registration and expansion of the database. Access links are designated for peer-to-peer and robots through the Internet from data that can be obtained from MS Access or MS SQL Server databases.

6 slide

Slide description:

Tipi danih Microsoft Access Text type danih, which vikorystovutsya for zberіgannya unformatted unformatted text bounded by size (up to 255 characters). The Memo field is a special type of tribute for the collection of great obsyagiv text (up to 65535 symbols). Physically, the text should not be taken from the field. Win a sign in the first place of the base, and in the field, there is a sign on a new one, but for a koristuvach such a decision is not expected. Numeric - a type of tribute for the collection of valid numbers. Date / hour - the type of tribute for the collection of calendar dates and the flow hour.

7 slide

Slide description:

Tipi danih Microsoft Access Penny - a type of tribute zberigannya penny sums. Theoretically, for їх it is possible to write down with fields of a numerical type, or for penny sums є actions of particularity (for example, tied to rounding rules), such as using the rules of rounding-off, such as playing with the help of a special type of donation, and not setting it up. Trap is a special type of tribute for unique (not repeated in the field) natural numbers with automatic extensions. Prirodne vikorystannya - for ordinal numbering of records. Logic - a type of logical tribute (you can take two meanings, for example, So chi Ni).

8 slide

Slide description:

Microsoft Access data type The OLE object field is a special type of data, designations for the acquisition of objects, for example, multimedia, which can be inserted into the data or the links (OLE). Really, obviously, such objects are not taken from tables. For every MEMO field, the stink is stored in the internal structure of the database file, and in the tables there are no more indicators on them (the robot's display with the bullet tables is superbly common). Hyperposilannya is a special field for obtaining the URL of the Web-object to the Internet. When there is an onslaught on the power, the browser will be launched automatically and the object will be displayed at your window. Master of food installations is a special type of tribute. Tse ob'єkt, nalashtuvannya which you can automate the input in the given field, so I will not enter it, but select it from the list, so it will open.

9 slide

Slide description:

Most importantly, the set of the base of the database Microsoft Access DBMS The Microsoft Access DBMS has found a number of the set of the main objects: manual - the opening of the objects in the Designer mode; avtomatizovanі - distribution of programs for additional help; automatic - get the quickest development of the simplest objects.

10 slide

Slide description:

Set up the base data base data of Microsoft Access DBMS Recommendations for storing the set up of the objects: Before the hour of the creation of the main tables and power supply, it is recommended to choose the manual settings for the Designer mode. Vikoristannya maystrіv will greet the robot, but I can’t master the methods. With the development of basic forms, the sound of that access is clearer by automated means, which is nadayut maysters. The design of the cich is ob'ktіv є hardworking, which is more beautiful than entrusting the program, and the students are more likely to change to the changing part of the robot.

11 slide

Slide description:

12 slide

Slide description:

The structure of the database table At the base of the data, the vibrati object Tables Vibrate the item The setting of the table in the designer mode At the designer's screen, specify the fields that type of the data.

13 slide

Slide description:

14 slide

Slide description:

Establishing links between tables Service Menu - Scheme of data Dodati tables, which take part in links and close in a window Dodati Display field of tables Student on the previous field of tables of the Book.

15 slide

1 from 9

Presentation on the topic:

No. to slide 1

Slide description:

No. slide 2

Slide description:

No. slide 3

Slide description:

As a rule, the database is shown as follows okremich program... The publication of given data from programs allows for the development of the given data for their own purposes. The ideological value of the database will be explained by the fact that in the basic concept of the information model of the data, that is, the abstract nature of the given data. The information in the database is organized in a simple way. You can see three basic structures for giving tribute to the database: to the merge relays (tabular).

Slide No. 4

Slide description:

The structure of the presentation of the tribute in the database of the "Relational Database" The structure of all records in the files is the same, and the number of records in the file is different. The elements of the Danih, at that number have a skin record, they are called fields. One record is to take revenge on information about one object of this real system, a model of such representations in the table. Entry 1 Entry 2

No. slide 5

Slide description:

Fields - central characteristics (attributes) of the object. The value of the fields is applied to one object. Oscillations in all records є the same field (with different values), the fields are manually given a unique name. Records are rendered to the values ​​of the keys. The main key for the database is the name of the field (the number of fields), the meaning of which is repeated in the new records. Most often, I will write down the number in order. One more important power is tied to the skin field - the type of field. Value type new records... According to the type of size, it is possible to find a place where it is possible to work with it. In relational databases, there are chotiri basic types of fields: numeric (tsil and speech), symbolic, date, logical.

No. slide 6

Slide description:

Appendix 1. Describe the structure of the database "Television program for a type". The table for the "Channel" field has a numerical type, and for the "Hour" field - speech type.

No. slide 7

Slide description:

By itself, the database cannot serve to feed the koristuvach for a joke and processing of information. The data base is only a "warehouse", in which case information is obtained. The role of the "salesperson" in the whole warehouse software systems, As they are called database management systems (DBMS). All DBMSs can be used in these types of basic operations: add one or more records to the base; vidality from base danikh one or a few records; to know in the base of the given one or the number of records, which will satisfy the given mind; onoviti at the base of the given meaning of the deyakie fields.

No. slide 8

Slide description:

The majority of the DBMS is capable of handling, in addition, the mechanism of links between small files, which can be entered before the base. For example, the call can be established by an explicit rank, if the values ​​of the fields are sent to the file, such a DBMS is called a footer, or the calls can be established by an implicit rank, for example, the meaning of the fields in new files... Such DBMS are called relational. The relational base will fall back on a message, an analysis, a response, and a bit of a stench will be collected in one moment. MS Access is functionally based on a relational-type DBMS, in a way that is reasonably balanced for all the possibilities, types for other DBMSs.

No. slide 9

Slide description:

Food for self-control Yaku structure zberigannya danih vikoristoyut at the database? Who has the special feature of a relational database? Who has the performance of the information table? How to describe the structure of the data in the relational database? So also write down, write down the field? Yaku information stink to revenge? Here are the following: - the name of the field, the value of the field, the type of the field. Yaki tipi poliv? What a DBMS? Yake is a sign of the mind software security? Do you call DBMS relational? What are the main functions of the DBMS? What type of database should Access be?

Steinbach Svitlana Evgenivna

Purpose:

• Learn more about the current Access 2010 DBMS, learn the Access interface and the basic views about Access 2010 forms.

Zavdannya:

• Vivchiti priznachennya Access 2010 typi ob'єktіv DB.
• Explore the ways of establishing the new database
• To master the reception of independent forms, such as speed up koristuvachi bazi danih
• You can see how to make corrections in the for and redaguvati їх change in the Constructor mode and in the Meister mode.

The robot allows you to learn about the main types of the MS Access DBMS, and navigate the reports to one of the DB objects - the form.

DBMS Access 2010 - the cost of the given and the objects, which are related to the singular task and represent the complete system.

Access pratsyє with such types of objects:

Tables to take revenge on the data, how to render the rows of the same format. In Access terminology, the rows are called records, and the columns are called fields. To that, all hundreds of tables may be used for the names of fields (the first row of tables). Rows revenge data in quiet formats, which are indicative of a rozrobnik. To that, it is common for a relational basis of danikh (tabular) to say that it is represented as a set of records of the same type. The base of the dwellers will be stored in a number of tables, shared by the viewers, about the calls. The information links from the same table are available to the public, so that the integrity of the data is not guaranteed.

Formy - the price of the option presented on the computer screen of one record, so that you can re-look after the view from the tables, please give a message quick access I will write it down beforehand, and also let me know how to correct the operations of the records and create new records (update the table). In fact, the form can be seen, like the interface of a corystuvach for hours of robots with tables.

To drink - є not so іnshe, as a tool for managing data. For additional power supply, you can use the data from one or several linked tables, use logical and arithmetic operations on data, group data to new tables for singing signs.

Sviti - I would like to ask you for the preparation of the output files. Slid to mean, that the word sounds mintly associated with the word "druk", the protector of the generation of calls in Access allows you to formulate a dyesy product in a virtual form. Whether the current form can be displayed on the porch or on the computer screen of the hand-given tribute from the visitor's format, the presentation of the messages, the filter and the graphic recast for the day.

Macro - the price of the simplest programs, which allow when the feeds, forms, sounds, vikonuvati singing diy are used. In Access, the macro does not open with the help of the macro recorder, but is designated as a retail one. That is, in order to exit the macro, it is necessary to return to the constructor mode, in which there is a possibility to select the arguments in the macro.

Module - to revenge one or more procedures written by my Visual Basic for Application. For the additional modules, a wide class of buildings can be viewed from a joke and a revision of information in the database.

Formy - tse option presented on the computer screen of one record.

• Forms allow the image of the data, which can be displayed in tables or feeds, which is more handy for taking pictures.
• For the help of forms, you can add to the tables of new data, redaguvati chi vyavnі
• Form the revenge of the little girl, graphics, photos, etc.

The base of the data was developed by the one, with the help of the representatives of the young children of the organization. Їх tsіkavit handheld interface, which permits the peer review of the data, the actualization, knows the singing fragments behind the addition of typical power supplies or intellectual functions.

• In Access 2010, the form is a self-contained object, so that it is kept in the middle of the base. Pid hour of development of the base danykh slid fast have a good way form, which will be displayed on the "Svorennya" tab of the Access panel.

• Regularly from the staging of the plant rozrobnik select the option of the gateway to the interface for the robot with the base data. By ourselves in a quick way Forms є:

• vikorystannya maister forms
• self-control of the form behind the help of the Designer
• self-styled form yak Empty form.

• On the “Stvorennya” deposit on the panel, the bases are clicked with the mouse button on the pictogram.
• In the window, transfer those fields to the right, as the form will be required.
• On the offensive early, vibrate the form of the presentation of the tribute
• Enter the form
• Launch the form on the website. On the form, only one record is displayed, at the bottom there is a window of the navigator, in which a number of records are indicated and a number I will write down to look at one another.

I do not hand the victorious Maystr of the forms of the field in the fact that all the fields, such as boules, were set up for vivedenny, decorated without the participation of the developer. Also, you will be able to enter the correction mode to bring the most recent viglyad form before the kind that you are happy with. Crazy, the performance of the victorian Maystra is a polyagaє at the shvidkosty of the stem of the form.

• To start the form, behind the help of the Designer, click on the [Add field] pictogram on the panel, then a list of fields appears.
• The transfer of the necessary names of fields to the form will be transferred to the flooded fields with the left button on the list of fields at the window "List of fields", with the towed to the form.
• Rosemiri, the style of presenting information, the color of the din, the position of that power can be changed, the victorious label "Format", or rather the powers that be.
• Beast of respect, as in the form, as a vicarist to look at the tributes, at the bottom there is a panel with tools, which allows you to make the recording of the form, and also in the window "Poshuk" to enter the sound of the attribution, you need to write down the necessary knowledge.

The form has been created in the mode. The constructor allows you to add additional data to the table with data only in the same way, as in the presence of the field, controlled in the table.

• Razroblyat form for adding to the table or write down or make changes to the date, manually on the basis of empty form. The design of how to obey the click of the mouse button on the pictogram on the Stvorennya contribution.
• Create an empty form, from the "List of fields" window, transfer all the required fields of the tables.
• Change the design of the folded form, the price of the Viconati is possible in different ways, for example, open the "Head" tab and quickly select the "Formatting text" panel, having seen the field. The first way of formatting is by using the Designer mode, for which you can switch to the mode by pressing on the icon, which is at the bottom of the form (right-hander). You can speed up in the third way, to switch to the mode of the layout (pictogram), and to display the powers, in which the parameters of the form and the elements are changed.
• Save the shape by asking the їy іm'ya

• Microsoft Access 2010- Tse simplicity. Access 2010 to allow you to maximally efficiently process data - it is not necessary for you to be a specialist from data bases. We will add new managers to the databases and give the program, I will paint in conjunction with the data, we will simplify the processes of this process, spіlnogo vicoristannya the beginning of the sounds.

Literature

• S.V. Odinochkin. Development of databases for Microsoft Access 2010 - St. Petersburg: NDU ITMO, 2012. - 83p.
• EAT. Karchevsky, І.Є. Філіпов, Access 2010 at the butts, the head master.
• http://pavlov-rags.narod.ru/Accsess2010/HTML_doc/

• Size: 233 Kb
• Number of slides: 37

Description of the presentation Presentation Presentation Access with slides

2Basics of understanding The subject area is a part of the real world, which is used for the automation of control in the whole sphere. The object of a real light (day) is a price that is clear and simple, for which one is called and one way of seeing one object from one (school, store, bank, too).

3Basics of the understanding 1. Ob'єkt that, can be a set of objects - the class of objects. 2. For example - warehouse goods є set of different goods. 3. The class of objects is called sukupnist, which has the same set of powers. 4. Kozhen ob'єkt at a set is called an instance of an object.

4 The power of the ob'ktiv The power of the ob'kta is called a deyak value, which characterizes the country of the ob'ykta be-some hour. An example of an object can be described if it is sufficient to indicate the significance of this authority. Napryklad, usі specimens ob'єkta Goods are characterized by powers: article of goods, name of goods, price of goods.

5 Identifying the power of the entities The identification of the power of the entity is the power, for the values ​​of which one instance of the entity can be uniquely identified in the boundaries of the class of entities. For example, ob'єkt Spіvrobіtnik. Identifying authorities cannot respect the authorities: Prying, Іm'ya, Po-Batkovi through the manifestation of the namesake of the names, which can be lost, and in Batkov's way. You can add to the list of authorities: Date of People's Day, Nationality. You can vikoristovuvati identification of authority Passport number, Passport series or Employee number.

6 Understanding the attribute of the object (requisite) Kozhen object is characterized by a set of powers, which are called attributes of the object chi requisites. The attribute is the information about the image of the power of the deyako object, the process of the manifestation.

7 Relational model of Rosroblen's tribute by E. F. Codd in 1970 p. RMD - tse organization of donations double-sided arrays(Table), as may by the advancing powers: 1. leather element of the table - one element of the tribute; 2. all items in the table are of the same type, that is, all items are of the same type; 3. leather stovpets man unikalne im'ya; 4. the order of directing rows and hundreds of them can be quite satisfactory. Theoretically, many tables are called single numbers. Rows - records (tuples). Stoppts - by fields (attributes of stosunits).

8 Relational model Qia model Based on relational algebra, meaning such mathematical operations, such as information, communication, repetition, communication and in case of any relational basis, you can formulate a number of tables. Tables can be tied together for the ability of one-hour robotics using tables. The link between two tables is displayed through the same fields. The field, like the vicory one for linking the table, is called the key field anyway.

9 MS ACCESS DBMS MS Access can be used for database management systems of a relational type and one of the most popular desktop DBMSs. MS Access є a complex of applied programs, which are used for the execution of offensive operations: the opening of the data bases (DB); secure access to the tribute; Data processing MS Access has a great set of visual data (for the introduction, analysis and submission of data), and also allows you to choose the functionality of the programmed programming (VBA - Visual Basic for additional data).

10Ms Access DBMS Power supply - select required data from one number of tables. Form - to display data from the table or feeds from the form for koristuvach. Zvit is a form of a vyhidny document vivedennya to druk. Macro - a program, with the sequence of macros, is designed to automate specific operations for processing the base data. The module is a VBA program, which can be broken up to implement non-standard operations for the hour of opening the program.

12Tables 1. The skin object of the conceptual model of the subject area is shown by one table. 2. The skin field of the table reveals one characteristic (attribute) of the subject object. 3. In the note of a selection of views about one example of an object.

13Setting the table 1. Mode of the table (by way of introduction of the tribute). 2. Constructor of tables. 3. Meister table. 4.Import table. 5. Linking from tables - an automatic non-prioritized linking of the stream supplement with the data of the other supplements is set up. The table can be added to the add-ons and you can choose to add them to the add-ons.

14 Tipi Danih Table 1. Text is a type of tribute for a change. The number of symbols in the field is not to blame for 255 symbols. A glance over the view of those who have been deprived of the form. 3. Numeric - whole and tens of numbers. 4. Financial - numbers in a penny format. 5. Dispenser - the last day of the week. 6. Date / hour - date that hour.

15 Type of given table 7. Logic - dan, as there can be one of two possible values ​​(so / ni, truth / nonsense, 0/1, -1/0, on / cycle). 8. OLE-ob'єkt - the field to take revenge on the OLE ob'єkti. 9. HyperPossibility - the field to place the addresses and files in or the URL of the website.

16The power of the fields is set in the mode Constructor of tables on the tabs of the headings that lie in the vibrational type of data.

17Field power 1. Field size For text - from 0 to 255 For numeric - select from the list: byte (0-255); cyle (-32768 + 32767); dovge tsile (-2, 14 109 + 2, 14 109); single point with a floating point (-3, 4 · 10 38 + 3, 4 · 1038); sub-line with a floating point (-1, 797 10308 + 1, 797 10308).

18 Power fields 2. Field format. 3. The number of dozens of signs. 4. Introduced mask - to serve for the representation of post-symbolic symbols in the field and interchange of dozhini. The butt of the mask for displaying a 4-digit decimal number with a sign: # 9999 -854; 1854; -25 # 0000 (introduction of binding) LLL mask? ? ? you can vikoristovuvati for text box: street, booths, roofing (L - introduction of obovyazkovy;? - Introducing obovyazkovy). 5. A signature is another field identifier, which can be used in the form of a field. 6. The value for the promotion is the value that will be entered automatically when the opening hour is entered as the reset.

19 The power of the fields 7. The mind value is interchange, it is superimposed on the value of the field (256 OR 512). 8. Announcement about the pardon - the text of the notification is stored by the retailer and appears on the screen when the foremost power is destroyed. 9. Obov'yazkovo field - if it vibrates SO, then all the middle of this field Mayut buti zapovneni. 10. Empty rows - as soon as HI vibrates, the field is filled with tribute, as from some glades. 11. Indexed field - if it is vibrated SO, then an index (prime number) is set at the appearance to the skin value of the field. The table of indexes is selected for accelerating the list of given tables.

20Organization of links between tables Field keys can be of two types: primary key; the name of the key. The primary key is a field, a skin element that uniquely identifies the table entry. The name key is a field that can be entered in the table specially before the name of the table is entered. Student Number PIB Date of People's Group Session Number Assessment 1 Assessment 2 Assessment 3 Scholarship Result Scholarship Sum

21 Organization of links between tables Tables Student and Session are linked by primary keys, and tables of Session and Scholarship are linked by a particular key. When you enter the name of the table from the names of the name key, the following values ​​are displayed: the table with the primary key is called the head table; a table from a given key - an ordered table.

22 Types of calls 1. One to one. The primary key of the head table is linked with the primary key of the secondary table. 2. One to bagatooh. The primary key of the head table is linked from the primary key by the order table. 3. Bagato hto to bagatoh. The link is implemented through the link table and falls by two links One to the bagatooh. Heads Commodities Substituted1: M M: M

24See the Primary Keys The Primary Nag can be of two kinds. 1. Simple - scho to be stored in one field. 2. Warehouse - it is possible to store two or more fields. Warehouse key - a unique set of values ​​for the environment.

25Understanding the integrity of the gifts ringing sounds There are tables with the introduced and visible records and the collection of information about the knitted tributes. For example, tables Buyers and Replacements are linked to the Buyer Code field. Yakshcho Buyer with a code 4 zrobiv 3 substitutions, same tables Replacing there will be 3 records with such a buy code. These records will be linked to one record at the Purchase table. When you look at any of the three records at the tables, you will see some information about the deterioration of the integrity of the data.

27Understanding the integrity of the given Access can automatically cascade and cascade new linked fields, if you set up a cascade.

28Up to a vibrator - vikoristoyutsya for a vibor from the database of information, to tsikavit koristuvach. Vibirka is a dynamic table from the records of the gifts, which show the singing minds to power up. Vibirka is formed schorazu when starting up. You can follow the vibrating yak from the real table, that is, edit the record. Introduced changes will be automatically displayed in real tables.

29So the formulation of power supplies 1. QBE (Query By Example) is energized separately, to be energized, which is set behind the help of the power supply constructor. 2. SQL (Structured Query Language) - written with my own SQL. When the QBE Access is formulated, the form is automatically fed into the SQL form, so you can wonder at the additional command Viglyad - SQL Mode.

30 Power up Simple power up - start the power supply master on the vibrator. Perekhresny power supply - a table has been set up, Excel spreadsheet... Records, scho repeated - to display a group of records with the same values ​​of the indicated field. Records without pidleglikh - a pop of records at the head tables, for some not connected with them records at the order tables.

31Creation of power supply in the mode of the constructor 1. Open the window of the constructor. 2. Add the required tables. 3. Set the power supply settings.

32Parameters will be fed to vibrator 1. Sorting - select for sorting the vibrator by the specified field (sorting key). Keys can be decorated with decals. Sortuvannya after another key is shown, which є meaning, is repeated in the field of the first key.

33Parameters will be fed to vibrator 2. Fields, for those who know the forefathers at the row of Vivedennya on the screen, take their fate from the power, or do not appear from vibrating. 3. Umova vidboru - viraz, which vikoristovuyutsya as a criterion for the selection of records in the field, in a hundred viraz introduced. Pislya introduced virazu press ENTER key.

34Following the minds for the supplies 1. Vikoristannya masks Like. The symbol * replaces the number of symbols. For example: viraz Like “M *” - allow you to view all the values ​​of the flow field, to repair it on the M2 letter. Vikoristannya symbols For example:> 5; > = 10; > = “M *”. 3. Vidbir in the middle range value: victorian symbols in relation to the AND operator; vicorystannya key word BETWEEN is the AND operator. For example:> = “M *” AND<=“ Р* ” ; BETWEEN 5 AND 10.

35 Ways of wits in the feeds 4. Vikoristannya operator ABO (OR). For example: for the Date of sinking field * 08 OR * 09 (the symbol * replaces the symbols that show the day and the month), allow you to add a replacement for two rockets. For this, you can pick up a row of ABO spilly with a row of Umov.

36Following minds in vidboru zapity List of functions. 1. Ugrupovannya - to group the same values ​​of the given field. 2. SUM - to calculate the sum of the grouped value. 3. AVG - this is the middle group value. 4. MIN - the lowest value from the group. 5. MAX - the lowest value of the grouped values ​​starts. 6. COUNT - the number of grouped values ​​is calculated. 7. FIRST - First of all from grouped values.

37Difference of minds in the collection of supplies 8. LAST - the start is made from grouped values. 9. Umova - select from the list, as in the given field the mind is added to the list. 10. Viraz - to vibrate from the list, if a viraz has been added for the whole field, it will be counted.

• Viznachennya programs;
• Appointed that function;
• Ob'єkti;
• Tipi Danih;
• Program menu;
• ways of establishing objects;
• put on ob'єktіv.

Relational DBMSs were installed on the latest personal computers of the most advanced ACCESS.

supplement Microsoft Access- a cost-effective system for managing relational databases of data ( DBMS), designed for robots on an autonomous personal computer (PC) or local numeric framing for kervans of the family of Microsoft Windows operating systems).

Microsoft Access DBMS maє with the straining, with that dull tricks of the visual design for the help of the Maisters, allowing them to quickly complete the information system on the table, feeding, forms and sounds.

Bazi Danih Mayut Expansion  .mdb.

BASIC OBJECTS DB

Table – ob'єkt, signs for the collection of tributes from viglyadі records and polіv.

Form – ob'єkt, signs of lodging the introduction of danikh.

Power – ob'єkt allows you to correct the required data from one number of tables.

Sound – ob'єkt for druku danih.

BE-YAKA TABLE MAY BE PRESENTED IN TWO MODES:

In mode tables, Signs for the introduction of tribute, їkh look at that redaguvannya.

In mode constructor , indications for the root of the structure of tables, changes to the type of tribute, changes in the structure of tables (additional and visible fields).

ORGANIZATION OF ROBOTS WITH TABLES

Table- The main (basovy) object bazi danih. Reshta ob'єktіv are set from the urahuvannya іnuyuchih tables.

• Have tables all the data are taken from the base of the data; And also tables
• Have tables all the data are taken from the base of the data;
• And also tables save the structure of the base danih (fields, type and power)

Use these operating modes:

• In the regime of the master.
• In the regime of the architect.

In mode constructor. On the screen, there is a new power supply, for whom all the methods are provided with a new power supply. Tse:

• Constructor.
• Simple power supply.
• Overwhelming power supply.
• Repeat recordings.
• Records without pidleglich.

ORGANIZATION OF ROBOTS WITH DRINKS

Power- tse ob'єkt bazi danih, which allows you to carry out the main operations from the processing of danikh:

• sortuvannya,
• filtration,
• ob'єdnannya danih іznih dzherel,
• reinvention of tribute
• take results from the deyakim іm'yam, soob nadalі vikoristovuvati їkh in the world of consumers.

• Formє The best way to look at the introduction of the tribute.
• Form be set on the basis of already broken tables and may include not only one, but one set of knitted tables.

• Naybilsh quick way of opening form- For the help of the maister.

• Form Maybe the mother of the tabular viewer, or, more often than not, the vikoristovuyut stitchkovy - the skin ob'єkt I will okremu the card.

• Sound- Possibility of the development of different forms of submission of the general information.

• Computers sounds In that case, the stink allows you to group information for the given signs, to enter the fields along with the records of the groups on all bases.

• Soundє manual form submission of information for input to a friend.

ZAKHIST BAZI DANIKH

Access shortcut zahist system the middle of all desktop DBMS. The master permits the creation of groups, koristuvachіv, granting access rights to all objects, including the number of modules. An individual password can be given for a skin cure.

The system is available to the user both with the help of visual assists, and a programmatic way.

Microsoft Access- the price of the most popular current annual database management system. There are a lot of successes in the number of bindings from the included ones to the Microsoft Office family. Tsey software product of insurance for yak on pochatkivtsya, as well as on qualified koristuvach