Description |
1 online resource. |
|
text file |
Series |
Step by step |
|
Step by step (Redmond, Wash.)
|
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. |
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. |
Subject |
Microsoft Access.
|
|
Microsoft Access. |
|
Microsoft Access |
|
Relational databases.
|
|
Bases de données relationnelles. |
|
Relational databases |
Added Author |
Lambert, Joan. Author.
|
Added Title |
Access 2010 |
In: |
Online access: O'Reilly Media, Inc. O'Reilly Online Learning Platform: Academic edition (EZproxy Access) |
Other Form: |
Print version: Cox, Joyce, 1946- Microsoft Access 2010 step by step. Redmond, Wash. : Microsoft Press, ©2010 9780735626928 (DLC) 2010928521 (OCoLC)559809030 |
ISBN |
9780735647411 |
|
0735647410 |
|
(pbk. ; alk. paper) |
|
(pbk.) |
Standard No. |
9780735647411 |
|