1

Nume PrenumeData nateriiFilialaDepartamentFunciaData angajriiSalariu ncadrarePOPESCU Viorel01 Jan 1982BucuretiMarketingmerceolog29 Dec 20053,177 leiMIHAI Carmen24 Apr 1984ClujResurse umanejurist08 Mar 20101,950 leiPOPA Florin30 May 1974BucuretiContabilitatecontabil13 Nov 19991,712 leiALBU Constanta19 Mar 1981ClujMarketingeconomist25 Feb 20103,225 leiNEDELCU Mihai23 Jan 1972BucuretiITanalist02 Feb 20053,000 leiCHIRU Bianca25 Nov 1969OradeaITanalist21 Jan 19983,820 leiALBITER Oana03 Mar 1985OradeaMarketingmerceolog06 Mar 20091,590 leiVLAD Petru18 Nov 1962BucuretiMarketingagent vnzri29 Oct 19932,133 leiCONSTANTIN Dan19 Jan 1972ClujMarketingeconomist16 Jul 20102,900 leiMONDREA Laura02 Nov 1982BucuretiContabilitatecontabil02 Feb 20061,989 leiSAVU Ctlin21 Nov 1967BucuretiIToperator19 Sep 20022,031 leiPANAIT Cornel13 Nov 1962BucuretiMarketingeconomist09 Dec 19933,500 leiCOMAN Aura23 May 1983BucuretiITprogramator09 Feb 20053,270 leiBLGESCU Ada24 Aug 1973OradeaContabilitateeconomist15 Jan 19951,355 leiMIHAI Dinu25 Nov 1962ClujResurse umanejurist02 Apr 20102,900 leiDEDU Natalia06 Jan 1984BucuretiContabilitateeconomist22 Sep 20101,558 leiGANEA Pavel17 Dec 1969BucuretiMarketingmerceolog16 Nov 19931,743 leiSORESCU Liana27 Feb 1964OradeaMarketingagent vnzri22 Mar 19952,000 leiPETRE Cristina09 Sep 1973ClujITprogramator05 Dec 19983,240 leiMANESCU Andreea30 Nov 1962BucuretiContabilitateeconomist12 Jan 20103,411 leiVISAN Alexandra01 Mar 1971OradeaIToperator28 Jan 20082,880 lei

S se realizeze urmtoarea validare a bazei de date: cmpul Nume Prenume va avea lungimea cuprins ntre 7 i 30 de caractere.

! se face asa: data-data validation-la settings alegeti acolo in loc de any value alegeti text length si puneti between 7 si 30

2

