Cuprins laborator:
1. Argument7
2.Prezentarea Tabelelor8
2.1. Am creat tabela "Clienti"8
2.1.1.Modul Design View8
2.1.2.Modul Datasheet View8
2.2. Am creat tabela "Verificare Client"9
2.2.1. Modul Design View9
2.2.2. Modul Datasheet View9
2.3. Am creat tabela "Solicitare Credit"10
2.3.1. Modul Design View10
2.3.2. Modul Datasheet View10
2.4. Am creat tabela "Cont Curent" :11
2.4.1. Modul Design View11
2.4.2. Modul Datasheet View11
2.5. Am creat tabela "Imprumut Credit" :12
2.5.1. Modul Design View12
2.5.2. Modul Datasheet View12
2.6. Am creat tabela "Restituire Credit" :13
2.6.1. Modul Design View13
2.6.2. Modul Datasheet View13
3. Prezentarea legaturilor dintre tabele14
4. Prezentarea formularelor tabelelor15
4.1. Formularul "Clienti"15
4.1.1. Modul Design View15
4.1.2. Modul Layout View15
4.2. Formularul "Solicitare Credit"16
4.2.1. Modul Design View16
4.2.2. Modul Layout View16
4.3. Formularul "Restituire Credit"17
4.3.1. Modul Design View17
4.3.2. Modul Layout View17
4.4. Formularul "Cont Curent"18
4.4.1. Modul Design View18
4.4.2. Modul Layout View18
4.5. Formularul "Imprumut Credit"19
4.5.1. Modul Design View19
4.5.2. Modul Layout View19
4.6. Formularul "Verificare Credit"20
4.6.1. Modul Design View20
4.6.2. Modul Layout View20
5. Prezentarea interogarilor21
5.1. Interogare Calculare Dobanda 20%.21
5.1.1. Modul Design View21
5.1.2. Modul SQL View21
5.1.3. Modul Datasheet View21
5.2. Afisare nume client, CNP si suma aprobata descrescatoare.22
5.2.1. Modul Design View22
5.2.2. Modul SQL View22
5.2.3. Modul Datasheet View22
5.3. Sa se proiecteze Interogarea Credit acordat unei persoane.23
5.3.1. Modul Design View23
5.3.2. Modul SQL View23
5.3.3. Modul Datasheet View23
5.4. Sa se afiseze ratele lunare ale clientilor.24
5.4.1. Modul Design View24
5.4.2. Modul SQL View24
5.4.3. Modul Datasheet View24
5.5. Sa se afiseze suma aprobata redusa cu 10%25
5.5.1. Modul Design View25
5.5.2. Modul SQL View25
5.5.3. Modul Datasheet View25
5.6. Afisare valoari credite majorate cu 15%.26
5.6.1. Modul Design View26
5.6.2. Modul SQL View26
5.6.3. Modul Datasheet View26
5.7. Afisare cel mai mic/mare comision in functie de IBAN 27
5.7.1. Modul Design View27
5.7.2. Modul SQL View27
5.7.3. Modul Datasheet View27
5.8. Sa se determine numele clientilor din targoviste.28
5.8.1. Modul Design View28
5.8.2. Modul SQL View28
5.8.3. Modul Datasheet View28
5.9. Numele clientilor care detin functia de Avocat.29
5.9.1. Modul Design View29
5.9.2. Modul SQL View29
5.9.3. Modul Datasheet View29
5.10. Sa se determine data maxima activare/dezactivare cont_curent.30
5.10.1. Modul Design View30
5.10.2. Modul SQL View30
5.10.3. Modul Datasheet View30
5.11. Sa se determine suma perioadelor de credit in functie de banci 31
5.11.1. Modul Design View31
5.11.2 Modul SQL View31
5.11.3. Modul Datasheet View31
5.12. Sa se determine nume persoana casatorita care a luat credit Prima Casa.32
5.12.1. Modul Design View32
5.12.2. Modul SQL View32
5.12.3. Modul Datasheet View32
5.13. Sa se determine CNP-ul fiecarui Client.33
5.13.1. Modul Design View33
5.13.2. Modul SQL View33
5.13.3. Modul Datasheet View33
5.14. Sa se determine Creditele Acordate.34
5.14.1. Modul Design View34
5.14.2. Modul SQL View34
5.14.3. Modul Datasheet View34
5.15. Interogare suma ramasa de restituit din credit.35
5.15.1. Modul Design View35
5.15.2. Modul SQL View35
5.15.3. Modul Datasheet View35
6.Prezentare rapoarte: Interogari36
6.1. Raport Interogare Calculare Dobanda 20%.36
6.1.1. Modul Design View36
6.1.2. Modul Layout View36
6.2. Raport afisare client, CNP si suma aprobata descrescatoare.37
6.2.1. Modul Design View37
6.2.2. Modul Layout View37
6.3.1. Modul Design View38
6.3.2. Modul Layout View38
6.4. Raport Rate lunare Clienti.39
6.4.1. Modul Design View39
6.4.2. Modul Layout View39
6.5. Raport Suma aprobata redusa cu 10%.40
6.5.1. Modul Design View40
6.5.2. Modul Layout View40
6.6. Raport Valoare credite majorate cu 15%.41
6.6.1. Modul Design View41
6.6.2. Modul Layout View41
6.7. Raport Cel mai mic/mare comision in functie de IBAN.42
6.7.1. Modul Design View42
6.7.2. Modul Layout View42
6.8. Raport determinare nume clienti din Targoviste.43
6.8.1. Modul Design View43
6.8.2. Modul Layout View43
6.9. Raport Numele clientilor care detin functia de Avocat.44
6.9.1. Modul Design View44
6.9.2. Modul Layout View44
6.10. Raport Data maxima activare/dezactivare cont_curent.45
6.10.1. Modul Design View45
6.10.2. Modul Layout View45
6.11. )Raport Suma perioadelor de credit in functie de Banci.46
6.11.1. Modul Design View46
6.11.2. Modul Layout View46
6.12. Raport persoana casatorita care a luat credit "Prima Casa".47
6.12.1. Modul Design View47
6.12.2. Modul Layout View47
6.13. Raport CNP-ul fiecarui Client.48
6.13.1. Modul Design View48
6.13.2. Modul Layout View48
6.14. Raport Creditele Acordate.49
6.14.1. Modul Design View49
6.14.2. Modul Layout View49
6.15. Raport Interogare suma ramasa de restituit din credit.50
6.15.1. Modul Design View50
6.15.2. Modul Layout View50
