Search results for """ "Access""

Book SynopsisEasy steps to practical databases People who really know how to build, populate, and simplify databases are few and far between. Access 2019 For Dummies is here to help you join the ranks of office heroes who possess these precious skills. This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it's the book that holds all the secrets behind the mysteries of Access! Build effective databases from the ground upSimplify your data entry with forms and tablesWrite queries that produce answers to your data questionsSimplify input with forms There's no time like the present to get your hands on the insight that database beginners need to become Access gurus.Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Where to Go from Here 3 Part 1: Basic Training 5 Chapter 1: Access 2019 Basic Training 7 What Is Access Good For, Anyway? 8 Building big databases 8 Creating databases with multiple tables 9 Databases with user forms 12 Databases that require special reporting 13 What’s New in Access 2019? 16 Reach Out with SharePoint 17 How Access Works and How You Work with it 18 Opening Access 18 Selecting a starting point 19 Now What? 23 Chapter 2: Navigating the Access Workspace 25 Diving Right In 27 Working with Onscreen Tools in Access 29 Clicking tabs 30 Using buttons 31 The File tab and Quick Access tools 31 Accessing panes, panels, and context-sensitive tools 33 Customizing the Access Workspace 34 Repositioning the Quick Access Toolbar 34 Adding buttons to the Quick Access Toolbar 35 Removing buttons from the Quick Access Toolbar 37 Minimizing the Ribbon 37 Working with ScreenTips 38 Mousing Around 41 Navigating Access with the Alt Key 41 Chapter 3: Database Basics 43 Database Lingo 43 Data, no matter how you pronounce it 44 Fields of dreams (or data) 44 Records 45 Tables 45 The database 45 Field Types and Uses 46 Choosing Between Flat and Relational Databases 51 Isolationist tables 51 Tables that mix and mingle 52 Building a Database 53 Adding and Removing Tables 57 One more, please 57 Oops, I didn’t mean to do that 59 Part 2: Getting it All on the Table 61 Chapter 4: Sounds Like a Plan 63 Planning Your Database Tables 63 Reviewing fields 64 Determining data types 64 The new normal 66 Understanding normal forms 66 Normalizing your tables 67 Building Tables in Design View 70 Creating fields 70 Setting data types 72 Chapter 5: Table Tune Ups 75 The Primary Key to Success 76 The lowdown on primary keys 76 Creating a primary key 77 Making Tables Get Along 79 Rules of relationships 79 Relationship types 80 Building Table Relationships 82 The Relationships window 82 Table relationships 83 Indexing for Faster Queries 87 Creating your own index 88 Adding and removing indexes 91 Chapter 6: Remodeling Your Data 93 Opening a Table for Editing 94 Inserting Records and Fields 97 Adding a record 97 Inserting a field 98 Deleting a field 101 Modifying Field Content 102 Name-Calling 103 Renaming fields 104 Renaming a table 106 Turn Uh-Oh! into Yee-Hah! 108 Chapter 7: Types, Masks, and Triggers 109 Access Table Settings 110 Field Data Formats 112 Text fields 113 Number and currency fields 115 Date/time fields 118 Yes/No fields 119 Gaining Control of Data Entry 121 You really need to put a mask on those fields 121 To require or not to require 128 Making your data toe the line with validation 129 Give Your Fingers a Mini Vacation by Default 131 Part 3: Data Management Mania 133 Chapter 8: A Form for All Reasons 135 Generating Forms 135 Keeping it simple: Form tools 137 Granting most wishes: The Form Wizard 139 Customizing Form Parts 143 Taking the Layout view 143 The theme’s the thing 145 Managing form controls 145 Managing Data in Form View 150 Navigating and finding records 150 Saving, clearing, and deleting 151 Chapter 9: Importing and Exporting Data 153 Retrieving Data from Other Sources 154 Translating data formats 154 Importing and linking 157 Hit the Road, Data 162 Export formats 162 Exporting table or query data 163 Exporting a report to PDF 165 Chapter 10: Automatically Editing Data 167 Please Read This First! 167 Creating Consistent Corrections 170 Using Queries to Automate the Editing Process 173 Looking for duplicate records 173 Running the Find Duplicates Query Wizard 174 Chapter 11: Access and the Web 179 How Access Works with the Web 179 Understanding Office 365 180 Connect Office 365 to Access 2019 181 Your data and the cloud 182 Upload your Access desktop data to the cloud 183 Click! Using Hyperlinks in your desktop Access database 186 Adding a Hyperlink field to your desktop database table 187 Fine-tuning your hyperlinks 188 Testing links 190 Part 4: The Power of Questions 191 Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 193 Using the Find Command 194 Finding anything fast 194 Shifting Find into high gear 196 Sorting Alphabetically and Numerically 199 Sorting by a single field 199 Sorting on more than one field 200 Fast and Furious Filtering 201 Filtering by a field’s content 202 Filter by selection 203 Filter by Form 204 Unfiltering Filter by Form 207 Filter by excluding selection 207 Chapter 13: I Was Just Asking for Answers 209 Simple (Yet Potent) Filter and Sort Tools 210 Filter things first 210 Fact-finding with fun, fast filtering 213 Here’s the “advanced” part 214 Select Queries 220 Solid relationships are the key to getting it all (from your tables) 221 Running the Query Wizard 221 Getting Your Feet Wet with Ad Hoc Queries 227 Adding the finishing touches 230 Saving the query 231 Running your query 233 Chapter 14: I Want These AND Those OR Them 235 Working with AND and/or OR 236 Data from here to there 237 Using multiple levels of AND 238 Establishing criteria with OR 239 Combining AND with OR and OR with AND 240 Chapter 15: Number Crunching with the Total Row 243 Say Hello to the Total Row 243 Adding the Total Row to Your Queries 245 Working Out the Total Row 246 Putting it together with Group By 247 Well, that certainly sums it up 248 Counting, the easy way 250 Narrowing the results with Where 251 Creating Your Own Top-Ten List 252 Choosing the Right Field for the Summary Instruction 254 Chapter 16: Express Yourself with Formulas 255 A Simple Calculation 256 Complex Calculations 258 Calculate ’til you drop! 259 Using one calculation in another 259 Using parameter queries to ask for help 261 “Adding” words with text formulas 262 Hooray for Expression Builder 264 Chapter 17: Take Charge with Action Queries 269 Easy Update 270 Add Records in a Flash 274 Quick Cleanup 277 Part 5: Simple and Snazzy Reporting 281 Chapter 18: Fast and Furious Automatic Reporting 283 Quick and Not-S0-Dirty Automatic Reporting 284 Creating a quick, one-table report 285 Starting the Report Wizard 289 Previewing Your Report 294 Zooming in and out and all around 295 Pop goes the menu 297 Beauty Is Only Skin (Report) Deep 298 The Print Options tab 298 The Page tab 300 The Columns tab 301 Chapter 19: Professionally Designed Reports Made Easy 303 Report Repairs 304 Report Organization 305 Structural devices 306 Page breaks 308 Formatting Stuff 310 Adding color 313 Relocation, relocation, relocation 314 One size does not fit all 316 Spaced-out controls 317 Borderline beauty 318 Tweaking your text 321 Sneaking a Peek 323 Getting a Themes Makeover 324 Adding More Design Elements 325 Drawing lines 325 Pretty as a picture 326 Adding a logo 327 Chapter 20: Groups and Page Breaks, Headers and Footers 329 A Place for Everything and Everything in Its Place 330 Layout basics 330 Sections 332 Grouping your records 335 So you want more? 338 Customizing Properties 338 Controlling report and page headings 341 Adjusting individual sections 343 Itemized adjustments 344 Chapter 21: Mailings to the Masses 351 Massive Mailings with the Label Wizard 351 Part 6: The Parts of Tens 359 Chapter 22: Ten Common Problems 361 That’s Just Not Normal 362 You Type 73.725, but it Changes to 74 363 The Words They Are A-Changing 363 Was There and Now It’s Gone 364 Undo 365 Search for the missing record 365 Backup recovery 365 You Run a Query, but the Results Aren’t What You Expect 366 The Dreaded Parameter Dialog Box 367 The Slowest Database in Town 368 Your Database File Is as Big as a House 369 You Get a Mess When Importing Your Spreadsheet 371 We’re Sorry; Your Database File Is Corrupt 371 Chapter 23: Ten Uncommon Tips 373 Document Everything as Though One Day You’ll Be Questioned by the FBI 374 Keep Your Fields as Small as Possible 375 Use Number Fields for Real Numbers 376 Validate Your Data 376 Use Understandable Names to Keep Things Simple 377 Delete with Great Caution 377 Backup, Backup, Backup 377 Think, Think, and Think Again 378 Get Organized and Stay Organized 378 There’s No Shame in Asking for Help 379 Appendix A: Getting Help 381 Index 383

Read more less

Book Synopsis

Read more less

Book SynopsisThe all-in-one reference to all aspects of Microsoft Access 2010 If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it's what you need to make Access more accesssible. Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010 Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access wTable of ContentsIntroduction 1 Book I: Essential Concepts 7 Chapter 1: Introducing Access 2010 9 Chapter 2: Getting Started, Getting Around 17 Chapter 3: Designing Your Database the Relational Way 37 Book II: Tables for Storing Your Data 65 Chapter 1: Creating and Modifying Tables 67 Chapter 2: Refining Your Table in Design View 103 Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121 Chapter 4: Importing and Exporting Data 137 Chapter 5: Avoiding “Garbage In, Garbage Out” 161 Chapter 6: Relating Your Tables and Protecting Your Data 179 Book III: Queries (or Getting Information from Your Data) 189 Chapter 1: Creating Select Queries 191 Chapter 2: Letting Queries Do the Math 223 Chapter 3: Doing Neat Things with Action Queries and Query Wizards 257 Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279 Book IV: Forms for Editing Data 303 Chapter 1: Designing and Using Forms (and Reports) 305 Chapter 2: Jazzing Up Your Forms (and Reports) 329 Chapter 3: Creating Smarter Forms 353 Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 377 Book V: Reporting in Words and Pictures 397 Chapter 1: Creating and Spiffing Up Reports 399 Chapter 2: Printing Beautiful Reports 427 Chapter 3: Creating Charts and Graphs from Your Data 445 Book VI: Automation with Macros 471 Chapter 1: Making Macros Do the Work 473 Chapter 2: Making Macros Smarter 491 Book VII: Database Administration 509 Chapter 1: Database Housekeeping 511 Chapter 2: Sharing the Fun: Managing Multiuser Access 521 Chapter 3: Securing Your Access Database 535 Book VIII: Programming in VBA 547 Chapter 1: What the Heck Is VBA? 549 Chapter 2: Writing Code 569 Chapter 3: Writing Smarter Code 593 Chapter 4: Controlling Forms with VBA 617 Chapter 5: Using SQL and Recordsets 641 Chapter 6: Debugging Your Code 653 Book IX: Going Beyond Access 663 Chapter 1: Automation with Other Office Programs 665 Chapter 2: Using Access as a Front-End to SQL Server 681 Chapter 3: Using Access with SharePoint 697 Appendix: Installing Microsoft Access 719 Index 725

Read more less

Book Synopsis

Read more less

Book SynopsisTable of ContentsIntroduction xxxix Part I: Access Building Blocks 1 Chapter 1: An Introduction to Database Development 3 The Database Terminology of Access 3 Relational Databases 6 Access Database Objects 7 A Five-Step Design Method 9 Chapter 2: Getting Started with Access 17 The Access Welcome Screen 17 How to Create a Blank Database 18 The Access 2019 Interface 20 The Ribbon 24 The Quick Access toolbar 25 Part II: Understanding Access Tables 29 Chapter 3: Creating Access Tables 31 Table Types 31 Creating a New Table 32 Creating tblCustomers 49 Changing a Table Design 50 Understanding tblCustomers Field Properties 68 Setting the Primary Key 71 Indexing Access Tables 73 Printing a Table Design 79 Saving the Completed Table 81 Manipulating Tables 81 Adding Records to a Database Table 84 Understanding Attachment Fields 84 Chapter 4: Understanding Table Relationships 87 Building Bulletproof Databases 88 Data Normalization and Denormalization 90 Table Relationships 102 Integrity Rules 110 Keys 113 Creating relationships and enforcing referential integrity 119 Viewing all relationships 125 Deleting relationships 126 Following application-specific integrity rules 126 Chapter 5: Working with Access Tables 129 Understanding Datasheets 130 Looking at the Datasheet Window 131 Opening a Datasheet 135 Entering New Data 135 Navigating Records in a Datasheet 142 Changing Values in a Datasheet 146 Using the Undo Feature 148 Copying and Pasting Values 148 Replacing Values 149 Adding New Records 150 Deleting Records 150 Displaying Records 152 Sorting and Filtering Records in a Datasheet 160 Aggregating Data 165 Printing Records 166 Previewing Records 167 Chapter 6: Importing and Exporting Data 169 How Access Works with External Data 169 Options for Importing and Exporting 173 Exporting to External Formats 202 Chapter 7: Linking to External Data 209 Linking External Data 210 Working with Linked Tables 225 Splitting a Database 229 Part III: Working with Access Queries 237 Chapter 8: Selecting Data with Queries 239 Introducing Queries 240 Creating a Query 241 Working with Query Fields 247 Adding Criteria to Your Queries 252 Printing a Query’s Recordset 255 Saving a Query 256 Creating Multi-table Queries 256 Working with the Table Pane 261 Creating and Working with Query Joins 262 Chapter 9: Using Operators and Expressions in Access 269 Introducing Operators 269 Using Operators and Expressions in Queries 283 Entering Single-Value Field Criteria 289 Using Multiple Criteria in a Query 297 Entering Criteria in Multiple Fields 304 Chapter 10: Going Beyond Select Queries 311 Aggregate Queries 311 Action Queries 320 Crosstab Queries 336 Optimizing Query Performance 348 Part IV: Analyzing Data in Microsoft Access 353 Chapter 11: Transforming Data in Access 355 Finding and Removing Duplicate Records 355 Common Transformation Tasks 363 Chapter 12: Working with Calculations and Dates 379 Using Calculations in Your Analyses 379 Using Dates in Your Analyses 392 Chapter 13: Performing Conditional Analyses 405 Using Parameter Queries 405 Using Conditional Functions 414 The Switch function 420 Comparing the IIf and Switch functions 421 Chapter 14: The Fundamentals of Using SQL 425 Understanding Basic SQL 425 Getting Fancy with Advanced SQL Statements 430 Showing only the SELECT TOP or SELECT TOP PERCENT 433 Performing action queries via SQL statements 436 Using SQL-Specific Queries 438 Chapter 15: Subqueries and Domain Aggregate Functions 445 Enhancing Your Analyses with Subqueries 446 Domain Aggregate Functions 459 Examining the syntax of domain aggregate functions 461 Using domain aggregate functions 463 Chapter 16: Running Descriptive Statistics in Access 469 Basic Descriptive Statistics 470 Advanced Descriptive Statistics 479 Part V: Working with Access Forms and Reports 487 Chapter 17: Creating Basic Access Forms 489 Working with Form Views 489 Understanding Different Types of Forms 490 Working with Controls 503 Introducing Properties 524 Chapter 18: Working with Data on Access Forms 531 Using Form View 532 Changing Values in a Form 537 Printing a Form 544 Working with Form Properties 545 Adding a Form Header or Footer 556 Working with Section Properties 556 Changing the Layout 558 Converting a Form to a Report 562 Chapter 19: Working with Form Controls 563 Setting Control Properties 563 Creating a Calculated Control 571 Working with Subforms 572 Form Design Tips 573 Tackling Advanced Forms Techniques 576 Using the Tab Control 583 Using Dialog Boxes to Collect Information 586 Designing a Form from Scratch 589 Chapter 20: Presenting Data with Access Reports 599 Introducing Reports 599 Creating a Report, from Beginning to End 604 Creating a report with the Report Wizard 605 Banded Report Design Concepts 622 Creating a Report from Scratch 628 Improving the Report’s Appearance 651 Chapter 21: Advanced Access Report Techniques 657 Grouping and Sorting Data 658 Formatting Data 670 Adding Data 688 Adding Even More Flexibility 690 Part VI: Microsoft Access Programming Fundamentals 703 Chapter 22: Using Access Macros 705 An Introduction to Macros 705 Understanding Macro Security 709 Multi-action Macros 713 Submacros 716 Conditions 720 Temporary Variables 723 Error Handling and Macro Debugging 728 Embedded Macros 734 Macros versus VBA Statements 736 Chapter 23: Using Access Data Macros 741 Introducing Data Macros 742 Understanding Table Events 742 Using the Macro Builder for Data Macros 745 Understanding the Action Catalog 747 Creating Your First Data Macro 751 Managing Macro Objects 755 Recognizing the Limitations of Data Macros 757 Chapter 24: Getting Started with Access VBA 759 Introducing Visual Basic for Applications 760 Understanding VBA Terminology 761 Starting with VBA Code Basics 762 Creating VBA Programs 763 Modules and procedures 763 Working in the code window 770 Understanding VBA Branching Constructs 777 Working with Objects and Collections 786 Exploring the Visual Basic Editor 792 Chapter 25: Mastering VBA Data Types and Procedures 801 Using Variables 802 Working with Data Types 809 Understanding Subs and Functions 829 Creating Functions 835 Simplifying Code with Named Arguments 840 Chapter 26: Understanding the Access Event Model 843 Programming Events 844 Identifying Common Events 847 Paying Attention to Event Sequence 856 Chapter 27: Debugging Your Access Applications 865 Organizing VBA Code 866 Testing Your Applications 867 Traditional Debugging Techniques 873 Using the Access Debugging Tools 879 Trapping Errors in Your Code 893 Part VII: Advanced Access Programming Techniques 899 Chapter 28: Accessing Data with VBA 901 Working with Data 901 Understanding DAO Objects 904 Understanding ADO Objects 917 Writing VBA Code to Update a Table 923 Chapter 29: Advanced Data Access with VBA 937 Adding an Unbound Combo Box to a Form to Find Data 937 Filtering a Form 945 Chapter 30: Customizing the Ribbon 955 The Ribbon Hierarchy 955 Controls for Access Ribbons 956 Editing the Default Ribbon 961 Working with the Quick Access Toolbar 964 Developing Custom Ribbons 966 Creating a Custom Ribbon 969 The Basic Ribbon XML 977 Adding Ribbon Controls 979 Attaching Ribbons to Forms and Reports 989 Removing the Ribbon Completely 990 Chapter 31: Preparing Your Access Application for Distribution 993 Defining the Current Database Options 994 Polishing Your Application 1009 Bulletproofing an Application 1022 Chapter 32: Integrating Access with SharePoint 1039 Introducing SharePoint 1039 Understanding SharePoint Sites 1040 Sharing Data between Access and SharePoint 1043 Using SharePoint Templates 1052 Index 1055

Read more less

Book SynopsisA friendly, step-by-step guide to the Microsoft Office databaseapplication Access may be the least understood and most challengingapplication in the Microsoft Office suite. This guide is designedto help anyone who lacks experience in creating and managing adatabase learn to use Access 2010 quickly and easily.Table of ContentsIntroduction 1 Part I: Basic Training 9 Chapter 1: Getting to Know Access 2010 11 Chapter 2: Finding Your Way Around Access 37 Chapter 3: Database Basics 59 Part II: Getting It All on the Table 79 Chapter 4: Keys, Relationships, and Indexes 81 Chapter 5: Remodeling Your Data 99 Chapter 6: What’s Happening Under the Table? 115 Part III: Data Mania and Management 139 Chapter 7: Creating Data Forms 141 Chapter 8: Importing and Exporting Data 155 Chapter 9: Editing Data Automatically 169 Chapter 10: Gather Locally, Share Globally 181 Part IV: Ask Your Data, and Ye Shall Receive Answers 201 Chapter 11: Fast Finding, Filtering, and Sorting Data 203 Chapter 12: I Was Just Asking . . . for Answers 219 Chapter 13: I’ll Take These AND Those OR Them 245 Chapter 14: Queries That Think Faster Than You 255 Chapter 15: Calculating with Your Data 267 Chapter 16: Flying into Action Queries 283 Part V: Plain and Fancy Reporting 295 Chapter 17: Quick and Not-So-Dirty Automatic Reporting 297 Chapter 18: Dazzling Report Design 319 Chapter 19: Headers and Footers and Groups, Oh My! 345 Chapter 20: Magical Mass Mailings 367 Part VI: More Power to You 375 Chapter 21: Making It All Better with the Analyzer Tools 377 Chapter 22: Hello! Creating an Interface to Welcome Database Users 389 Part VII: The Part of Tens 399 Chapter 23: Ten Common Problems 401 Chapter 24: Ten Uncommon Tips 413 Index 421

Read more less

Book SynopsisMaster database creation and management Access 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer.Table of ContentsIntroduction xxxix Part I: Access Building Blocks 1 Chapter 1: An Introduction to Database Development 3 The Database Terminology of Access 3 Relational Databases 6 Access Database Objects 7 A Five-Step Design Method 10 Chapter 2: Getting Started with Access 19 The Access Welcome Screen 19 How to Create a Blank Desktop Database 21 The Access 2016 Interface 23 The Ribbon 26 The Quick Access toolbar 28 Part II: Understanding Access Tables 31 Chapter 3: Creating Access Tables 33 Table Types 33 Creating a New Table 34 Creating tblCustomers 51 Changing a Table Design 52 Understanding tblCustomers Field Properties 70 Setting the Primary Key 73 Indexing Access Tables 75 Printing a Table Design 81 Saving the Completed Table 83 Manipulating Tables 83 Adding Records to a Database Table 85 Understanding Attachment Fields 86 Chapter 4: Understanding Table Relationships 89 Building Bulletproof Databases 90 Data Normalization and Denormalization 92 Table Relationships 104 Integrity Rules 113 Keys 116 Chapter 5: Working with Access Tables 131 Understanding Datasheets 132 Looking at the Datasheet Window 134 Opening a Datasheet 138 Entering New Data 138 Navigating Records in a Datasheet 145 Changing Values in a Datasheet 148 Using the Undo Feature 150 Copying and Pasting Values 151 Replacing Values 152 Adding New Records 153 Deleting Records 153 Displaying Records 154 Sorting and Filtering Records in a Datasheet 163 Aggregating Data 168 Printing Records 169 Previewing Records 170 Chapter 6: Importing and Exporting Data 171 How Access Works with External Data 171 Options for Importing and Exporting 175 Importing External Data 177 Exporting to External Formats 200 Chapter 7: Linking to External Data 209 Linking External Data 210 Working with Linked Tables 224 Splitting a Database 228 Part III: Working with Access Queries 235 Chapter 8: Selecting Data with Queries 237 Introducing Queries 238 Creating a Query 240 Working with Query Fields 246 Adding Criteria to Your Queries 250 Printing a Query’s Recordset 254 Saving a Query 254 Creating Multi-Table Queries 254 Working with the Table Pane 259 Creating and Working with Query Joins 261 Chapter 9: Using Operators and Expressions in Access 267 Introducing Operators 267 Using Operators and Expressions in Queries 282 Entering Single-Value Field Criteria 288 Using Multiple Criteria in a Query 296 Entering Criteria in Multiple Fields 302 Chapter 10: Going Beyond Select Queries 309 Aggregate Queries 309 Action Queries 318 Crosstab Queries 333 Optimizing Query Performance 345 Part IV: Analyzing Data in Access 349 Chapter 11: Transforming Data in Access 351 Finding and Removing Duplicate Records 351 Common Transformation Tasks 359 Chapter 12: Working with Calculations and Dates 375 Using Calculations in Your Analyses 375 Using Dates in Your Analyses 388 Chapter 13: Performing Conditional Analyses 401 Using Parameter Queries 401 Using Conditional Functions 410 Chapter 14: The Fundamentals of Using SQL 421 Understanding Basic SQL 421 Getting Fancy with Advanced SQL Statements 426 Using SQL-Specific Queries 433 Chapter 15: Subqueries and Domain Aggregate Functions 441 Enhancing Your Analyses with Subqueries 442 Domain Aggregate Functions 455 Chapter 16: Running Descriptive Statistics in Access 467 Basic Descriptive Statistics 468 Advanced Descriptive Statistics 476 Part V: Working with Access Forms and Reports 483 Chapter 17: Creating Basic Access Forms 485 Formulating Forms 486 Working with Controls 498 Introducing Properties 517 Chapter 18: Working with Data on Access Forms 525 Using Form View 526 Changing Values in a Form 531 Printing a Form 538 Working with Form Properties 539 Adding a Form Header or Footer 550 Working with Section Properties 550 Changing the Layout 552 Converting a Form to a Report 556 Chapter 19: Working with Form Controls 557 Setting Control Properties 558 Creating a Calculated Control 565 Working with Subforms 565 Form Design Tips 567 Tackling Advanced Forms Techniques 570 Using the Tab Control 577 Using Dialog Boxes to Collect Information579 Designing a Form from Scratch 582 Chapter 20: Presenting Data with Access Reports 591 Introducing Reports 592 Creating a Report, from Beginning to End 596 Banded Report Design Concepts 614 Creating a Report from Scratch 620 Improving the Report’s Appearance 642 Chapter 21: Advanced Access Report Techniques 649 Grouping and Sorting Data 650 Formatting Data 662 Adding Data 680 Adding Even More Flexibility 682 Part VI: Access Programming Fundamentals 695 Chapter 22: Using Access Macros 697 An Introduction to Macros 698 Understanding Macro Security 702 Multi-Action Macros 706 Submacros 709 Conditions 713 Temporary Variables 716 Error Handling and Macro Debugging 721 Embedded Macros 727 Macros versus VBA Statements 729 Chapter 23: Using Access Data Macros 733 Introducing Data Macros 734 Understanding Table Events 735 Using the Macro Designer for Data Macros 738 Understanding the Action Catalog 740 Creating Your First Data Macro 743 Managing Macro Objects 747 Recognizing the Limitations of Data Macros 749 Chapter 24: Getting Started with Access VBA 751 Introducing Visual Basic for Applications 752 Understanding VBA Terminology 754 Starting with VBA Code Basics 755 Creating VBA Programs 755 Understanding VBA Branching Constructs 770 Working with Objects and Collections 780 Exploring the Visual Basic Editor 785 Chapter 25: Mastering VBA Data Types and Procedures 795 Using Variables 796 Working with Data Types 803 Understanding Subs and Functions824 Creating Functions 830 Simplifying Code with Named Arguments 836 Chapter 26: Understanding the Access Event Model 839 Programming Events 840 Identifying Common Events 843 Paying Attention to Event Sequence 852 Chapter 27: Debugging Your Access Applications 861 Organizing VBA Code 862 Testing Your Applications 863 Traditional Debugging Techniques 870 Using the Access Debugging Tools 876 Trapping Errors in Your Code 889 Part VII: Advanced Access Programming Techniques 895 Chapter 28: Accessing Data with VBA Code 897 Working with Data 897 Understanding ADO Objects 901 Understanding DAO Objects 914 Writing VBA Code to Update a Table 924 Chapter 29: Advanced Data Access with VBA 941 Adding an Unbound Combo Box to a Form to Find Data 941 Filtering a Form 949 Chapter 30: Customizing the Ribbon 959 The Ribbon Hierarchy 959 Editing the Default Ribbon 965 Working with the Quick Access Toolbar 968 Developing Custom Ribbons 971 Creating a Custom Ribbon 974 The Basic Ribbon XML 983 Adding Ribbon Controls 985 Attaching Ribbons to Forms and Reports 994 Removing the Ribbon Completely 996 Chapter 31: Preparing Your Access Application for Distribution 999 Defining the Current Database Options 1000 Developing the Application 1009 Polishing Your Application 1015 Bulletproofing an Application 1029 Securing the Environment 1040 Part VIII: Access and Windows SharePoint Services 1045 Chapter 32: Integrating Access with SharePoint 1047 Introducing SharePoint 1047 Understanding SharePoint Sites 1048 Sharing Data between Access and SharePoint 1051 Using SharePoint Templates 1060 Chapter 33: Deploying Access Applications to SharePoint 1063 Understanding Web Publishing with Access 1064 Examining the Limitations of Access Web Applications 1067 Publishing a Custom Access Application to SharePoint 1070 Index 1091

Read more less

Book SynopsisAccess is the most complex and intimidating application in Microsoft Office. This book helps you learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. It lets you discover the pre-built databases which can be customized to fit your needs.

Read more less

Book SynopsisA comprehensive reference to the updated and new features of Access 2013 As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex.Table of ContentsAcknowledgments ix Contents at a Glance xi Contents xiii Introduction xxxix Part I: Access Building Blocks 1 Chapter 1: An Introduction to Database Development 3 Chapter 2: Getting Started with Access 19 Part II: Understanding Access Tables 31 Chapter 3: Creating Access Tables 33 Chapter 4: Understanding Table Relationships 89 Chapter 5: Working with Access Tables 129 Chapter 6: Importing and Exporting Data 167 Chapter 7: Linking to External Data 201 Part III: Working with Access Queries 227 Chapter 8: Selecting Data with Queries 229 Chapter 9: Using Operators and Expressions in Access 261 Chapter 10: Going Beyond Select Queries 301 Part IV: Analyzing Data in Access 337 Chapter 11: Transforming Data in Access 339 Chapter 12: Working with Calculations and Dates 363 Chapter 13: Performing Conditional Analyses 389 Chapter 14: Fundamentals of Using Access SQL 407 Chapter 15: Subqueries and Domain Aggregate Functions 427 Chapter 16: Running Descriptive Statistics in Access 451 Part V: Working with Access Forms and Reports 469 Chapter 17: Creating Basic Access Forms 471 Chapter 18: Working with Data on Access Forms 509 Chapter 19: Working with Form Controls 541 Chapter 20: Presenting Data with Access Reports 575 Chapter 21: Advanced Access Report Techniques 631 Part VI: Access Programming Fundamentals 675 Chapter 22: Using Access Macros 677 Chapter 23: Getting Started with Access VBA 715 Chapter 24: Mastering VBA Data Types and Procedures 757 Chapter 25: Understanding the Access Event Model 799 Chapter 26: Debugging Your Access Applications 821 Part VII: Advanced Access Programming Techniques 853 Chapter 27: Accessing Data with VBA Code 855 Chapter 28: Advanced Data Access with VBA 897 Chapter 29: Integrating Access and SQL Server 915 Chapter 30: Customizing the Ribbon 957 Chapter 31: Preparing Your Access Application for Distribution 993 Part VIII: Access and Windows SharePoint Services 1037 Chapter 32: Understanding Windows SharePoint Services 1039 Chapter 33: Integrating Access with SharePoint 1045 Chapter 34: Understanding Access Services 1059 Chapter 35: Deploying Access Applications to SharePoint 1067 Chapter 36: Using Access Data Macros 1089 Part IX: Appendixes 1109 Appendix A: Access 2013 Specifications 1111 Appendix B: Optimizing Access Applications 1117 Appendix C: Understanding Query Performance and Database Corruption 1139 Appendix D: Function Reference for Data Analysts 1147 Index 1183

Read more less

Book SynopsisAccess in easy steps has an easy-to-follow style that will appeal to anyone who wants to get more from the Microsoft Access app. Whether you're using Access in the Office 365 suite or standalone Office product, you can use this guide to learn the key features and get more out of Access. Learn how to:Optimize database design for efficiencyCreate Tables to store dataUse handy templates and get a head startMake queries to extract specific dataProduce user-friendly Forms for data entry Explore basic SQL for advanced queriesConstruct informative Reports quicklyImport and export data to Excel and Word Securely share your well-designed database and reports that'll impress your colleagues! Access in easy steps contains separate chapters on the major features of the Access app. There are complete examples that demonstrate each aspect of Access, together with screenshots that illustrate the actual output. This book neatly demonstrates the important functions of Microsoft Access in a clear and concise manner, so you can get going quickly with this popular database application.Illustrated using Access 2019.

Read more less

Book SynopsisEn esta gua de ofimtica, encontrar las principales funciones de Access 2013: tras una descripcin del entorno, ver cmo crear una base de datos y gestionar los objetos que la componen. Aprender a crear tablas (y a relacionarlas), formularios e informes con o sin elementos de aplicacin y, posteriormente, descubrir cmo insertar y gestionar los diferentes tipos de controles (dependientes, independientes y calculados). A continuacin, se le mostrar cmo trabajar con los registros utilizando una hoja de datos o un formulario (introducir informacin, modificarla, ordenarla y filtrarla), y aprender a seleccionarlos, eliminarlos y actualizarlos a travs de consultas. Por ltimo, ver cmo exportar e importar datos y optimizar las operaciones realizadas en la base de datos mediante el uso de macros.

Read more less

Book SynopsisUnlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book's easy step-by-step instructions, you'll learn how to build and maintain a full-featured database and even turn it into a web app.

Read more less

Book SynopsisMany in developing countries lack access to health technologies. Why does this problem persist? What can be done to improve access, especially for the poor in poor countries? The authors offer a comprehensive analytical framework for access and examine six case studies to explain why some health technologies achieved more access than others.

Read more less

Book SynopsisEncuentre en este libro las principales funciones de Access 2007: descripcin del entorno; creacin de una base de datos y gestin de los objetos que la componen; creacin y relacin de las tablas; creacin de formularios e informes, as como gestin de los diferentes tipos de control; gestin de los registros a travs de una hoja de datos y de un formulario (introducir, modificar, seleccionar, filtrar); seleccin y supresin de registros con la ayuda de consultas; creacin de tablas dinmicas; creacin de tablas cruzadas dinmicas; creacin de grficos a partir de los datos de una tabla o de una tabla dinmica; creacin de macros; exportacin e importacin de los datos...

Read more less

Book SynopsisAprende cómodamente Access XP. Incluye Solucionarios, Glosario y Bibliografía. 10

Read more less

Book Synopsis

Read more less

Book SynopsisDrawing together the perspectives of social scientists, journalists, and ATI advocates, Brokering Access explores the policies and practices surrounding access to information in Canada, highlighting the struggle between the public’s desire for transparency and the government’s culture of secrecy.Table of ContentsForeword / Ann CavoukianIntroduction: On the Politics of Access to Information / Mike Larsen and Kevin WalbyPart 1: Access to Information, Past and Present1 Sustaining Secrecy: Executive Branch Resistance to Access to Information in Canada / Ann Rees2 Access Regimes: Provincial Freedom of Information Law across Canada / Gary DicksonPart 2: Behind Closed Doors -- Security and Information Control3 Flying the Secret Skies: Difficulties in Obtaining Data on Canadian Airport Security Screening Tests Following 9/11 / Jim Bronskill4 Access to Information in an Age of Intelligencized Governmentality / Willem de Lint and Reem Bahdi5 Accessing Dirty Data: Methodological Strategies for Social Problems Research / Yavar Hameed and Jeff MonaghanPart 3: Access to Information and Critical Research Strategies6 The Freedom of Information Act as a Methodological Tool: Suing the Government for Data / Matthew G. Yeager7 “He who controls the present, controls the past”: The Canadian Security State’s Imperfect Censorship under the Access to Information Act / Steve Hewitt8 Behind the Blue Line: Using ATI in Researching the Policing of Aboriginal Activism / Tia Dafnos9 Accessing the State of Imprisonment in Canada: Information Barriers and Negotiation Strategies/ Justin Piché10 Accessing Information on Streetscape Video Surveillance in Canada / Sean P. HierPart 4: Dispatches from the Fourth Estate -- Access to Information and Investigative Journalism11 Access, Administration, and Democratic Intent / Fred Vallance-Jones12 Access to Information: The Frustrations -- and the Hope / David McKie13 The Quest for Electronic Data: Where Alice Meets Monty Python Meets Colonel Jessep / Jim RankinPostscript / Suzanne LegaultIndex

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book SynopsisPaul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.Table of Contents 1 Manage databases Objective 1.1: Modify database structure Objective 1.2: Manage table relationships and keys Objective 1.3: Print and export data 2 Create and modify tables Objective 2.1: Create tables. Objective 2.2: Manage tables Objective 2.3: Manage table records Objective 2.4: Create and modify fields 3 Create and modify queries Objective 3.1: Create and run queries Objective 3.2: Modify queries 4 Modify forms in Layout view Objective 4.1: Configure form controls Objective 4.2: Format forms 5 Modify reports in Layout view Objective 5.1: Configure report controls Objective 5.2: Format reports

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisThe ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how. Coverage includes: Data Analysis in Access & the Basics of Access Beyond Select Queries Transforming Your Data with Access Working with Calculations and Dates Performing Conditional Analysis Adding Dimension with Subqueries and Domain Aggregate Functions Running Descriptive Statistics in Access Scheduling and Running Batch Analysis Leveraging VBA to Enhance Data Analysis<Table of ContentsIntroduction xxix Part I Fundamentals of Data Analysis in Access 1 Chapter 1 The Case for Data Analysis in Access 3 Chapter 2 Access Basics 13 Chapter 3 Beyond Select Queries 47 Part II Basic Analysis Techniques 87 Chapter 4 Transforming Your Data with Access 89 Chapter 5 Working with Calculations and Dates 113 Chapter 6 Performing Conditional Analysis 141 Part III Advanced Analysis Techniques 161 Chapter 7 Adding Dimension with Subqueries and Domain Aggregate Functions 163 Chapter 8 Running Descriptive Statistics in Access 189 Chapter 9 Scheduling and Running Batch Analysis 209 Chapter 10 Leveraging VBA to Enhance Data Analysis 243 Part IV Reports, Dashboards, and Visualization in Access 267 Chapter 11 Presenting Data with Access Reports 269 Chapter 12 Using Pivot Tables and Pivot Charts in Access 291 Chapter 13 Enhancing Queries and Reports with Visualizations 323 Part V Advanced Excel and Access Integration Techniques 345 Chapter 14 Getting Access Data into Excel 347 Chapter 15 Using VBA to Move Data between Excel and Access 365 Chapter 16 Exploring Excel and Access Automation 389 Chapter 17 Integrating Excel and Access with XML 423 Chapter 18 Integrating Excel and Other Office Applications 441 Part VI Appendixes 475 Appendix A Access VBA Fundamentals 477 Appendix B Understanding and Using SQL 489 Appendix C Query Performance, Database Corruption, and Other Thoughts 509 Appendix D Data Analyst’s Function Reference 521 Index 563

Read more less

Book SynopsisAt a time when the world's wealthiest nations struggle to make health care and medicine available to everyone, why do resource-constrained countries make costly commitments to universal health coverage and AIDS treatment after transitioning to democracy? Joseph Harris explores the dynamics that made landmark policies possible in Thailand and Brazil but which have led to prolonged struggle and contestation in South Africa. Drawing on firsthand accounts of the people wrestling with these issues, Achieving Access documents efforts to institutionalize universal healthcare and expand access to life-saving medicines in three major industrializing countries. In comparing two separate but related policy areas, Harris finds that democratization empowers elite professionals, such as doctors and lawyers, to advocate for universal health care and treatment for AIDS. Harris's analysis is situated at the intersection of sociology, political science, and public health and will speak Trade ReviewThrough his focus on professional movements at the domestic level, Harris makes new contributions to the literatures on the transnational AIDS movement, democratization and the medical profession's role in health policy.... The book is a major contribution to the study of professionals in (health) politics and timely given the ongoing struggle for universal coverage models in global health institutions. * Global Affairs *

Read more less

Book SynopsisAccess es el gestor de bases de datos de Microsoft y se integra dentro de la suite de programas Office. La versión 2013 de este excelente y completo programa no presenta apenas novedades aunque sí evidentes mejoras, mejoras que sin lugar a dudas los usuarios agradecerán, tanto aquellos que ya conocen la aplicación como los que se inician en su uso. Gracias a los 100 ejercicios prácticos que componen este libro, el lector podrá generar sus propias bases de datos incluyendo en ellas todos los objetos de que se componen, de manera que podrá sacar el máximo rendimiento a sus productos. Con este libro: Conocerá la renovada y mejorada vista Backstage, común a todos los programas de la suite Office Aprenderá a generar una base de datos a partir de cero Agregará paso a paso tablas, formularios e informes Generará consultas entre diferentes tablas Aprenderá a mantener sus bases de datos seguras y sin errores

Read more less

Book SynopsisHow reconsidering digital media and participatory cultures from the standpoint of disability allows for a full understanding of accessibility. While digital media can offer many opportunities for civic and cultural participation, this technology is not equally easy for everyone to use. Hardware, software, and cultural expectations combine to make some technologies an easier fit for some bodies than for others. A YouTube video without closed captions or a social network site that is incompatible with a screen reader can restrict the access of users who are hard of hearing or visually impaired. Often, people with disabilities require accommodation, assistive technologies, or other forms of aid to make digital media accessibleuseablefor them.Restricted Access investigates digital media accessibilitythe processes by which media is made usable by people with particular needsand argues for the necessity of conceptualizing access in a way that will enable greater particiTrade ReviewElizabeth Ellcessor’s inspiring book Restricted Access: Media, Disability, and the Politics of Participation lies at the intersection of disability, technology, culture, and bodies, and it raises new questions in these intersecting research fields. It is a timely and welcome work that fills in the research gap between disability studies and media studies. -- International Journal of CommunicationEllcessor calls for cultural collaboration that does not exclude disability culture or attempt to erase disability culture in the name of universal design. * Choice *Restricted Accesstransforms our understanding of what 'access' means in an age when so much writing on new media fetishizes participation.Elizabeth Ellcessor reveals the ways in which ability, culture, and technology are all entangled in questions of accessibility. Timely and sophisticated, Ellcessors book is a major advance in media studies and disability studies, and will also be of great interest to scholars in policy. -- Jonathan Sterne,author of MP3: The Meaning of a Format

Read more less

Book SynopsisThis book is an interdisciplinary collection of twenty-four essays which critically examine contemporary exhibitions and artistic practices that focus on conceptual and creative aspects of access.Oftentimes exhibitions tack on access once the artwork has already been executed and ready to be installed in the museum or gallery. But what if the artists were to ponder access as an integral and critical part of their artwork? Can access be creative and experimental? And furthermore, can the curator also fold access into their practice, while working collaboratively with artists, considering it as a theoretical and practical generative force that seeks to make an exhibition more engaging for a wider diversity of audiences? This volume includes essays by a growing number of artists, curators, and scholars who ponder these ideas of ad-hoc, experimental and underground approaches within exhibition-making and artistic practices. It considers how, through these nascent exhibition model

Read more less

Book SynopsisWritten by experts in the field, this book provides an overview of all forms of broadband subscriber access networks and technology, including fiber optics, DSL for phone lines, DOCSIS for coax, power line carrier, and wireless. Each technology is described in depth, with a discussion of key concepts, historical development, and industry standards. The book contains comprehensive coverage of all broadband access technologies, with a section each devoted to fiber-based technologies, non-fiber wired technologies, and wireless technologies. The four co-authors' breadth of knowledge is featured in the chapters comparing the relative strengths, weaknesses, and prognosis for the competing technologies. Key Features: Covers the physical and medium access layers (OSI Layer 1 and 2), with emphasis on access transmission technology Compares and contrasts all recent and emerging wired and wireless standards for broadband access in a single reference IllustTable of ContentsAbout the Authors xv Acknowledgments xvii List of Abbreviations and Acronyms xix 1 Introduction to Broadband Access Networks and Technologies 1 1.1 Introduction 1 1.2 A Brief History of the Access Network 2 1.3 Digital Subscriber Lines (DSL) 3 1.3.1 DSL Technologies and Their Evolution 3 1.3.2 DSL System Technologies 5 1.4 Hybrid Fiber-Coaxial Cable (HFC) 5 1.5 Power Line Communications (PLC) 6 1.6 Fiber in the Loop (FITL) 7 1.7 Wireless Broadband Access 10 1.8 Direct Point-to-Point Connections 12 Appendix 1.A: Voiceband Modems 12 2 Introduction to Fiber Optic Broadband Access Networks and Technologies 15 2.1 Introduction 15 2.2 A Brief History of Fiber in the Loop (FITL) 16 2.3 Introduction to PON Systems 18 2.3.1 PON System Overview 18 2.3.2 PON Protocol Evolution 19 2.4 FITL Technology Considerations 21 2.4.1 Optical Components 21 2.4.2 Powering the Loop 22 2.4.3 System Power Savings 23 2.4.4 PON Reach Extension 25 2.5 Introduction to PON Network Protection 30 2.5.1 Background on Network Protection 31 2.5.2 PON Facility Protection 31 2.5.3 OLT Function Protection 35 2.5.4 ONU Protection 40 2.5.5 Conclusions Regarding Protection 42 2.6 Conclusions 42 Appendix 2.A: Subscriber Power Considerations 43 References 43 Further Reading 43 3 IEEE Passive Optical Networks 45 3.1 Introduction 45 3.2 IEEE 802.3ah Ethernet-based PON (EPON) 45 3.2.1 EPON Physical Layer 46 3.2.2 Signal Formats 46 3.2.3 MAC Protocol 48 3.2.4 Encryption and Security 49 3.2.5 Forward Error Correction (FEC) 50 3.2.6 ONU Discovery and Activation 51 3.2.7 ONU Ranging Mechanism 52 3.2.8 EPON OAM 52 3.2.9 Dynamic Bandwidth Assignment (DBA) 53 3.3 IEEE 802.3av 10Gbit/s Ethernet-based PON (10G EPON) 54 3.3.1 10G EPON Physical Layer 54 3.3.2 Signal Format 58 3.3.3 MAC Protocol 59 3.3.4 Forward Error Correction 59 3.3.5 ONU Discovery and Activation 61 3.3.6 ONU Ranging Mechanism 61 3.3.7 10G EPON OAM 61 3.3.8 Dynamic Bandwidth Allocation 61 3.4 Summary Comparison of EPON and 10G EPON 61 3.5 Transport of Timing and Synchronization over EPON and 10G EPON 61 3.6 Overview of the IEEE 1904.1 Service Interoperability in Ethernet Passive Optical Networks (SIEPON) 63 3.6.1 SIEPON MAC Functional Blocks 65 3.6.2 VLAN Support 67 3.6.3 Multicast Service 67 3.6.4 SIEPON Service Management 67 3.6.5 Performance Monitoring and Verification 69 3.6.6 SIEPON Service Availability 70 3.6.7 SIEPON Optical Link Protection 70 3.6.8 SIEPON Power Savings 70 3.6.9 SIEPON Security Mechanisms 71 3.6.10 SIEPON Management 71 3.7 ITU-T G.9801 Ethernet Passive Optical Networks using OMCI 71 3.8 Conclusions 71 Appendix 3.A: 64B/66B Line Code 72 References 75 Further Readings 75 4 ITU-T/FSAN PON Protocols 77 4.1 Introduction 77 4.2 ITU-T G.983 Series B-PON (Broadband PON) 78 4.3 ITU-T G.984 Series G-PON (Gigabit-capable PON) 79 4.3.1 G-PON Physical Layer 79 4.3.2 G-PON Frame Formats 81 4.3.3 G-PON Encapsulation Method (GEM) 87 4.3.4 G-PON Multiplexing 91 4.3.5 Encryption and Security 92 4.3.6 Forward Error Correction 92 4.3.7 Protection Switching 94 4.3.8 ONU Activation 94 4.3.9 Ranging Mechanism 95 4.3.10 Dynamic Bandwidth Assignment (DBA) 96 4.3.11 OAM Communication 97 4.3.12 Time of Day Distribution 97 4.3.13 G-PON Enhancements 101 4.4 Next Generation PON (NG-PON) 101 4.4.1 Introduction to G.987 series XG-PON (NG-PON1 – 10Gbit-capable PON) 102 4.4.2 XG-PON Physical Layer 102 4.4.3 XG-PON Transmission Convergence Layer and Frame Structures 105 4.4.4 Forward Error Correction 108 4.4.5 XG-PON Encapsulation Method (XGEM) 109 4.4.6 XG-PON Management 110 4.4.7 XG-PON Security 110 4.4.8 NG-PON2 40 Gbit/s Capable PON 110 Appendix 4.A: Summary Comparison of EPON and G-PON 112 References 113 Further Readings 114 5 Optical Domain PON Technologies 115 5.1 Introduction 115 5.2 WDMA (Wavelength Division Multiple Access) PON 115 5.2.1 Overview 115 5.2.2 Technologies 116 5.2.3 Applications 120 5.3 CDMA PON 120 5.4 Point-to-Point Ethernet 122 5.5 Subcarrier Multiplexing and OFDM 123 5.5.1 Introduction 123 5.5.2 OFDMA PON 123 5.6 Conclusions 125 References 126 Further Readings 126 6 Hybrid Fiber Access Technologies 127 6.1 Introduction and Background 127 6.2 Evolution of DOCSIS (Data-Over-Cable Service Interface Specification) to Passive Optical Networks 127 6.2.1 Introduction and Background 127 6.2.2 DOCSIS Provisioning of EPON (DPoE) 128 6.2.3 Conclusions for DPoE 135 6.3 Radio and Radio Frequency Signals over Fiber 135 6.3.1 Radio over Fiber (RoF) 136 6.3.2 Baseband Digital Radio Fiber Interfaces 136 6.3.3 Radio Frequency over Glass (RFoG) 138 6.4 IEEE 802.3bn Ethernet Protocol over Coaxial Cable (EPoC) 140 6.5 Conclusions 140 References 141 Further Readings 141 7 DSL Technology – Broadband via Telephone Lines 143 7.1 Introduction to DSL 143 7.2 DSL Compared to Other Access Technologies 144 7.2.1 Security and Reliability 144 7.2.2 Point-to-Point Versus Shared Access 145 7.2.3 Common Facilities for Voice and DSL 146 7.2.4 Bit-rate Capacity 146 7.2.5 Hybrid Access 146 7.2.6 Future Trends for DSL Access 146 7.3 DSL Overview 147 7.3.1 Voice-band Modems 147 7.3.2 The DSL Concept 147 7.3.3 DSL Terminology 149 7.3.4 Introduction to DSL Types 151 7.3.5 DSL Performance Improvement, Repeaters, and Bonding 152 7.3.6 Splitters and Filters for Voice and Data 153 7.3.7 Other Ways to Convey Voice and Data 155 7.4 Transmission Channel and Impairments 156 7.4.1 Signal Attenuation 158 7.4.2 Bridged Taps 159 7.4.3 Loading Coils 162 7.4.4 Return Loss and Insertion Loss 163 7.4.5 Balance 163 7.4.6 Intersymbol Interference (ISI) 163 7.4.7 Noise 164 7.4.8 Transmission Channel Models 170 7.5 DSL Transmission Techniques 170 7.5.1 Duplexing 170 7.5.2 Channel Equalization and Related Techniques 171 7.5.3 Coding 172 References 174 Further Readings 174 8 The Family of DSL Technologies 175 8.1 ADSL 175 8.1.1 G.lite 176 8.1.2 ADSL2 and ADSL2plus 177 8.1.3 ADSL1 and ADSL2plus Performance 178 8.2 VDSL 179 8.2.1 VDSL2 181 8.2.2 VDSL2 Performance 182 8.3 Basic Rate Interface ISDN 184 8.4 HDSL, HDSL2, and HDLS4 185 8.5 SHDSL 185 8.6 G.fast (FTTC DSL) 187 Reference 188 9 Advanced DSL Techniques and Home Networking 189 9.1 Repeaters and Bonding 189 9.2 Dynamic Spectrum Management (DSM) 190 9.3 Vectored Transmission 190 9.4 Home Networking 195 References 195 Further Readings 195 10 DSL Standards 197 10.1 Spectrum Management – ANSI T1.417 197 10.2 G.hs – ITU-T Rec. G.994.1 199 10.3 PLOAM – ITU-T Rec. G.997.1 200 10.4 G.bond – ITU-T Recs. G.998.1, G.998.2, and G.998.3 201 10.5 G.test – ITU-T Rec. G.996.1 202 10.6 G.lt – ITU-T Rec. G.996.2 202 10.7 Broadband Forum DSL Testing Specifications 203 10.8 Broadband Forum TR-069 – Remote Management of CPE 204 References 205 11 The DOCSIS (Data-Over-Cable Service Interface Specification) Protocol 207 11.1 General Introduction 207 11.2 Introduction to MSO Networks 207 11.3 Background on Hybrid Fiber Coax (HFC) Networks 208 11.4 Introduction to DOCSIS 210 11.5 DOCSIS Network Elements 210 11.5.1 CMTS (Cable Modem Terminating System) 211 11.5.2 CM (Cable Modem) 212 11.5.3 FN (Fiber Node) 213 11.5.4 RF Combiner Shelf 213 11.6 Brief History of the DOCSIS Protocol Evolution 213 11.6.1 DOCSIS 1.0 214 11.6.2 DOCSIS 1.1 214 11.6.3 DOCSIS 2.0 214 11.6.4 DOCSIS 3.0 215 11.6.5 Regional History and Considerations 215 11.7 DOCSIS Physical Layer 216 11.7.1 DOCSIS Downstream Transmission 216 11.7.2 DOCSIS Upstream Transmission 218 11.8 Synchronization and Ranging 222 11.8.1 Synchronization 223 11.8.2 Ranging 224 11.9 DOCSIS MAC Sub-Layer 226 11.9.1 Downstream MAC 227 11.9.2 Upstream MAC 228 11.9.3 MAC Management Messages 232 11.9.4 MAC Parameters 233 11.10 CM Provisioning 239 11.11 Security 240 11.12 Introduction to Companion Protocols 242 11.12.1 The PacketCableTM Protocol 242 11.12.2 The OpenCableTM Protocol 242 11.12.3 PacketCable Multimedia (PCMM) 242 11.13 Conclusions 243 References 243 Further Readings 243 12 Broadband in Gas Line (BIG) 245 12.1 Introduction to BIG 245 12.2 Proposed Technology 245 12.3 Potential Drawbacks for BIG 245 12.4 Broadband Sewage Line 247 Reference 247 13 Power Line Communications 249 13.1 Introduction 249 13.2 The Early Years 250 13.3 Narrowband PLC 251 13.3.1 Overview of NB-PLC Standards 252 13.4 Broadband PLC 253 13.4.1 Overview of BB-PLC Standards 254 13.5 Power Grid Topologies 257 13.5.1 Outdoor Topologies: HV, MV, and LV 257 13.5.2 Indoor Topologies 258 13.6 Outdoor and In-Home Channel Characterization 261 13.6.1 Characteristics of the HV Power Line Channel 262 13.6.2 Characteristics of MV Power Line Channel 262 13.6.3 Characteristics of LV Power Line Channel 263 13.6.4 Power Line Noise Characteristics 263 13.7 Power Line Channel Modeling 269 13.7.1 Recent Results on the Modeling of Wireline Channels: Towards a Unified Framework 271 13.8 The IEEE 1901 Broadband over Power Line Standard 273 13.8.1 Overview of Technical Features 273 13.8.2 The MAC and the Two PLCPs 274 13.8.3 Access-Specific Features 275 13.9 PLC and the Smart Grid 277 13.9.1 PLC for MV 279 13.9.2 PLC for LV 279 13.10 Conclusions 283 References 284 Further Reading 285 14 Wireless Broadband Access: Air Interface Fundamentals 287 14.1 Introduction 287 14.2 Duplexing Techniques 287 14.2.1 Frequency-Division Duplex 288 14.2.2 Time-Division Duplex 288 14.3 Physical Layer Concepts 289 14.3.1 The Wireless Channel 289 14.3.2 Diversity 290 14.3.3 Channel Coding 291 14.3.4 Interleaving 291 14.3.5 Multi-Antenna Techniques and Multiple-Input Multiple-Output (MIMO) 291 14.4 Access Technology Concepts 295 14.4.1 Frequency Division Multiple Access (FDMA) 295 14.4.2 Time Division Multiple Access (TDMA) 295 14.4.3 Code Division Multiple Access (CDMA) 295 14.4.4 Orthogonal Frequency Division Multiplexing (OFDM) 297 14.4.5 MAC Protocols 299 14.5 Cross-Layer Algorithms 300 14.5.1 Link Adaptation 300 14.5.2 Channel-Dependent Scheduling 300 14.5.3 Automatic Repeat Request (ARQ) and Hybrid ARQ (HARQ) 302 14.6 Example Application: Satellite Broadband Access 303 14.7 Summary 303 Further Reading 304 15 WiFi: IEEE 802.11 Wireless LAN 305 15.1 Introduction 305 15.2 Technology Basics 306 15.2.1 System Overview 306 15.2.2 MAC Layer 308 15.2.3 Physical Layer 311 15.3 Technology Evolution 312 15.3.1 802.11 b 312 15.3.2 802.11 a/g 313 15.3.3 802.11 n 314 15.3.4 802.11 ac 316 15.4 WLAN Network Architecture 318 15.5 TV White Space and 802.11 af 320 15.6 Summary 320 Further Readings 321 16 UMTS: W-CDMA and HSPA 323 16.1 Introduction 323 16.2 Technology Basics 324 16.2.1 Network Architecture 324 16.2.2 Protocol Architecture 325 16.2.3 Physical Layer (L1) 327 16.2.4 Layer-2 334 16.2.5 Radio Resource Control (RRC) 336 16.3 UMTS Technology Evolution 338 16.3.1 Release 99 338 16.3.2 Release 5: High-Speed Downlink Packet Access (HSDPA) 339 16.3.3 Release 6: Enhanced Uplink 343 16.3.4 Release 7 347 16.3.5 Release 8 and Beyond 348 16.4 CDMA2000 350 16.5 Summary 351 Further Readings 352 17 Fourth Generation Systems: LTE and LTE-Advanced 353 17.1 Introduction 353 17.1.1 LTE Standardization 353 17.1.2 LTE Requirements 354 17.2 Release 8: The Basics of LTE 355 17.2.1 Network Architecture 355 17.2.2 PDN Connectivity, Bearers, and QoS Architecture 358 17.2.3 Protocol Architecture 360 17.2.4 Layer-1: The Physical Layer 361 17.2.5 Layer-2 and Cross-Layer Algorithms 370 17.2.6 Layer-3: Radio Resource Control (RRC) 380 17.3 Release 9: eMBMS and SON 383 17.3.1 Evolved Multimedia Broadcast Multicast Service (eMBMS) 384 17.3.2 Self-Organizing Networks (SON) 386 17.4 Release 10: LTE-Advanced 386 17.4.1 Carrier Aggregation 388 17.4.2 Heterogeneous Networks with Small Cells 391 17.5 Future of LTE-Advanced: Release 11 and Beyond 395 17.5.1 Cooperative Multi-Point (CoMP) 396 17.5.2 Release 12 and the Future of LTE 398 17.6 IEEE 802.16 and WiMAX Systems 399 17.7 Summary 400 Further Readings 402 18 Conclusions Regarding Broadband Access Networks and Technologies 403 Index 407

Read more less

Book SynopsisAt a time when the world's wealthiest nations struggle to make health care and medicine available to everyone, why do resource-constrained countries make costly commitments to universal health coverage and AIDS treatment after transitioning to democracy? Joseph Harris explores the dynamics that made landmark policies possible in Thailand and Brazil but which have led to prolonged struggle and contestation in South Africa. Drawing on firsthand accounts of the people wrestling with these issues, Achieving Access documents efforts to institutionalize universal healthcare and expand access to life-saving medicines in three major industrializing countries. In comparing two separate but related policy areas, Harris finds that democratization empowers elite professionals, such as doctors and lawyers, to advocate for universal health care and treatment for AIDS. Harris's analysis is situated at the intersection of sociology, political science, and public health and will speak Trade ReviewThrough his focus on professional movements at the domestic level, Harris makes new contributions to the literatures on the transnational AIDS movement, democratization and the medical profession's role in health policy.... The book is a major contribution to the study of professionals in (health) politics and timely given the ongoing struggle for universal coverage models in global health institutions. * Global Affairs *

Read more less

Book SynopsisHow reconsidering digital media and participatory cultures from the standpoint of disability allows for a full understanding of accessibility. While digital media can offer many opportunities for civic and cultural participation, this technology is not equally easy for everyone to use. Hardware, software, and cultural expectations combine to make some technologies an easier fit for some bodies than for others. A YouTube video without closed captions or a social network site that is incompatible with a screen reader can restrict the access of users who are hard of hearing or visually impaired. Often, people with disabilities require accommodation, assistive technologies, or other forms of aid to make digital media accessibleuseablefor them.Restricted Access investigates digital media accessibilitythe processes by which media is made usable by people with particular needsand argues for the necessity of conceptualizing access in a way that will enable greater particiTrade ReviewElizabeth Ellcessor’s inspiring book Restricted Access: Media, Disability, and the Politics of Participation lies at the intersection of disability, technology, culture, and bodies, and it raises new questions in these intersecting research fields. It is a timely and welcome work that fills in the research gap between disability studies and media studies. -- International Journal of CommunicationEllcessor calls for cultural collaboration that does not exclude disability culture or attempt to erase disability culture in the name of universal design. * Choice *Restricted Accesstransforms our understanding of what 'access' means in an age when so much writing on new media fetishizes participation.Elizabeth Ellcessor reveals the ways in which ability, culture, and technology are all entangled in questions of accessibility. Timely and sophisticated, Ellcessors book is a major advance in media studies and disability studies, and will also be of great interest to scholars in policy. -- Jonathan Sterne,author of MP3: The Meaning of a Format

Read more less

Book SynopsisA powerful and urgent call to action: to improve our lives and our societies, we must demand open access to data for all. Information is power, and the time is now for digital liberation. Access Rules mounts a strong and hopeful argument for how informational tools at present in the hands of a few could instead become empowering machines for everyone. By forcing data-hoarding companies to open access to their data, we can reinvigorate both our economy and our society. Authors Viktor Mayer-Schönberger and Thomas Ramge contend that if we disrupt monopoly power and create a level playing field, digital innovations can emerge to benefit us all. Over the past twenty years, Big Tech has managed to centralize the most relevant data on their servers, as data has become the most important raw material for innovation. However, dominant oligopolists like Facebook, Amazon, and Google, in contrast with their reputation as digital pioneers, are actually slowing down innovation and progress by withholding data for the benefit of their shareholdersat the expense of customers, the economy, and society. As Access Rules compellingly argues, ultimately it is up to us to force information giants, wherever they are located, to open their treasure troves of data to others. In order for us to limit global warming, contain a virus like COVID-19, or successfully fight poverty, everyoneincluding citizens and scientists, start-ups and established companies, as well as the public sector and NGOsmust have access to data. When everyone has access to the informational riches of the data age, the nature of digital power will change. Information technology will find its way back to its original purpose: empowering all of us to use information so we can thrive as individuals and as societies.Trade Review"This book. . . .offered insights, regardless of the reader’s familiarity levels with technology policy. Access Rules offers concrete solutions and poses critical open-ended questions. We live in an increasingly digital age, and this book is truly a must-read for all policy students and policymakers." * Georgetown Public Policy Review *Table of ContentsContents 1. The Power of Information 2. Data Alchemy 3. Schumpeter’s Nightmare 4. Data Capitalism 5. Might and Machines 6. Access Rules 7. Open Data Reloaded 8. The End of Data Colonialism Acknowledgments Further Readings and References Index

Read more less

Book SynopsisThis book will help readers take the steps needed to set their museums on a path to being welcoming and accessible. It features a variety of actions that museums, regardless of their size or budget, can implement.Table of ContentsDedicationAcknowledgementsPrefaceChapter 1: Different, Not Less: Essential BackgroundChapter 2: Won’t You be our Neighbor: Partnerships, Part IChapter 3: Nothing About Us Without Us: Partnerships, Part II Chapter 4: Environmental Access: The ADA and Inclusive DesignChapter 5: Not an Afterthought: Cognitive AccessChapter 6: A Spectrum of Experience: Sensory AccessChapter 7: A Whole New World Wide Web: Digital AccessChapter 8: Dollars and Sense: Financial AccessChapter 9: A Word About Words: CommunicationsChapter 10: If You Build It They Will Come: Inclusive Exhibitions and Programming Chapter 11: All Aboard: Professional Development and Staff TrainingChapter 12: You Are on the Road to WelcomeAppendix A: Resources to Continue Your JourneyAppendix B: Questions to Get Started with Museum AccessibilityAppendix C: GlossaryBibliographyAbout the Authors

Read more less

Book SynopsisOur buildings and environments should be inclusive to all, but how can we assess this? The Access Audit Handbook is an indispensable tool for auditing the accessibility of buildings and services. This book offers straightforward advice about undertaking access audits and explains how they make buildings, environments and services more inclusive. Following the audit, the book explains how each of the various report formats works best to communicate recommendations in the content of current legislation, funding requirements and best practice in building management. Well established as the best resource for conducting access audits, the third edition of The Access Audit Handbook is fully up to date with the latest legal and technical standards as well as developments in equipment and building maintenance. Featuring advice on: - Commissioning an access audit- Audit methodology- Making recommendations- Report writing. The practical guidance is supported by case studies, worked examples and checklists. Table of Contents Introduction1.0 Access audits1.1 What is an access audit?1.2 Access audits and the Equality Act 20101.3 Access audits, access statements and the planning and building regulations process1.4 What follows an access audit?1.5 Commissioning an access audit2.0 Audit methodology2.1 The site survey2.2 What do you audit?2.3 Survey equipment2.4 Observational assessment2.5 Data recording2.6 User participation2.7 Building management3.0 Report writing3.1 A communication tool3.2 Report formats3.3 Establishing the legislative context3.4 Criteria for assessment and design guidance3.5 Making recommendations3.6 Priorities and categories3.7 Cost banding4.0 Case Studies 4.1 Almeida Theatre4.2 Penguin Beach , ZSL 4.3 Christ Church4.4 Guildhall, City of London 4.5 Mullard Space Science Laboratory, University College London4.6 Hebdon Bridge Town Hall 5.0 Access audit checklists6.0 Appendices6.1 Organisations6.2 PublicationsIndexImage Credits

Read more less

Book Synopsis

Read more less

Book SynopsisA guide to a holistic approach to healthcare measurement aimed at improving access and outcomes Healthcare System Access is an important resource that bridges two areas of researchaccess modeling and healthcare system engineering. The book's mathematical modeling approach highlights fundamental approaches on measurement of and inference on healthcare access. This mathematical modeling facilitates translating data into knowledge in order to make data-driven estimates and projections about parameters, patterns, and trends in the system. The complementary engineering approach uses estimates and projections about the system to better inform efforts to design systems that will yield better outcomes. The authora noted expert on the topicoffers an in-depth exploration of the concepts of systematic disparities, reviews measures for systematic disparities, and presents a statistical framework for making inference on disparities with application to disparities in aTable of ContentsPreface vii 1 Introduction 1 2 A Multidimensional Framework for Measuring Access 13 3 Disparities in Healthcare Access 61 4 Linking Access to Health Outcomes 99 5 Healthcare Interventions for Improving Access 137 6 Data Analytics 195 Index 249

Read more less

Book Synopsis

Read more less

Book SynopsisSQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code. Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

Read more less

Book SynopsisThe Access Audit Handbook is an invaluable tool for auditing the accessibility of buildings and services, and for writing reports in appropriate formats in the content of current legislation, funding requirements and best practice in building management. This book offers straightforward advice about undertaking access audits and the various report formats to best communicate recommendations. The practical guidance is supported by a range of up to date and informative case studies, and a new, authoritative worked example of a successful report based on a real-life access audit. An updated checklist for audits is included in the appendix at the back of the book. Also new to the second edition are updates to the legislation chapter – including guidance on the Equality Act, the Building Regulations Part M 2013, and BS8300 – and an additional section covering the current planning policy framework, community engagement and user involvement. Designed to complement the best-selling and recently updated Designing for Accessibility, the new Access Audit Handbook is an indispensable tool for all those involved in access reporting for buildings.Table of Contents1 Introduction 2 Access Audits 3 Audit Methodology 4 Report Writing 5 Access Audit Extracts 6 Case Study – Hebden Bridge Town Hall 7 Access Audit Checklists

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book Synopsis** PRE-ORDER LENNY HENRY''S NEW AUTOBIOGRAPHY RISING TO THE SURFACE NOW ** Sir Lenny Henry rang up the Office for National Statistics to confirm something he'd been thinking about for a long time. They told him that only 29.5% of the United Kingdom's population is made up of white, heterosexual, able-bodied men; so, he wonders, why do they still make up the vast majority of people we see in our media?Joining forces with the former Chair of the Royal Television Society's Diversity Committee Marcus Ryder, he draws on decades of experience to reveal why recent efforts to diversify media have been thus far ineffective, and why they are simply not enough. With wit, humour and unflinching gravitas they analyse the flaws of current diversity initiatives, point out the structural and financial imbalances working against the cause, and provide clear solutions to get the media industry back on track.Access All Areas is an urgent, actionable manifesto that

Read more less

Book SynopsisComprehensive reference to all aspects of current and next generation broadband optical access networks. Presents the evolution of optical access networks including reach extension, bandwidth enhancement and service overlay. Discusses the convergence of optical and wireless technologies for broadband access.Table of ContentsFOREWORD. PREFACE. ACKNOWLEDGMENTS. 1 BROADBAND ACCESS TECHNOLOGIES: AN OVERVIEW. 1.1 Communication Networks. 1.2 Access Technologies. 1.2.1 Last-Mile Bottleneck. 1.2.2 Access Technologies Compared. 1.3 Digital Subscriber Line. 1.3.1 DSL Standards. 1.3.2 Modulation Methods. 1.3.3 Voice over DSL. 1.4 Hybrid Fiber Coax. 1.4.1 Cable Modem. 1.4.2 DOCSIS. 1.5 Optical Access Networks. 1.5.1 Passive Optical Networks. 1.5.2 PON Standard Development. 1.5.3 WDM PONs. 1.5.4 Other Types of Optical Access Networks. 1.6 Broadband over Power Lines. 1.6.1 Power-Line Communications. 1.6.2 BPL Modem. 1.6.3 Challenges in BPL. 1.7 Wireless Access Technologies. 1.7.1 Wi-Fi Mesh Networks. 1.7.2 WiMAX Access Networks. 1.7.3 Cellular Networks. 1.7.4 Satellite Systems. 1.7.5 LMDS and MMDS Systems. 1.8 Broadband Services and Emerging Technologies. 1.8.1 Broadband Access Services. 1.8.2 Emerging Technologies. 1.9 Summary. References. 2 OPTICAL COMMUNICATIONS: COMPONENTS AND SYSTEMS. 2.1 Optical Fibers. 2.1.1 Fiber Structure. 2.1.2 Fiber Mode. 2.1.3 Fiber Loss. 2.1.4 Fiber Dispersion. 2.1.5 Nonlinear Effects. 2.1.6 Light-Wave Propagation in Optical Fibers. 2.2 Optical Transmitters. 2.2.1 Semiconductor Lasers. 2.2.2 Optical Modulators. 2.2.3 Transmitter Design. 2.3 Optical Receivers. 2.3.1 Photodetectors. 2.3.2 Optical Receiver Design. 2.4 Optical Amplifiers. 2.4.1 Rare-Earth-Doped Fiber Amplifiers. 2.4.2 Semiconductor Optical Amplifiers. 2.4.3 Raman Amplifiers. 2.5 Passive Optical Components. 2.5.1 Directional Couplers. 2.5.2 Optical Filters. 2.6 System Design and Analysis. 2.6.1 Receiver Sensitivity. 2.6.2 Power Budget. 2.6.3 Dispersion Limit. 2.7 Optical Transceiver Design for TDM PONs. 2.7.1 Burst-Mode Optical Transmission. 2.7.2 Colorless ONUs. 2.8 Summary. References. 3 PASSIVE OPTICAL NETWORKS: ARCHITECTURES AND PROTOCOLS. 3.1 PON Architectures. 3.1.1 Network Dimensioning and Bandwidth. 3.1.2 Power Budget. 3.1.3 Burst-Mode Operation. 3.1.4 PON Packet Format and Encapsulation. 3.1.5 Dynamic Bandwidth Allocation, Ranging, and Discovery. 3.1.6 Reliability and Security Concerns. 3.2 PON Standards History and Deployment. 3.2.1 Brief Developmental History. 3.2.2 FTTx Deployments. 3.3 Broadband PON. 3.3.1 BPON Architecture. 3.3.2 BPON Protocol and Service. 3.3.3 BPON Transmission Convergence Layer. 3.3.4 BPON Dynamic Bandwidth Allocation. 3.3.5 Other ITU-T G.983.x Recommendations. 3.4 Gigabit-Capable PON. 3.4.1 GPON Physical Medium–Dependent Layer. 3.4.2 GPON Transmission Convergence Layer. 3.4.3 Recent G.984 Series Standards, Revisions, and Amendments. 3.5 Ethernet PON. 3.5.1 EPON Architecture. 3.5.2 EPON Point-to-Multipoint MAC Control. 3.5.3 Open Implementations in EPON. 3.5.4 Unresolved Security Weaknesses. 3.6 IEEE 802.av-2009 10GEPON Standard. 3.6.1 10GEPON PMD Architecture. 3.6.2 10GEPON MAC Modifications. 3.6.3 10GEPON Coexistence Options. 3.7 Next-Generation Optical Access System Development in the Standards. 3.7.1 FSAN NGA Road Map. 3.7.2 Energy Efficiency. 3.7.3 Other Worldwide Development. 3.8 Summary. References. 4 NEXT-GENERATION BROADBAND OPTICAL ACCESS NETWORKS. 4.1 TDM-PON Evolution. 4.1.1 EPON Bandwidth Enhancements. 4.1.2 GPON Bandwidth Enhancements. 4.1.3 Line Rate Enhancements Research. 4.2 WDM-PON Components and Network Architectures. 4.2.1 Colorless ONUs. 4.2.2 Tunable Lasers and Receivers. 4.2.3 Spectrum-Sliced Broadband Light Sources. 4.2.4 Injection-Locked FP Lasers. 4.2.5 Centralized Light Sources with RSOAs. 4.2.6 Multimode Fiber. 4.3 Hybrid TDM/WDM-PON. 4.3.1 TDM-PON to WDM-PON Evolution. 4.3.2 Hybrid Tree Topology Evolution. 4.3.3 Tree to Ring Topology Evolution. 4.4 WDM-PON Protocols and Scheduling Algorithms. 4.4.1 MAC Protocols. 4.4.2 Scheduling Algorithms. 4.5 Summary. References. 5 HYBRID OPTICAL WIRELESS ACCESS NETWORKS. 5.1 Wireless Access Technologies. 5.1.1 IEEE 802.16 WiMAX. 5.1.2 Wireless Mesh Networks. 5.2 Hybrid Optical–Wireless Access Network Architecture. 5.2.1 Leveraging TDM-PON for Smooth Upgrade of Hierarchical Wireless Access Networks. 5.2.2 Upgrading Path. 5.2.3 Reconfigurable Optical Backhaul Architecture. 5.3 Integrated Routing Algorithm for Hybrid Access Networks. 5.3.1 Simulation Results and Performance Analysis. 5.4 Summary. References. INDEX.

Read more less

Book SynopsisSince the early 20th century, American academic libraries have collected and championed rare and unique non-circulating materials now referred to as special collections. Because of the rarity and value of these materials, they are handled differently than materials in other parts of academic library collections. Thus, a different set of access policies and procedures, as well as specialized staff, have been employed. This book provides a thorough exploration of access, which is a cornerstone of the library profession. It looks at how practitioners' perceptions of access to special collections have changed from the formative period of the 1930s to today. Using a grounded theory approach on datasets comprised of LIS literature and interviews of special collections professionals with between 5 and 50 years of experience, two conceptual models developed.The two conceptual models are: Aspects of Access, which defines ten components that contribute to access goals: Diversity, Documentation, Engagement, Preservation, Protection, Provision, Readers, Spaces, Stewardship, and Technology. A historical overview sets the stage for in-depth discussion of each aspect. Gatekeeping Model of Access, which applies gatekeeping theory to chart how the Aspects of Access support or hinder the connection of readers to collection materials. An exploration of access through the lens of special collections is especially meaningful because of the tension between the principles of preservation and access within the special collections community. This project is also significant as the library profession explores how representation of diversity within collections and the profession impacts readers. Exploring how we think about access should be part of these ongoing conversations.

Read more less

Book SynopsisGet the scoope on how to use VBA to create more powerful Access databases and applications.Table of ContentsIntroduction 1 Part I: Introducing VBA Programming 7 Chapter 1: Where VBA Fits In 9 Chapter 2: Your VBA Toolkit 21 Chapter 3: Jumpstart: Creating a Simple VBA Program 35 Part II: VBA Tools and Techniques 49 Chapter 4: Understanding Your VBA Building Blocks 51 Chapter 5: Controlling Access through VBA 71 Chapter 6: Programming Access Forms 87 Part III: VBA, Recordsets, and SQL 115 Chapter 7: The Scoop on SQL and Recordsets 117 Chapter 8: Putting Recordsets to Work 147 Part IV: Applying VBA in the Real World 173 Chapter 9: Creating Your Own Dialog Boxes 175 Chapter 10: Customizing Lists and Drop-Down Menus 201 Chapter 11: Creating Your Own Functions 241 Chapter 12: Testing and Debugging Your Code 267 Part V: Reaching Out with VBA 295 Chapter 13: Using VBA with Multiple Databases 297 Chapter 14: Integrating with Other Office Applications 317 Part VI: The Part of Tens 349 Chapter 15: Ten Commandments of Writing VBA 351 Chapter 16: Top Ten Nerdy VBA Tricks 357 Chapter 17: (Way More Than) Ten Shortcut Keys 367 Index 371

Read more less