Numr facturTitlu carteNume ClientOra distribuieAgent vnzareCantitate vndutPre carteValoare vnzri383,746Visual Basic for ApplicationCompania de librriiBucuretiRadulescu S.40 buc38 lei1,520 lei383,746Tehnologii informaionale aplicate n economieCompania de librriiBucuretiRadulescu S.80 buc34 lei2,720 lei383,747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.800 buc38 lei30,400 lei383,748Baze de DateVox 2000BucuretiPopescu M.400 buc42 lei16,800 lei383,749Office 2007 - AplicaiiCompania de librriiBraovIonescu L.900 buc31 lei27,900 lei383,750Office 2007 - AplicaiiLibrria "Central"SibiuMoisescu A.850 buc31 lei26,350 lei383,751Baze de dateRolCrisBucuretiVasilescu D.900 buc42 lei37,800 lei383,752Tehnologii informaionale aplicate n economieRolCrisBucuretiVasilescu D.1000 buc34 lei34,000 lei383,752Office 2007 - AplicaiiRolCrisBucuretiVasilescu D.30 buc31 lei930 lei383,753Tehnologia aplicaiilor OfficeVox 2000SibiuMoisescu A.1400 buc40 lei56,000 lei383,754Tehnologia aplicaiilor OfficeCompania de librriiBucuretiRadulescu S.16 buc40 lei640 lei383,754Office 2007 - AplicaiiCompania de librriiBucuretiRadulescu S.600 buc31 lei18,600 lei383,755Tehnologia aplicaiilor OfficeCompania de librriiBraovIonescu L.650 buc40 lei26,000 lei383,756Programarea calculatoarelorRolCrisBucuretiPopescu M.1050 buc37 lei38,850 lei383,756Tehnologia aplicaiilor OfficeRolCrisBucuretiPopescu M.800 buc40 lei32,000 lei383,757Visual Basic for ApplicationLibrria "Central"SibiuMoisescu A.1300 buc38 lei49,400 lei383,758Visual Basic for ApplicationCompania de librriiBucuretiAlbu M.1000 buc38 lei38,000 lei383,759Programarea calculatoarelorVox 2000BucuretiIonescu L.750 buc37 lei27,750 lei383,759Tehnologii informaionale aplicate n economieVox 2000SibiuIonescu L.60 buc34 lei2,040 lei383,760Tehnologia aplicaiilor OfficeCompania de librriiBraovMoisescu A.125 buc40 lei5,000 lei383,761Tehnologii informaionale aplicate n economieLibrria "Central"SibiuMoisescu A.600 buc34 lei20,400 lei383,762Tehnologia aplicaiilor OfficeRolCrisSibiuMoisescu A.100 buc40 lei4,000 lei383,763Programarea calculatoarelorRolCrisSibiuMoisescu A.250 buc37 lei9,250 lei383,764Baze de DateRolCrisBucuretiIonescu L.90 buc42 lei3,780 lei383,764Sisteme informatice de asistare a decizieiRolCrisBucuretiIonescu L.100 buc29 lei2,900 lei383,765Visual Basic for ApplicationCompania de librriiBraovMoisescu A.100 buc38 lei3,800 lei383,766Tehnologia aplicaiilor OfficeCompania de librriiBucuretiPopescu M.360 buc40 lei14,400 lei383,767Baze de DateCompania de librriiBucuretiIonescu L.2000 buc42 lei84,000 lei383,768Tehnologia aplicaiilor OfficeLibrria "Central"SibiuAlbu M.20 buc40 lei800 lei383,768Sisteme informatice de asistare a decizieiLibrria "Central"SibiuAlbu M.30 buc29 lei870 lei383,769Baze de DateVox 2000BraovMoisescu A.40 buc42 lei1,680 lei383,769Office 2007 - AplicaiiVox 2000BraovMoisescu A.400 buc31 lei12,400 lei383,769Sisteme informatice de asistare a decizieiVox 2000BraovMoisescu A.200 buc29 lei5,800 lei383,770Tehnologia aplicaiilor OfficeRolCrisBucuretiMoisescu A.280 buc40 lei11,200 lei383,771Baze de DateCompania de librriiBraovMoisescu A.300 buc42 lei12,600 lei383,772Tehnologia aplicaiilor OfficeCompania de librriiBucuretiPopescu M.1200 buc40 lei48,000 lei383,773Baze de DateVox 2000SibiuRadulescu S.1450 buc42 lei60,900 lei383,774Tehnologia aplicaiilor OfficeLibrria "Central"BraovAlbu M.50 buc40 lei2,000 lei383,774Baze de DateLibrria "Central"BraovAlbu M.60 buc42 lei2,520 lei383,775Baze de DateRolCrisBraovRadulescu S.90 buc42 lei3,780 lei383,776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.900 buc31 lei27,900 lei383,776Office 2007 - AplicaiiVox 2000BraovVasilescu D.350 buc31 lei10,850 lei383,776Office 2007 - AplicaiiVox 2000BraovVasilescu D.250 buc31 lei7,750 lei383,777Baze de DateCompania de librriiBucuretiPopescu M.360 buc42 lei15,120 lei383,778Tehnologia aplicaiilor OfficeRolCrisBucuretiRadulescu S.750 buc40 lei30,000 lei383,778Tehnologia aplicaiilor OfficeRolCrisBraovRadulescu S.45 buc40 lei1,800 lei383,779Baze de DateLibraria "PlaCedo"BraovMoisescu A.75 buc42 lei3,150 lei383,780Tehnologii informaionale aplicate n economieVox 2000BraovMoisescu A.20 buc34 lei680 lei383,780Tehnologii informaionale aplicate n economieVox 2000BraovMoisescu A.10 buc34 lei340 lei383,780Programarea calculatoarelorVox 2000BraovMoisescu A.40 buc37 lei1,480 lei383,781Baze de DateVox 2000BucuretiPopescu M.500 buc42 lei21,000 lei383,782Sisteme informatice de asistare a decizieiLibraria "PlaCedo"BraovAlbu M.240 buc24 lei5,760 lei383,783Programarea calculatoarelorCompania de librriiBucuretiIonescu L.800 buc37 lei29,600 lei383,784Baze de DateLibrria "Central"BraovIonescu L.365 buc42 lei15,330 lei383,784Tehnologia aplicaiilor OfficeLibrria "Central"BraovIonescu L.125 buc40 lei5,000 lei383,785Programarea calculatoarelorRolCrisBucuretiAlbu M.180 buc37 lei6,660 lei383,786Baze de DateLibrria "Central"SibiuMoisescu A.320 buc42 lei13,440 lei

