Share this Page URL
Help

Index > Index - Pg. 690

Index (see also queries) parameters, 354 (see also arguments) report, 354 SQL Server view, 528 stored procedure, 533 Visual Basic, 141 parent forms, 229, 233, 235, 277 (see also forms) (see also subforms) parsers, XML, 564 Partial Replica Wizard, 639 partial replicas, 639 passwords, 648 (see also accounts) (see also security) Admin, 648, 650 database, 670, 671 input masks and, 91 replicated databases and, 643 SQL Server, 500, 515 strong, 662, 665 user, 661 pass­through queries, 325 Paste Table As dialog box, 316, 319 paths, data access page, 442 people (see users) performance analyzing, 66, 619 binding and, 593 data access page, 436, 440 fragmented files and, 617 importing vs. linking and, 108 indexes and, 87 normalization and, 56 Office Automation and, 611 optimization of queries, 312 redundant data and, 40 splitting databases and, 45 SQL Server database, 503 Performance Analyzer, 66, 619 period (.), 59 permissions, 650 (see also accounts) (see also passwords) (see also security) adding users to groups, 663 changing Admin password, 650 compacting and repairing databases, 618 creating groups and types of, 651 creating users, 658 explicit vs. implicit, 650 full, 648 group vs. user, 665 grouping, 653 PivotTables and, 380 replicated database, 643 testing user, and setting user passwords, 661 personal information, removing, 631 pessimistic locking, 608, 630 Picture Alignment property, 271 Picture property, 269, 271, 275 Picture Size Mode property, 271, 275 Picture Tiling property, 271 Picture Type property, 271 pictures (see images) pie charts, 359 690 PivotChart view, 380, 396 PivotCharts, 396 (see also PivotTables) as read­only objects, 380 creating, 396 Default View property and, 82 formatting, 401, 410 orientation and types of, 399 PivotChart component, 454 PivotChart view and, 380, 499 properties, 399 switching between PivotTables and, with Visual Basic, 404 turning one, into many, 403 PivotField object, 408 PivotFieldSet object, 408 PivotTable object, 408 PivotTable toolbar, 387 PivotTable view, 380, 386 PivotTable Wizard, 380, 382, 386 PivotTables, 380, 404 (see also PivotCharts) analyzing data in, 387 as read­only objects, 380 changing views of data in, 387 creating, 380 creating, with Visual Basic, 406 crosstab queries and, 304 data access pages and, 380, 412 Default View property and, 82 exporting, to Excel, 396 filtering data in forms, 387, 394 formatting, and setting properties, 394 importing, from Excel, 410 PivotTable component, 454 PivotTable view and, 380, 386 switching between PivotCharts and, with Visual Basic, 404 PivotTotal object, 408 PivotView object, 408 placeholder characters, input mask, 90 planning (see database design) plus sign (+), 426, 433 pop­up menus (see shortcut menus) pound sign (#), 212, 590 PowerPoint, 600 Precision property, 518 prefixes action query name, 314 control name, 348 naming conventions and, 58 Visual Basic variable name, 156 Presentation object, 600 Presentation window, 601 presentations PowerPoint, 600 XML, 578 Presentations collection, 603 Preview view, FrontPage, 428 Preview window, 343, 349, 356, 374 primary key fields action queries and, 314 AutoNumber data type and relationships, 53 cascading updates and, 76 DDL and, 325 designating, 7, 28 importing and, 115, 119