netwind-logo

facebookgoogleplustwitterlinkedin         Check out our Social Media Sites

About Us   Contact Us  Return Policy   Login Campus 1   Shopping Cart        

           

       

    

hr

 Home     IT Boot Camps      AutoCAD     Cisco     CompTIA  EC Counsil   ISC2     Microsoft  Oracle Project Mgt     VMWare

hr
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007

Microsoft Office Access 2007 Training Courses

This course prepares you for some of the significant changes to the application, such as the user interface that replaces the traditional menus and toolbars with features like the Ribbon, the Quick Access Toolbar, and the Microsoft Office button. This course provides instruction for both basic to advance levels as it demonstrates how to navigate within the new user interface. Learn the steps in planning a database, the components and views of an Access database, and database creation methods

Training Audience

This course is designed for end-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Office Specialist certification and end-users seeking to update their skills in this application.

Access 2007

Our Training course includes

    instructor based training Instructor led Video Based Training

    test preps Practice Tests. Review questions to test your knowledge of the material and prepare for the exam

    training time More than 40 Hours of training time

    Online Training Book Library Online Training Book Library

    Proven Success Proven success, with thousands sold to individuals and companies

MS Access Beginning Level

Getting Started

  • Plan a database
  • Match the main elements of the screen with their functions
  • Use Access Help
  • Create a database from scratch
  • Create a database from a template
  • Add a blank datasheet to a database
  • Use views in Access 2007
  • Create a database and add a data sheet
  • Change the view

Basic Tables

  • Create a table from a template in a given scenario
  • Identify the elements in a table
  • Table templates
  • Create a table using Datasheet view
  • Create a table using Design view
  • Modify a table
  • Modify a table in Design view
  • Create a validation rule
  • Create a masked input field in a table
  • Apply indexing to a table
  • Create a table from a template
  • Modify a table
  • Create a table in datasheet view and add a validation rule
  • Create an input mask in MS Access 2007
  • Manipulate data in records
  • View, edit, and navigate records
  • Sort and filter data
  • Find and replace data
  • Print records
  • Create a relationship
  • Filter table information
  • Create a relationship
  • Edit a relationship
  • Relational database

Basic Forms

  • Create a form
  • Add controls to forms
  • Configure controls on a form
  • Bind controls to a field
  • Configure bound controls
  • Create a form using the Form Wizard
  • Add and configure an unbound control
  • Create a bound control and configure the record source
  • Customize forms
  • Format forms
  • Create and modify records
  • Navigate between records
  • Sort and filter records
  • Format a form
  • Create and modify a record
  • Sort and filter records

Queries and Reports

  • Simple query in design view
  • Simple query using the Simple Query Wizard
  • Modify a query in Access 2007
  • Create an expression with the Expression Builder
  • Calculated fields and grouping
  • Create a crosstab query
  • Refine a crosstab query
  • Find unmatched queries
  • Duplicate queries
  • Create and run a query in design view
  • Group a query by an aggregate function
  • Change an aggregate value for a crosstab query
  • Find Unmatched Query wizard
  • Create a basic report
  • Add a control to a report
  • Recognize how to modify reports
  • Add a group and calculated summary to a report
  • Create a report using the Report Wizard
  • Add a control to a report and bind it to a field
  • Add a grouping to a report
  • Add a calculated summary to a group

MS Acces Advanced Level

Importing and Exporting Data and Data Presentation

  • Importing and Exporting Data and Data Presentation 
  • Import data into a database
  • Distinguish between the options available for importing data 
  • Export data
  • Distinguish between the formats you can export to 
  • Set up data collection 
  • Collect data by using e-mail messages
  • Import an object into a database
  • Export a database object to Excel
  • Collect data using e-mail messages
  • Build a PivotTable
  • Modify a PivotTable 
  • Build a PivotChart 
  • Modify a PivotChart
  • Create a PivotTable 
  • Create a PivotChart 

Advanced Data Management

  • Add a lookup field to a table
  • Add a subdatasheet to a table
  • Add attachments to records
  • Implement data validation
  • Add a lookup field to a table
  • Add a subdatasheet to a table 
  • Use Expression Builder to construct a rule
  • Add Subforms to a database
  • Add Subreports to a database
  • Apply conditional formatting to a form
  • Add a subform to an existing form
  • Apply conditional formatting to a form
  • Add a subreport to a database
  • Create and edit joins  databases
  • Create and use simple parameter queries
  • Create and run update and append queries
  • Create and run a make table query
  • Delete data from a database
  • Create union queries
  • Recognize how to create or modify tables and indexes using data-definition queries
  • Perform SQL processing on a server
  • Edit the SQL of a SELECT query and use subqueries
  • Specify a join in a query
  • Create and run a parameter query
  • Create and run an update query
  • Edit the SQL of a SELECT query
  • Use SQL to create queries

MS Access Power User Level

Programmability and Administration

  • Determine how to move data to a sharepoint site
  • Specify how to publish data to a sharepoint site
  • Create an Access view of a sharepoint list
  • Work with sharepoint lists
  • Take sharepoint list data offline
  • Work offline and track data
  • Move data to sharepoint using the Move to Sharepoint Site wizard
  • Publish a database to a Sharepoint site |w
  • Import a sharepoint list
  • View different versions of a sharepoint list item
  • Create and edit  macros
  • Run Access 2007 macros
  • Use VBA to create an event handler
  • Work with event handlers
  • Create a macro
  • Run a macro
  • Edit a macro
  • Create an event handler

Database Administration

  • Customize datasheets
  • Recognize how to compact and repair a database
  • Illustrate how to convert earlier Access database formats
  • Specify how to back up databases and restore database files
  • Customize the datasheet view
  • Convert an earlier Access database to Access 2007 format
  • Change the default file format of a database
  • Outline how to view and change object dependencies
  • Illustrate how to analyze objects for performance
  • Outline how to use the database documenter and the Table Analyzer wizard to optimize database performance
  • Use the performance analyzer
  • Use the Database Documenter
  • Use the Table Analyzer wizard
  • View an object's object dependencies
  • Identify how to enable content for a database
  • Recognize how to hide a database object
  • Summarize how to encrypt a database by setting a database password
  • Restate how to protect VB code
  • Determine how to split a database and repair database links
  • Use an Office Access 2007 database in a trusted location
  • Restate how to package, sign, and distribute an Office Access 2007 database
  • Protect a database by setting a database password
  • Add a new location to the trust center
  • Split a database
  • Create a signed package
  • Outline how to work with switchboards and the Navigation Pane
  • Outline how to create a custom group and add objects to it

 

About Us  | Testimonials | Privacy Policy | Classes | Training Features |


Questions? e-mail us at: salesinfo@netwind.com

Copyright  © 1996-2013 Netwind Learning Center / CDi Communications, Inc.

 

Call 1.800.617.5586 for pricing

Microsoft Access Tutorials  2007
(item# skac07on)


Payment Options

1-800-617-5586 (352.404.8866)
All major credit cards (Visa, MasterCard, Amex, and Discover)
Company Purchase Orders may be faxed to 1.877.557.3064