S se aplice funcia Database pentru urmtoarea cerin informaional: se calculeaz volumul total al vnzrilor pentru crile distribuite n oraele Braov i Sibiu prin societatea RolCris. Volumul totalOra distribuieNume Client485SibiuRolCrisBraovRolCris

3

Data examenFacultateSeriaGrupaNume PrenumeNr. biletNota Examen1/20/13FABBVA1501COSTEA LAURENIU 56.001/21/13FABBVA1503DIJMRESCU ALINA23.601/22/13FABBVA1503DINC GABRIELA69.001/23/13FABBVA1502DOBO LOREDANA127.801/24/13FABBVA1502DOBRE ALIN186.001/25/13FABBVA1502DOBRE LUIZA66.201/26/13FABBVA1502DOBRE PETRU EUGEN32.801/27/13FABBVA1502DOBRE SORINELA73.301/28/13FABBVA1502DOBRESCU RUXANDRA167.601/29/13FABBVA1502DOCHIA ANDREI178.001/30/13FABBVA1502DODE RZVAN15.001/31/13FABBVA1501DONICEANU OANA197.002/1/13FABBVA1503DRGHICI MIHAI2010.002/2/13FABBVA1503DRGUCIAN ALEXANDRU2510.001/21/13FABBVA1501DUCA LIDIA1410.002/4/13FABBVA1501DUMBRAV TEODOR174.002/15/13FABBVA1503DUMITRACHE ANCA69.001/21/13FABBVB1501DUMITRESCU ANCA ELENA910.001/21/13FABBVB1502DUMITRESCU DIANA252.601/21/13FABBVB1502DUMITRESCU OVIDIU2310.002/1/13FABBVB1503DUMITRU ANDREEA22.301/21/13FABBVB1507OLARU DIANA66.001/22/13FABBVB1507FILIP CRISTINA214.601/22/13FABBVB1507FLOREA MONICA199.702/11/13FABBVB1503FRNCU ADRIAN55.701/22/13FABBVB1507FUDULE MIHAI97.601/22/13FABBVB1509FUDULI MIRELA108.701/22/13FABBVB1509FUIOR FLAVIU85.301/23/13FABBVB1501FUSEA ALINA67.401/23/13FABBVB1501GANIA ANCA48.702/7/13FABBVB1501GAVRILESCU RAMONA37.001/23/13FABBVB1508GAVRILU RALUCA257.501/23/13FABBVB1503GEAFER CARMEN115.201/23/13CIGA602GEAMBAU LIVIU128.001/23/13CIGA602GEORGESCU CRISTINA156.201/23/13CIGA603GEORGESCU MAGDALENA176.002/10/13CIGA601GHEORGHE BOGDAN196.702/11/13CIGA601GHEORGHIU TEFANIA45.202/12/13CIGA601GIURCONIU MDLINA87.802/13/13CIGA601GSNEA NICOLETA74.601/24/13CIGA603STAN CRISTINA258.601/25/13CIGA603BRBULESCU ADINA156.701/25/13CIGA603GHERASIM COSTIN GABRIEL145.401/25/13CIGA603GODOCI LUCICA87.201/25/13CIGA603GRDINARIU MARIUS66.001/25/13CIGA602GRIGORESCU MDLINA39.501/25/13CIGA602GROSU CRISTIAN41.002/5/13CIGA601GROSU IULIA252.102/5/13CIGB607HANGIU OCTAVIAN227.201/25/13CIGB607HOSSZU ELENA LAURA246.301/26/13CIGB607HUZA DIANA192.001/26/13CIGB607IACOB RZVAN ADRIAN178.801/26/13CIGB607HARJA GABRIEL167.501/26/13CIGB607ILIE IOANA115.901/26/13CIGB607ILINCA GEORGIANA18.202/10/13CIGB609ILINCA RADU146.801/26/13CIGB609IVAN ALINA27.801/26/13CIGB609ION GABRIEL VALENTIN168.601/27/13CIGB609IONESCU ADRIAN45.101/28/13CIGB609IONI IOANA228.901/28/13CIGB608IONI NICUOARA148.001/28/13CIGB608IORGU IOANA173.601/28/13CIGB608PERJU DIANA185.801/28/13CIGB608PITIREANU ELENA199.102/2/13CIGB609ILIOIU RADU257.70

