|
ACCESS - vježbe
1. Kreirati izvještaj /CREATE REPORT/
Urediti kao tekst na slici:
R.br. |
Tekst |
Slika |
| 1 |
Kreirati tabelu ZAPOSLENI |
|
| 2 |
Unijeti podatke. |
| ID |
Company |
Last Name |
First Name |
E-mail Address |
Job Title |
Business Phone |
Home Phone |
Address |
City |
State/Province |
| 1 |
Northwind Traders |
Freehafer |
Nancy |
nancy@nwaddr.com |
Sales Representative |
(12)5-010 |
(12)5-026 |
123 1st Avenue |
Seattle |
WA |
| 2 |
Northwind Traders |
Cencini |
Andrew |
andrew@nwaddr.com |
Vice President, Sales |
(12)5-011 |
(12)5-027 |
123 2nd Avenue |
Bellevue |
NY |
| 3 |
Northwind Traders |
Kotas |
Jan |
jan@nwaddr.com |
Sales Representative |
(12)5-012 |
(12)5-028 |
123 3rd Avenue |
Redmond |
WA |
| 4 |
Northwind Traders |
Sergienko |
Mariya |
mariya@nwaddr.com |
Sales Representative |
(12)5-013 |
(12)5-029 |
123 4th Avenue |
Kirkland |
WA |
| 5 |
Northwind Traders |
Thorpe |
Steven |
steven@nwaddr.com |
Sales Manager |
(12)5-014 |
(12)5-030 |
123 5th Avenue |
Seattle |
WA |
| 6 |
Northwind Traders |
Neipper |
Michael |
michael@nwaddr.com |
Sales Representative |
(12)5-015 |
(12)5-031 |
123 6th Avenue |
Redmond |
NY |
| 7 |
Northwind Traders |
Zare |
Robert |
robert@nwaddr.com |
Sales Representative |
(12)5-016 |
(12)5-032 |
123 7th Avenue |
Seattle |
WA |
| 8 |
Northwind Traders |
Giussani |
Laura |
laura@nwaddr.com |
Sales Coordinator |
(12)5-017 |
(12)5-033 |
123 8th Avenue |
Redmond |
NY |
| 9 |
Northwind Traders |
Hellung-Larsen |
Anne |
anne@nwaddr.com |
Sales Representative |
(12)5-018 |
(12)5-034 |
123 9th Avenue |
Seattle |
WA |
|
| 3 |
Kreirati izvještaj /REPORT/ prema uzorku na slici.
Koristiti sva polja tabele. |
.jpg) |
Index
|

|