×èòàéòå òàêæå:
|
|
Äëÿ ñâÿçè ñîçäàâàåìîé êíîïêè ñ íóæíûì îáúåêòîì íóæíî âûáðàòü â ñòðîêå Êîìàíäà îäíó èç êîìàíä:
¨ Îòêðûòèå ôîðìû â ðåæèìå äîáàâëåíèÿ.
¨ Îòêðûòèå ôîðìû â ðåæèìå ðåäàêòèðîâàíèÿ.
¨ Îòêðûòèå îò÷åòà.
¨ Çàïóñê ìàêðîñà.
¨ Çàïóñê ïðîãðàììû.
 îêíå Èçìåíåíèå ýëåìåíòà êíîïî÷íîé ôîðìû òðåòüÿ ñòðîêà áóäåò ñîäåðæàòü íàèìåíîâàíèå, ñîîòâåòñòâóþùåå âûáðàííîé âî âòîðîé ñòðîêå êîìàíäå. Íàïðèìåð: åñëè âûáðàòü â ñòðîêå Êîìàíäà – Îòêðûòèå îò÷åòà, ïîÿâèòñÿ òðåòüÿ ñòðîêà ñ íàèìåíîâàíèåì Îò÷åò, ãäå ìîæíî âûáðàòü èìÿ îòêðûâàåìîãî îò÷åòà.
Ñîäåðæàíèå:
1. Îáúåêòû ACCESS....................................................................................... 4
1.1. ÒÀÁËÈÖÛ................................................................................................. 4
1.1.1. Ñîçäàíèå òàáëèö.......................................................................... 4
1.1.2. Îñîáåííîñòè òàáëèö ÁÄ............................................................. 6
1.1.3. Ïðèåìû ðàáîòû ñ òàáëèöàìè................................................... 6
1.1.4. Ñîçäàíèå ñâÿçåé ìåæäó òàáëèöàìè....................................... 6
1.2. ÔÎÐÌÛ..................................................................................................... 8
1.2.1. Òåõíîëîãèÿ çàãðóçêè ÁÄ ñ èñïîëüçîâàíèåì ôîðì............... 8
1.2.2. Ñòðóêòóðà ôîðì.......................................................................... 9
1.2.3. Ðàçðàáîòêà îäíîòàáëè÷íûõ ôîðì........................................ 10
1.2.3.1. Àâòîôîðìû............................................................................. 10
1.2.3.2. ÌÀÑÒÅÐ ÔÎÐÌ äëÿ îäíîòàáëè÷íûõ ôîðì.................. 11
1.2.4. Ðàçðàáîòêà ìíîãîòàáëè÷íûõ ôîðì...................................... 11
1.2.4.1. Ñïîñîáû ïîñòðîåíèÿ ìíîãîòàáëè÷íûõ ôîðì.............. 11
1.2.4.2. Ìàñòåð ôîðì äëÿ ñîçäàíèÿ ôîðìû äëÿ äâóõ ñâÿçàííûõ òàáëèö. 12
1.2.4.3. Ìíîãîòàáëè÷íàÿ ôîðìà ñ âêëþ÷åíèåì ïîä÷èíåííîé ôîðìû. 13
1.2.4.4. Ìíîãîòàáëè÷íàÿ ôîðìà áåç ïîä÷èíåííûõ ôîðì....... 14
1.2.5. Âíåñåíèå èçìåíåíèé â ðåæèìå Êîíñòðóêòîð..................... 14
1.2.5.1. Ñîçäàíèå è ðåäàêòèðîâàíèå ñâÿçàííûõ ïîëåé............ 14
1.2.5.2. Ñîçäàíèå ïîëåé ñî ñïèñêîì............................................... 15
1.2.5.2.1...... Ñîçäàíèå ïîëÿ ñî ñïèñêîì ñ ïîìîùüþ Ìàñòåðà:...... 15
1.2.5.2.2...... Ñîçäàíèå ïîëÿ ñî ñïèñêîì áåç ïîìîùè Ìàñòåðà....... 16
1.2.5.3. Âû÷èñëåíèå èòîãîâûõ çíà÷åíèé â ïîä÷èíåííîé ôîðìå è îòîáðàæåíèå ðåçóëüòàòà â ãëàâíîé òàáëèöå. 16
1.2.5.4. Ñîçäàíèå êíîïîê................................................................... 17
1.2.5.5. Ïðî÷èå ýëåìåíòû óïðàâëåíèÿ ôîðì............................... 18
1.3. ÇÀÏÐÎÑÛ............................................................................................... 19
1.3.1. Çàïðîñû íà âûáîðêó................................................................. 19
1.3.2. Ïàðàìåòðû çàïðîñà.................................................................. 20
1.3.3. Âû÷èñëåíèÿ â çàïðîñàõ........................................................... 21
1.3.4. Çàïðîñ íà îáíîâëåíèå.............................................................. 21
1.3.5. Çàïðîñ íà äîáàâëåíèå.............................................................. 22
1.3.6. Çàïðîñ íà óäàëåíèå................................................................. 22
1.3.7. Èòîãîâûå çàïðîñû.................................................................... 24
1.3.8. Ìàñòåð ñîçäàíèÿ çàïðîñîâ..................................................... 24
1.4. Îáðàáîòêà äàííûõ â ðåæèìå òàáëèöû è ôîðìû......................... 25
1.4.1. Ïîèñê çàïèñåé ïî çàäàííîìó çíà÷åíèþ ïîëÿ òàáëèöû. 25
1.4.2. Ñîðòèðîâêà çàïèñåé.................................................................. 25
1.4.3. Îòáîð äàííûõ ñ ïîìîùüþ ôèëüòðà...................................... 26
1.4.4. Êîððåêòèðîâêà äàííûõ............................................................ 27
1.5. ÎÒ×ÅÒÛ.................................................................................................. 27
1.5.1. Ñòðóêòóðà îò÷åòà...................................................................... 28
1.5.2. Ãðóïïèðîâêà äàííûõ îò÷åòà.................................................. 28
1.5.3. Ðàçìåùåíèå ïîëåé èç òàáëèöû............................................... 28
1.5.4. Âêëþ÷åíèå âû÷èñëÿåìûõ ïîëåé â îò÷åò............................. 28
1.5.5. Äîáàâëåíèÿ òåêóùåé äàòû è íîìåðà ñòðàíèöû................ 29
1.5.6. Îôîðìëåíèå âåðõíåãî êîëîíòèòóëà................................... 29
1.5.7. Ïðîñìîòð è ïå÷àòü îò÷åòà...................................................... 30
1.5.8. Ìíîãîòàáëè÷íûå îò÷åòû........................................................ 30
1.5.8.1. Ìíîãîòàáëè÷íûé îò÷åò ñ îñíîâíîé ÷àñòüþ íà áàçå ãëàâíîé òàáëèöû. 30
1.5.8.2. Ìíîãîòàáëè÷íûé îò÷åò íà îñíîâå ïîä÷èíåííîé òàáëèöû ñ ïîìîùüþ ìàñòåðà. 31
1.6. Ìàêðîñû.................................................................................................. 32
1.6.1. Ôîðìèðîâàíèå ìàêðîêîìàíä â îêíå ìàêðîñà.................... 32
2. Ðàçðàáîòêà ïàíåëè óïðàâëåíèÿ......................................................... 35
2.1. Ñîçäàíèå êíîïî÷íîé ôîðìû ñ ïîìîùüþ äèñïåò÷åðà................. 35
2.1.1. Ñîçäàíèå ãëàâíîé êíîïî÷íîé ôîðìû ñ ïîìîùüþ äèñïåò÷åðà. 35
2.1.2. Ñîçäàíèå êíîïî÷íûõ ôîðì ïðèëîæåíèÿ............................. 35
2.1.3. Ôîðìèðîâàíèå ýëåìåíòîâ êíîïî÷íîé ôîðìû.................... 36
2.1.3.1. Ôîðìèðîâàíèå ýëåìåíòîâ äëÿ âûçîâà êíîïî÷íûõ ôîðì. 36
2.1.3.2. Ôîðìèðîâàíèå ýëåìåíòîâ äëÿ îòêðûòèÿ îáúåêòîâ ïðèëîæåíèÿ. 37
Ñïèñîê ëèòåðàòóðû:.......................................................................................... 37
̲ͲÑÒÅÐÑÒÂÎ ÎÕÎÐÎÍÈ ÇÄÎÐÎÂ’ß ÓÊÐÀ¯ÍÈ
Äàòà äîáàâëåíèÿ: 2014-12-20; ïðîñìîòðîâ: 28 | Ïîìîæåì íàïèñàòü âàøó ðàáîòó | Íàðóøåíèå àâòîðñêèõ ïðàâ |