Limit search to available items
Book Cover
E-book
Author Cox, Joyce

Title Microsoft Access 2010 step by step / Joyce Cox, Joan Lambert
Published Redmond, Wash. : Microsoft Press, ©2010

Copies

Description 1 online resource
Series Step by step
Step by step (Redmond, Wash.)
Contents Introducing Microsoft Access 2010 -- Modifying the Display of the Ribbon -- Features and Conventions of This Book -- Using the Practice Files -- Your Companion eBook -- Getting Help -- Simple Database Techniques -- 1. Explore an Access 2010 Database -- Working in Access 2010 -- Enabling Macros and Other Database Content -- Understanding Database Concepts -- Exploring Tables -- Tabbed Pages vs. Overlapping Windows -- Exploring Forms -- Exploring Queries -- Exploring Reports -- Previewing and Printing Access Objects -- Key Points -- 2. Create Databases and Simple Tables -- Creating Databases from Templates -- Web Databases
Creating Databases and Tables ManuallyDatabase Design -- Manipulating Table Columns and Rows -- Refining Table Structure -- Creating Relationships Between Tables -- Key Points -- 3. Create Simple Forms -- Creating Forms by Using the Form Tool -- Changing the Look of Forms -- Changing the Arrangement of Forms -- Key Points -- 4. Display Data -- Sorting Information in Tables -- How Access Sorts -- Filtering Information in Tables -- Filtering Information by Using Forms -- Wildcards -- Locating Information That Matches Multiple Criteria -- Saving Filters as Queries -- Key Points -- 5. Create Simple Reports
Creating Reports by Using a WizardModifying Report Design -- Previewing and Printing Reports -- Key Points -- Relational Database Techniques -- 6. Maintain Data Integrity -- Restricting the Type of Data -- Restricting the Amount of Data -- Restricting the Format of Data -- Creating Custom Formats -- Restricting Data by Using Validation Rules -- Simple Validation Tests -- Restricting Data to Values in Lists -- Multicolumn Lookup Lists -- Restricting Data to Values in Other Tables -- Multivalued Fields -- Key Points -- 7. Create Custom Forms -- Modifying Forms Created by Using a Wizard -- Adding Controls -- Adding Subforms
Different Types of FormsUsing E-Mail Forms to Collect Data -- Key Points -- 8. Create Queries -- Creating Queries by Using a Wizard -- Creating Queries Manually -- Using Queries to Summarize Data -- Using Queries to Perform Calculations -- Using Queries to Update Records -- Using Queries to Delete Records -- Key Points -- 9. Create Custom Reports -- Creating Reports Manually -- Modifying Report Content -- Adding Hyperlinks, Charts, and Buttons -- Adding Subreports -- Layouts -- Key Points -- Database Management and Security -- 10. Import and Export Data -- Importing Information -- Importing from Other Access Databases
Importing from Excel WorksheetsImporting from Text Files -- Importing from Other Database Programs -- Importing from Outlook Folders -- Importing from SharePoint Lists -- Importing from HTML Files -- Importing from XML Files -- Linking to Information -- Exporting Information -- Exporting to Other Access Databases -- Exporting to Excel Worksheets -- Exporting to Word Documents -- Exporting to Text Files -- Exporting to PDF and XPS Files -- Exporting to SharePoint Lists -- Exporting to HTML Files -- Exporting to XML Files -- Copying to and from Other Office Programs -- Key Points -- 11. Make Databases User Friendly
Summary Offers hints and troubleshooting guidelines to help users navigate the user interface, create a database, produce forms and queries, filter data, customize a database, and use VBA to create Web pages based on data
Notes Copyright © 2010 Online Training Solutions Inc. 2011
In Online access: O'Reilly Media, Inc. O'Reilly Online Learning Platform: Academic edition (EZproxy Access)
SUBJECT Microsoft Access. http://id.loc.gov/authorities/names/n92084807
Microsoft Access. blmlsh
Microsoft Access fast
Subject Relational databases.
Relational databases
Form Electronic book
Author Lambert, Joan.
ISBN 9780735647411
0735647410
Other Titles Access 2010