Access 2007: uputstvo koje vam nedostaje

Missing Manuals

by Matthew MacDonald

Access 2007 se poprilično razlikuje od prethodnih verzija, pre svega po novom i dopadljivom korisničkom interfejsu o kojem se mnogo govori - glavna traka je podeljena na kartice Home, Create, External Data i Database Tools, a tu je i novi meni Office.

Evo nekoliko najvažnijih izmena:
- nova i poboljšana mašina baze podataka
- tip podataka Attachment, što omogućava da se u bazi podataka čuvaju cele datoteke, uključujući slike, dokumente i tabele iz programa za tabelarne proračune
- automatski razmeštaj, mogućnost koja grupiše povezane podatke u pregledne kolone ili tabele
- kompleksni podaci, pomaže da se više vrednosti smesti u jedno polje
- integrisanje sa servisima SharePoint
- bolja zaštita pri upotrebi programskog koda

Objašnjene su sve Accessove funkcije, ponuđeni saveti koje su alatke korisne, a koje treba izbegavati kako biste za rekordno kratko vreme napravili sjajne baze podataka.
Iz ove knjige naučićete kako da projektujete cele baze podataka za određene namene, kako da ih održavate, kako da u njima nalazite dragocena zrnca informacija i kako da pravite dopadljive obrasce za brzo i lako unošenje podataka.

Sadržaj
Uvod
Poglavlje 1: Izrada prve baze podataka
Poglavlje 2: Izrada pametnijih tabela
Poglavlje 3: Rad s tabelarnim prikazom: sortiranje, pretraživanje, filtriranje i drugo
Poglavlje 4: Sprečavanje unosa neprihvatljivih podataka
Poglavlje 5: Povezivanje tabela
Poglavlje 6: Upiti za izdvajanje zapisa
Poglavlje 7: Osnovni trikovi sa upitima
Poglavlje 8: Upiti za ažuriranje zapisa
Poglavlje 9: Analiziranje podataka pomoću unakrsnih upita i izvedenih tabela
Poglavlje 10: Izrada izveštaja
Poglavlje 11: Izrada složenijih izveštaja
Poglavlje 12: Izrada jednostavnih obrazaca
Poglavlje 13: Izrada složenijih obrazaca
Poglavlje 14: Izrada navigacionog sistema
Poglavlje 15: Automatizovanje poslova pomoću makroa
Poglavlje 16: Automatizovanje poslova pomoću Visual Basica
Poglavlje 17: Pisanje pametnijeg koda
Poglavlje 18: Zajedničko korišćenje baze podataka
Poglavlje 19: Uvoženje i izvoženje podataka
Poglavlje 20: Povezivanje Accessa sa SQL Serverom
Poglavlje 21: Povezivanje Accessa sa SharePointom
Dodatak A: Prilagođavanje palete alatki Quick Access
Spisak termina korišćenih u knjizi
Indeks

O autoru
Matthew MacDonald izuzetan je pisac i programer. Autor je knjiga Excel 2007: The Missing Manual, Creating Web Sites: The Missing Manual, kao i desetak knjiga o programiranju u Microsoftovom okruženju .NET Framework.

Genres: Reference, Nonfiction, Computers, Technology

736 pages, Paperback

First published December 29, 2006

About the author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. He's particularly known for his books about building websites, which include a do-it-from-scratch tutorial (Creating a Website: The Missing Manual), a look at cutting-edge HTML5 (HTML5: The Missing Manual), and a WordPress primer (WordPress: The Missing Manual). He's also written a series of books about programming on and off the Web with .NET, teaches programming at Ryerson University, and is a three-time Microsoft MVP.

Reviews

[Tami · Rating 5 out of 5]

I got Access 2007: The Missing Manual mainly because I wanted to know how to create forms using Access. I had enough familiarity with the Access and Excel to create basic databases but I remember creating forms using the older version of Access to be quite difficult, probably made more difficult by the fact that I had inherited the forms and was trying to fix them.

Access 2007: The Missing Manual starts the reader off with the very basics of creating simple databases. Then, gradually teaches the reader how to connect, filter, query, create forms, and print reports. Throughout, there are step by step instructions, illustrations, and tips. At first, Access seems pretty daunting but I found that by the time I got through the book, I was pretty confident taking what I learned and adapting it to my own needs.

[Julz · Rating 4 out of 5]

I bought this after a class for which I registered was cancelled.

It seems fairly readable so far. If it can teach me what everyone says is the heinously complicated language of relational databases, then it will be a miracle!

Read this a couple of years ago, and it was very helpful. This series is my favorite for tech books, although I usually learn by Googling for tips and experimenting on my own.

[Michelle · Rating 4 out of 5]

of all the tech series i've encountered i like the missing manual (o'reilly) and head first (o'reilly) ones best. missing manual for the smooth conversational yet thorough writing, and head first for making things approachable and fun.

[Topilno]

Creating Web Pages for Dummies

[Pamela]

Love the Missing Manual series!

[Heep · Rating 3 out of 5]

It is a good review of the subject.

[Stanley · Rating 4 out of 5]

About as good as you can get with this subject matter.