SkillPath Seminars
Call us: 1-866-222-6315

In Microsoft® Access® 2010 Basic, participants will learn...

  • How to build custom database solutions
  • How to connect to a variety of external data sources and generate professional-looking reports
  • Streamlined methods for sorting data into tables, queries and forms
  • Access’s dozens of built-in functions for calculating totals and for numbering and counting records

This Microsoft Access 2010 Basic training course is an informative, hands-on experience that will allow your employees to gain a thorough understanding of what makes Access tick as they master the basics of tables, queries, forms and reports and delve into custom features for solving the most complex information challenges.




    SkillPath Training Information

    SkillPath Enterprise Solutions can bring the following topic to your company: Microsoft® Access® 2010 Basic

    Click on the link below for more information. http://www.skillpath.com/index.cfm/on-site/training/topic/Microsoft-Access-2010-Basic



    TRAINING AGENDA

    Click on a title to view details

    Getting started with Microsoft Access 2010

    +
    • What a database is and how it can make information management a whole lot easier
    • When to use a database or a spreadsheet? Here’s what to consider
    • 3 great reasons to use a relational database—like Access—rather than a flat database file
    • How to plan a database correctly so it doesn’t have to be built over again later
    • A step-by-step guide to using Access’s user-friendly ribbon and new Backstage View

    Creating tables in Microsoft Access—laying the groundwork of a database

    +
    • The in’s and out’s of working in Design View to change the structure or design of a table without changing the data
    • How to create a table from scratch to house data
    • How to quickly create a complete application using the new templates in Microsoft Access
    • Understanding the various data types including the new calculated fields
    • How to use the powerful Filter tool to view a subset of records without needing to create a query

    Using queries to enter and retrieve data in Microsoft Access

    +
    • What a query is and when to use it
    • How to open, save, copy, rename and delete queries
    • How to create a query that pauses execution and accepts user input
    • Valuable sorting techniques for organizing records
    • How to run a Crosstab query to see calculated totals in a spreadsheet-like format
    • How to create and run an Update query to modify data in multiple records quickly and easily

    Creating forms to simplify data entry in Microsoft Access

    +
    • Understanding the basics of forms
    • Adding graphics—from many sources—to enhance forms
    • How to show data from several tables and update data in more than one table? Create a subform
    • Discover Microsoft Access’s enhanced Expression Builder and create calculations …with the click of a few buttons
    • How to use the Application Parts feature to add additional functionality to an existing database

    Presenting organized information with Microsoft Access reports

    +
    • Need to modify a report? Go to Design View and follow these simple steps
    • How to use the Sort and Group window to organize information in an easy-to-read display
    • Exploring Microsoft Access’s dozens of built-in functions for calculating totals and for numbering and counting records
    • How to utilize the new Conditional Formatting feature to enhance reports
    • Advanced report techniques: How to make a report from a variety of different data sources

    Automating complex tasks using macros and modules

    +
    • Macros … explained in plain English
    • How to create a macro using the new Macro Builder to perform a series of commands at the push of a button
    • Need to modify a macro? These tips will bolster confidence
    • How to use the new data macros to implement “triggers” that will perform actions based on field values
    • When a macro acts up … debugging and troubleshooting techniques that’ll get you up and running
    • For the advanced user … understanding modules and their unique role in solving unusual or difficult programming problems

    Mastering external data sources

    +
    • Understanding the difference between linking and embedding
    • Importing data from other sources to a new table in Microsoft Access
    • How to link to a table in another database and use the Linked Table Manager
    • How to export PDFs and XPSs to share data and collaborate
    • How to use ODBC drivers to connect to virtually any data source such as SQL servers, mainframe database systems and more

    Using the right tools for the right job—the Database Tools tab

    +
    • Understanding why it’s important to secure a database and the tools needed
    • How to use the Performance Analyzer to analyze the performance of database objects
    • A step-by-step guide to using the Upsizing Wizard—upsizing an Access database to an SQL Server database
    • How to use the Object Dependencies feature to understand complex relationships in databases with numerous objects
    • Learn how to split a database, improve performance and reduce the chance of corruption to a database
    • What’s important to know about replication options
    • How to use the Database Documenter