S se formateze condiional numele studenilor (cmpul E3:E67) de la facultatea FABBV, seria B care au susinut examenul n ziua de 21 Ianuarie 2013 i au obinut nota maxim.

Formula FALSE

4

Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare factur101Client1ConstanaStr. A456,853Thu 24 Nov 1120 zileThu 22 Dec 1112,520 lei105Client5AradStr. E456,854Mon 7 Feb 110.0Mon 7 Feb 1115,600 lei101Client1ConstanaStr. A456,856Sun 23 Jan 1120 zileFri 18 Feb 118,360 lei102Client2BucuretiStr. B456,858Wed 18 May 1110 zileWed 1 Jun 1113,000 lei106Client6TimioaraStr. F456,859Thu 25 Aug 1120 zileThu 22 Sep 1138,060 lei105Client5AradStr. E456,855Sat 22 Oct 1130 zileFri 2 Dec 1146,766 lei102Client2BucuretiStr. B456,861Sun 18 Sep 1115 zileFri 7 Oct 113,900 lei103Client3BraovStr. C456,852Sun 19 Feb 1215 zileFri 9 Mar 1214,005 lei107Client7BuzuStr. C456,857Mon 9 Jan 120.0Mon 9 Jan 1287,056 lei104Client4ClujStr. D456,860Mon 12 Mar 120.0Mon 12 Mar 1219,500 lei104Client4ClujStr. D456,862Tue 6 Mar 128 zileFri 16 Mar 1212,505 lei106Client6TimioaraStr. F456,864Sun 8 Jan 123 zileWed 11 Jan 128,706 lei105Client5AradStr. E456,865Fri 10 Feb 1217 zileTue 6 Mar 1245,000 lei103Client3BraovStr. C456,866Thu 5 Jan 125 zileThu 12 Jan 122,284 lei102Client2BucuretiStr. B456,867Sat 10 Mar 127 zileTue 20 Mar 123,600 lei106Client6TimioaraStr. F456,868Sat 4 Feb 120.0Sat 4 Feb 1218,732 lei105Client5AradStr. E456,869Mon 5 Mar 129 zileFri 16 Mar 1212,200 lei102Client2BucuretiStr. B456,870Sun 1 Apr 1214 zileThu 19 Apr 1214,780 lei107Client7BuzuStr. G456,871Sun 29 Apr 120.0Sun 29 Apr 1281,000 lei103Client3BraovStr. C456,863Thu 26 Apr 1230 zileThu 7 Jun 1256,100 lei

S se realizeze urmtoarea sintetizare a bazei de date prin tabela pivot: s se calculeze numrul de facturi i suma valoric a acestora, pe Nume Client, restricionnd interactiv tabela pe anul facturrii. Data facturii(All)Row LabelsCount of Numr facturSum of Valoare facturClient1220880Client2435280Client3372389Client4232005Client54119566Client6365498Client72168056Grand Total20513674