Microsoft Access 2010 step by step /

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Cox, Joyce, Lambert, Joan (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Microsoft Press, ©2010.
Colección:Step by step (Redmond, Wash.)
Temas:
Microsoft Access.
Relational databases.
Bases de données relationnelles.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares