Access school training courses in Cedar Rapids, IA (public, in-house or online)

This workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET.

At Course Completion:
After completing this workshop, students will be able to: - Connect to databases and read data. - Query and update databases by using commands. - Perform transactional operations. - Perform disconnected operatio...

Full archival course description>>

This workshop provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005.

At Course Completion:
After completing this workshop, students will be able to: - Minimize and handle database operation conflicts. - Handle large objects. - Enhance database performance. - Create managed code objects for SQL Server 2005. - Query XML by using XPath. - Transform XML by using XSLT styl...

Full archival course description>>

In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Accessâ„?2007 with other applications. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - examine the basic database concepts and explore the Microsoft Office Access 2007 environment. - design a simple database. - build a new databa...

Full archival course description>>

Program Fundamentals


Introduction to Databases


Starting Access 2010


Opening a Database


What’s New in Access 2010


Understanding the Access Program Screen


Giving Commands


Using Command Shortcuts


Using Help





Database Basics


Working with Database Objects


Tour of a Table


Adding, Editing and Deleting Records


Tour of a Form
Full archival course description>>

This is a self-paced course that shows you how you can use JDBC to access an Oracle database from a Java application. The first module teaches you how to use JDBC to run queries and manipulate data in the database; the second module discusses using JDBC in Web-based applications, and the third module deals with some more advanced JDB