Pošto steknete sva ta znanja, spremni ste da se naueite šta treba uraditi kada se stvari ne odvijaju onako kako ste planirali. Tada koristite obradu grešaka, optimizaciju i debagovanje. Na kraju knjige se nalaze poglavlja koja ae Vas zabaviti: objašnjeno je programiranje višekorisniekih aplikacija i aplikaciji preduzeaa, a objašnjene su i mnoge tehnike koje ae svakom programeru omoguaiti da posao obavi efikasnije i efektnije. Poslednja poglavlja knjige su posveaena ulepšavanju aplikacije kako bi dobila profesionalni izgled. Saznajte koliko Access može biti moaan alat Saznajte kakvu ulogu Access može imati u modelu projektovanja Ovladajte veštinama potrebnim za projektovanje baze podataka i tabela Ovladajte veštinama pravljenja tabela, upita, formulara i izveštaja Oseaajte se udobno u Accessovom objektnom modelu Upotrebite bogatstvo programskog jezika VBA Naueite da obra?ujete greške i da debagujete Unapredite korisnieki interfejs koristeai ActiveX Data Objects (ADO) Istražite napredne teme kao što su Windows API, tehnologija Automation i moduli tipa Class O autoru: Alison Balter je osnivae kompanije InfoTechnologies Partners, Inc. To je kompanije iz Kalifornije koja se bavi raeunarskim konsaltnigom. Alison je veoma iskusan predavae i konsultant. Specijalizovala se za programiranje Windowsovih aplikacija. Bila je angažovana kao predavae i konsultant u mnogim korporacijama i vladinim agencijama, ukljueujuai Shell Oil, Prudential i Archdiocese of Los Angeles. Autor je preko 300 obrazovnih video traka, a napisala je i brojne knjige o Accessu, ukljueujuai Alison Balter's Mastering Access 2002 Desktop Development i Alison Balter's Guide to Access 2002 Enterprise Development. Na propratnom CD-ROM-u se nalazi: Svi primeri baza podataka koje se prave u knjizi Probni softver firme FMS Kratak sadržaj Uvod 1 Deo I: Osnove programiranja u Accessu 1 Access kao alat za programiranje 2 Šta svaki programer treba da zna o bazama podataka i tabelama 3 Zavisnosti: kljue za integritet podataka 4 Šta svaki programer treba da zna o osnovama upta 5 Šta svaki programer treba da zna o formularima 6 Šta svaki programer treba da zna o izveštajima 7 VBA: Uvod 8 Objekti, svojstva, metodi i doga?aji 9 Napredne tehnike rada sa formularima 10 Napredne tehnike rada sa izveštajima 11 Napredne tehnike rada sa upitima 12 Napredne tehnike VBA programiranja 13 Eksploatisanje modula klase 14 Šta su tehnologije ActiveX Objects i Data Access Objects i zašto su važne? Deo II: Šta treba uraditi kada se stvari ne odvijaju kao što je planirano 15 Debagovanje: Kljue za uspešno programiranje 16 Obrada grešaka: Priprema za neizbežno 17 Optimizovanje aplikacije Deo III: Pravljenje višekorisniekih aplikacija i aplikacija preduzeaa 18 Strategija za pravljenje Accessovih aplikacija 19 Upotreba spoljašnjih podataka 20 Pravljenje višekorisniekih aplikacija i aplikacija preduzeaa Deo IV: Programiranje za crni pojas 21 Upotreba ActiveX kontrola 22 Tehnologija Automation: komuniciranje sa ostalim aplikacijama 23 Eksploatacija Windows API-ja 24 Pravljenje sopstvenih biblioteka 25 Upotreba bildera, earobnjaka i dodataka menija 26 Uvod u Access i Internet/lokalnu mrežu Deo V: Poliranje aplikacije 27 Lako uspostavljanje bezbednosti baze podataka 28 Napredne tehnike bezbednosti 29 Dokumentovanje aplikacije 30 Održavanje aplikacije 31 Dodatni alati koji Vam mogu pomoai da efikasno obavite posao 32 Distribuiranje aplikacije Deo VI: Dodaci A Strukture tabela B Pravila imenovanja Indeks

Inside the Book • Create desktop databases or web apps for traditional and online users to gather, organize, and share data • Use professional templates to help you create desktop databases or web apps • Create web apps on SharePoint Team Services to collaborate and share information • Use tools for building a database or web app that makes information easier to find and use • Import data from other programs, HTML, XML files, and other databases • Use forms, filters, queries, and reports to capture and analyze data • Organize information and add impact with themes, pictures, tables, and charts • Add hyperlinks and web pages to forms and reports to use content on the Internet • Use macros and Visual Basic for Applications (VBA) to automate and add functionality to databases • Prepare for the Microsoft Office Specialist (MOS) exam Numbered Steps guide you through each task See Also points you to related information in the book Did You Know? alerts you to tips and techniques Illustrations with matching steps Tasks are presented on one or two pages Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts Table of contents ntroduction xvii 1 Getting Started with Access 1 Understanding How Databases Store Data 2 Starting Access 4 New! Using the Ribbon 6 Choosing Commands 7 New! Working with the Ribbon and Toolbars 8 Choosing Dialog Box Options 10 Using the Status Bar 11 Creating a Database 12 New! Opening a Database 14 New! Converting an Existing Database 16 Viewing the Access Window 17 Arranging Windows 18 Using Task and Window Panes 19 Getting Help While You Work 20 New! Saving a Database 22 Saving a Database with Different Formats 24 Working with Accounts 25 New! Working with Online Storage 26 New! Closing a Database and Exiting Access 28 New! 2 Touring Access Databases 29 Opening a Sample Database 30 Warnings About Macros and Add-Ins 31 Using a Switchboard 32 Changing Database Display Options 33 Viewing Database Objects 34 Working with Database Objects 36 Grouping and Hiding Database Objects 38 Touring a Table 40 Touring a Form 42 Entering Data 43 Touring a Query 44 Touring a Report 45 Switching Views 46 3 Planning and Creating a Custom Database 49 Creating a Custom Database Template 50 New! Using a Custom Database Template 52 New! Planning Tables 54 Creating Tables in a Database 55 Creating a Table by Entering Data 56 Creating an Application Part Using a Template 57 Importing Data into Tables 58 Linking to Data in Tables 59 Working with Table Records 60 Working with a Table in Design View 62 Specifying a Primary Key in Design View 63 Planning Table Relationships 64 Defining Table Relationships 66 Creating and Printing a Table Relationship Report 68 Ensuring Referential Integrity 70 Identifying Object Dependencies 71 Modifying Object Dependencies 72 4 Working with Fields 73 Inserting Fields 74 Working with Fields 76 Specifying Data Types and Field Properties 78 New! Viewing Field Properties 79 Changing Field Properties 80 Updating Field Properties 82 Setting Field Size 83 Formatting Text Values 84 Formatting Long Text with Rich Text 85 New! Formatting Date and Time Values 86 Formatting Number and Currency Values 88 Performing a Total Calculation 89 Creating Input Masks 90 Creating Indexed Fields 92 Specifying Required Fields and Default Values 94 Adding a Caption to a Field 95 Validating Field Values 96 Creating a Lookup Field 98 Setting Lookup Properties 100 Creating a Multivalued Field 101 Attaching Files to Field Records 102 Creating a Field Data Type Template 104 Setting Table Properties 106 5 Working with Tables 107 Working with Tables 108 Repairing Renaming Errors 110 Managing Linked Tables 111 Working with the Clipboard 112 Editing Text 114 Entering Data Accurately with AutoCorrect 116 Finding and Replacing Text 118 Checking Spelling 120 Using Custom Dictionaries 122 Formatting a Datasheet 123 Arranging Field Columns 124 Changing the Size of Field Columns 126 Managing Field Columns 127 Sorting Records 128 Viewing a Subdatasheet 130 Filtering Out Records 132 Creating Complex Filters Using Forms 134 6 Locating Specific Information Using a Query 135 Understanding Types of Queries 136 Creating a Query in Design View 137 Getting Information with a Query 138 Modifying a Query in Design View 139 Creating a Query Using a Wizard 140 Changing the Query Fields 142 Specifying Criteria for a Single Field 144 Specifying Criteria for Multiple Fields 145 Creating Queries with Comparison and Logical Operators 146 Performing Calculations in Queries 148 Creating a Parameter Query 150 Finding Duplicate Fields 152 Finding Unmatched Records 153 Creating New Tables with a Query 154 Adding Records with a Query 155 Deleting Records with a Query 156 Updating Records with a Query 157 Summarizing Values with Crosstab Query 158 Creating SQL-Specific Queries 160 7 Simplifying Data Entry with Forms 161 Creating Forms 162 Working with Form Controls 163 Creating a Form 164 Creating a Blank Form 165 Creating a Form Using the Form Wizard 166 Creating a Navigation Form 168 Creating a Multiple Items Form 169 Creating a Datasheet Form 170 Creating a Dialog Form 171 Creating a Split Form 172 Entering and Editing Data in a Form 174 Working with a Form in Layout View 176 Working with a Form in Design View 178 Modifying a Form 180 Adding Existing Fields 182 Adding and Modifying Controls 184 Adding Controls with a Wizard 186 Creating a Subform 188 Enhancing a Form 190 Working with Themes on Forms 192 Using Windows Themes on Forms 194 8 Creating Reports to Convey Information 195 Exploring Different Ways to Create a Report 196 Creating a Report 198 Creating a Blank Report 200 Creating Mailing Labels 201 Using Sections in Design View 202 Working with Controls 203 Creating and Modifying a Report in Design View 204 Using Buttons and Controls 206 Arranging Information 208 Inserting a Title, Page Numbers, or the Date and Time 210 Inserting a Picture as a Logo 212 Setting Properties 213 Performing Calculations in Reports 214 Grouping and Sorting in Reports 216 Inserting a Header or Footer 218 Assigning a Shortcut Key to a Control 219 Checking for Errors in Reports and Forms 220 Changing the Page Setup 222 Previewing Information 224 Printing Information 225 9 Improving the Appearance of Forms and Reports 227 Applying a Theme to a Form or Report 228 Creating a Custom Theme 230 Formatting a Form or Report 232 Adding Lines and Rectangles 234 Changing Line or Border Thickness and Style 235 Changing Colors 236 Applying Styles, Shapes, and Effects 238 Applying Special Effects 240 Applying the Format Painter 241 Applying Conditional Formatting 242 Changing Tabbing Order 244 Resizing and Moving Controls 246 Aligning Controls 248 Positioning Controls 250 Grouping and Ungrouping Controls 252 Changing Gridlines 253 Creating a Tabular or Stacked Layout 254 Changing Control Margins and Padding 256 Changing Control Rows and Columns 257 Sharing Information Among Documents 258 Copying and Pasting Objects 259 Inserting a New Object 260 Inserting an Object from a File 261 Inserting a Picture 262 Inserting Excel Charts and Worksheets 264 Inserting a Graph Chart 266 Formatting Chart Objects 268 Moving and Resizing an Object 270 Setting OLE Options 271 10 Connecting to Information on the Web 273 Integrating Access and the Internet 274 Creating a Hyperlink Field 276 Inserting a Hyperlink to a File or Web Page 277 Building a Hyperlink with Expressions 278 Linking to an Object in a Database 280 Creating a Hyperlink with an E-mail Address 282 Navigating Hyperlinks 283 Working with Hyperlinks 284 Inserting a Web Browser Control 286 Exporting Database Objects to HTML 288 Importing or Linking to an HTML File 289 Creating a Table Using SharePoint 290 Importing or Linking to SharePoint Data 292 Exporting Data to SharePoint 294 Moving Data to SharePoint 295 Working with SharePoint Data Offline 296 Publishing a Database to SharePoint 297 11 Importing and Exporting Information 299 Importing and Linking Data 300 Saving Import and Export Settings 302 Importing or Linking Data from an Access Database 304 Importing or Linking Data from Excel 306 Importing or Linking Data from a Mail Program 307 Getting Data from Other Sources 308 Importing and Exporting XML Data 310 Exporting Data to Other Programs 312 Merging Data with Word 314 Exporting Data to Excel 316 New! Creating a PDF Document 318 Creating an XPS Document 319 Saving a Database Object 320 12 Managing a Database 321 Backing Up a Database 322 Compacting and Repairing a Database 323 Changing Database Properties 324 Documenting a Database 325 Analyzing a Database 326 Working with Add-Ins 328 Setting Database Application Options 330 Splitting a Database 332 13 Protecting and Securing a Database 333 Adding Security Encryption to a Database 334 Creating a Digital Certificate 336 Adding a Digital Signature to a Database 337 Packaging and Digitally Signing a Database 338 Avoiding Harmful Attacks 340 Using the Trust Center 342 Selecting Trusted Publishers and Locations 343 Setting Document Related Security Options 344 Setting ActiveX Security Options 345 Setting Add-In Security Options 346 Setting Macro Security Options 348 Changing Message Bar Security Options 349 Setting Privacy Options 350 Locking a Database 351 Locking Database Records 352 14 Customizing Access 353 Setting Current Database Options 354 Setting Object Designers Options 356 Setting Database File Options 358 New! Setting Editing Options 359 Changing Datasheet Formatting Options 360 Setting Office Options 361 New! Setting General Options 362 New! Working with Touch Screens 363 New! Accessing Commands Not in the Ribbon 364 Using Multiple Languages 365 Working with Office Tools 366 New! Maintaining and Repairing Office 368 New! 15 Automating and Extending a Database 369 Automating Databases with Macros 370 Creating or Editing a Macro 372 Running and Testing a Macro 374 Creating a Macro Group 376 Creating a Macro Conditional 377 Adding Comments to a Macro 378 Creating a Message Box 379 Assigning a Macro to an Event 380 Assigning a Macro to a Button 382 Assigning a Macro to a Toolbar 383 Extending a Database with VBA 384 Creating a Module 386 Viewing the Visual Basic Editor 387 Creating a Sub Procedure 388 Writing VBA Commands 389 Running a Sub Procedure 390 Copying Commands from the Object Browser 391 Creating a Custom Function 392 Running a Custom Function 393 Creating a Class Module for a Form or Report 394 Setting Project Properties 395 Debugging a Procedure 396 Identifying VBA Debugging Tools 397 Optimizing Performance with an ACCDE File 398 16 Creating a Web App with Access 399 Creating a Web App 400 New! Opening a Web App 402 New! Adding Tables and Data to a Web App 404 New! Viewing and Editing Data from a Web App 406 New! Creating a View in a Web App 408 New! Modifying a Web App 410 New! Changing Properties in a Web App 412 New! Creating Actions in a Web App 414 New! Creating Database Objects in a Web App 416 New! Using the Navigation Pane with Web Apps 417 New! Launching a Web App in a Web Browser 418 New! Packaging a Web App 420 New! Working with a Web App on SharePoint 421 New! Changing Web App Settings on SharePoint 422 New! Adding a Web App from the SharePoint Store 423 New! 17 Working Online with Office Documents 425 Working Online with SharePoint and SkyDrive 426 New! Signing in to SharePoint or SkyDrive 428 New! Saving and Opening on SharePoint or SkyDrive 430 New! Accessing Documents on SharePoint 432 New! Syncing Documents on SharePoint 434 New! Sharing Documents on SkyDrive 436 New! Accessing Documents on SkyDrive 438 New! Managing Documents on SkyDrive 440 Downloading or Uploading Documents on SkyDrive 442 Creating Office Documents on SkyDrive 443 Sending Links to Documents on SkyDrive 444 New! Comparing the Office Desktop App to the Web App 446 Working with Office Web Apps 448 New! Saving or Printing in Office Web Apps 450 Co-authoring Documents with Office Web Apps 452 New! Blocking Co-authoring Documents 454 New Features 455 New! Microsoft Office Specialist 461 Index 469 Author Steve Johnson has written more than 80 books on a variety of computer software, including Adobe Edge Animate, Adobe Photoshop CS6, Adobe Dreamweaver CS6, Adobe InDesign CS6, Adobe Illustrator CS6, Adobe Flash Professional CS5, Microsoft Windows 8, Microsoft Office 2013 and 2010, Microsoft Office 2008 for the Macintosh, and Apple OS X Mountain Lion. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys coaching baseball, playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. Steve and his family live in Northern California, but can also be found visiting family all over the western United States.

