Microsoft Access 2010: Step by Step - Brossura

Cox, Joyce; Lambert, Joan

Brossura

ISBN 10: 0735626928 ISBN 13: 9780735626928

Casa editrice: Microsoft Pr, 2010

Riassunto

Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.

Su questo libro

L'autore:

Joan Lambert has worked in the training and certification industry since 1997. As president of Online Training Solutions, Inc. (OTSI), Joan is responsible for guiding the translation of technical information and requirements into useful, relevant, and measurable training, learning, and certification deliverables. An MCTS, MOM, MCAS, and MCT, Joan is the author or coauthor of more than two dozen books about Windows and Microsoft Office (for Windows and for Mac).

Joyce Cox has more than 30 years' experience in the development of training materials about technical subjects for non-technical audiences and is the author of dozens of books about Office and Windows technologies. Joyce is vice president of Online Training Solutions, Inc. (OTSI). Previously, she was president of and principal author for Online Press, where she developed the Quick Course series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California.

Contenuti:

Introducing Microsoft Access 2010; New Features; Let’s Get Started!; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Access 2010; More Information; Simple Database Techniques; Chapter 1: Explore an Access 2010 Database; 1.1 Working in Access 2010; 1.2 Understanding Database Concepts; 1.3 Exploring Tables; 1.4 Exploring Forms; 1.5 Exploring Queries; 1.6 Exploring Reports; 1.7 Previewing and Printing Access Objects; 1.8 Key Points; Chapter 2: Create Databases and Simple Tables; 2.1 Creating Databases from Templates; 2.2 Creating Databases and Tables Manually; 2.3 Manipulating Table Columns and Rows; 2.4 Refining Table Structure; 2.5 Creating Relationships Between Tables; 2.6 Key Points; Chapter 3: Create Simple Forms; 3.1 Creating Forms by Using the Form Tool; 3.2 Changing the Look of Forms; 3.3 Changing the Arrangement of Forms; 3.4 Key Points; Chapter 4: Display Data; 4.1 Sorting Information in Tables; 4.2 Filtering Information in Tables; 4.3 Filtering Information by Using Forms; 4.4 Locating Information That Matches Multiple Criteria; 4.5 Key Points; Chapter 5: Create Simple Reports; 5.1 Creating Reports by Using a Wizard; 5.2 Modifying Report Design; 5.3 Previewing and Printing Reports; 5.4 Key Points; Relational Database Techniques; Chapter 6: Maintain Data Integrity; 6.1 Restricting the Type of Data; 6.2 Restricting the Amount of Data; 6.3 Restricting the Format of Data; 6.4 Restricting Data by Using Validation Rules; 6.5 Restricting Data to Values in Lists; 6.6 Restricting Data to Values in Other Tables; 6.7 Key Points; Chapter 7: Create Custom Forms; 7.1 Modifying Forms Created by Using a Wizard; 7.2 Adding Controls; 7.3 Adding Subforms; 7.4 Using E-Mail Forms to Collect Data; 7.5 Key Points; Chapter 8: Create Queries; 8.1 Creating Queries by Using a Wizard; 8.2 Creating Queries Manually; 8.3 Using Queries to Summarize Data; 8.4 Using Queries to Perform Calculations; 8.5 Using Queries to Update Records; 8.6 Using Queries to Delete Records; 8.7 Key Points; Chapter 9: Create Custom Reports; 9.1 Creating Reports Manually; 9.2 Modifying Report Content; 9.3 Adding Subreports; 9.4 Key Points; Database Management and Security; Chapter 10: Import and Export Data; 10.1 Importing Information; 10.2 Exporting Information; 10.3 Copying to and from Other Office Programs; 10.4 Key Points; Chapter 11: Make Databases User Friendly; 11.1 Creating Navigation Forms; 11.2 Creating Custom Categories; 11.3 Controlling Which Features Are Available; 11.4 Key Points; Chapter 12: Protect Databases; 12.1 Assigning Passwords to Databases; 12.2 Splitting Databases; 12.3 Securing Databases for Distribution; 12.4 Preventing Database Problems; 12.5 Key Points; Chapter 13: Customize Access; 13.1 Changing Default Program Options; 13.2 Customizing the Ribbon; 13.3 Customizing the Quick Access Toolbar; 13.4 Key Points; Glossary; Keyboard Shortcuts; General Shortcut Keys; Keys for Working with Text and Data; Keys for Navigating Records; Keys for Working with the Ribbon; Keys for Working with Online Help; Keys for Basic Office Tasks; About the Authors; Joyce Cox; Joan Lambert; The Team; Online Training Solutions, Inc. (OTSI);

Su questa edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2010
• ISBN 10: 0735626928
• ISBN 13: 9780735626928
• Rilegatura: Copertina flessibile
• Numero di pagine: 413