Osnovno o knjizi: Knjiga obuhvata sledeće oblasti MCAS ispita: tabele polja zavisnosti referencijalni integritet autoNumber ključ šabloni tip podataka text tip podataka number tip podataka date/time tip podataka currency tip podataka memo maske za unošenje podataka prilozi formulari podformulari pivot tabele izveštaji čarobnjak za pravljenje oznaka čarobnjak za pravljenje izveštaja trake kontrole automatsko formatiranje uvoženje podataka spoljašnji podaci upiti Microsoft Office Access 2007 na dlanu Za one koji bi više voleli da im se pokaže nego da im se kaže Numerisani koraci vas vode kroz svaki postupak Da li znate? skreće pažnju čitaoca na savete i tehnike Takođe pogledajte upućuje čitaoca na informacije u knjizi Zadaci su prikazani na jednoj ili dve stranice Ilustracije na kojima su koraci obeleženi Saznajte kako da: Efikasnije napravite bazu podataka koristeći novi interfejs Koristite alatke za pravljenje baze podataka pomoću kojih se informacije lakše pronalaze i koriste Uvozite podatke iz drugih programa, HTML datoteka, XML datoteka i drugih baza podataka Koristite formulare, filtere, upite i izveštaje pomoću kojih se podaci izdvajaju i analiziraju Pronađete načine pomoću kojih ćete sprečiti narušavanje podataka i neautorizovan pristup podacima Koristeći interaktivne web stranice svoje podatke podelite sa drugim korisnicima Novostečeno znanje upotrebite u online radionicama Organizujete informacije i istaknete ih koristeći ilustracije, dijagrame SmartArt, tabele i grafikone Koristite Groove i SharePoint Team Services da biste sarađivali i delili dokumente i informacije Pripremite ispit Microsoft Certified Application Specialist (MCAS) Na Webu U knjizi se koriste praktični primeri kako biste naučili kada da upotrebite ono što ste naučili. Takođe, knjiga sadrži praktikume koji će vam pomoći da pojedinačne zadatke ugradite u projekte. Primere datoteka za Access, koje su vam neophodne za izradu projekata, pronaćićete na adresi www.perspection.com.. Perspection je objavio veliki broj knjiga o različitim softverskim proizvodima, kao što su Microsoft Office 2003 i Microsoft Office XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX i Macromedia Fireworks, i knjige iz oblasti web izdavaštva. Stiv Džonson je 1991. godine, nakon što je radio u kompanijama Apple Computer i Microsoft, osnovao Perspection, Inc. Kompanija Perspection je okrenuta pružanju informacija i podučavanju kako bi korisnicima pomogla da efikasnije koriste softver. Autori kompanije Perspection su napisali više od 80 knjiga iz oblasti računara koje su prodate u više od 5 miliona primeraka. Microsoft Certified Appliaction Specialist Obuhvata i program MCAS ispita! Kategorija: Baze podataka Oblast: Microsoft Office Access 2007 Nivo: Početni-srednji Sadržaj Uvod XV Prvi koraci u Accessu 1 Upoznavanje sa Accessovim bazama podataka 29 Planiranje i pravljenje baze podataka 47 Rad sa poljima 69 Rad sa tabelama 101 Pronalaženje informacija pomoću upita 131 Pojednostavljivanje unošenja podataka korišćenjem formulara 157 Pravljenje izveštaja radi prikazivanja informacija 187 Ulepšavanje formulara i izveštaja 219 Rad na Webu 261 Uvoženje i izvoženje informacija 279 Upravljanje bazom podataka 303 Bezbednost i zaštita baze podataka 315 Prilagođavanje Accessa 333 Unapređivanje baze podataka pomoću programiranja 355 Korišćenje dokumenata paketa Office sa drugim korisnicima 371 Nove osobine 395 Microsoft Certified Appliaction Specialist 401 Indeks 409