Getting Started with Access 2003

Training Provided by Teach Me IT The Getting Started with Access 2003 course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database tables to ensure maximum database efficiency. After completing this course, the user will be able to: define databases and identify the relationships existing in a database identify the generic features of Microsoft Access 2003 and features of Access 2003 for improved user experience identify the interface elements of Access 2003 customize the work area, toolbars, and menus create a database in Access 2003 identify data types for defining tables create and modify a table design enter data in a table and insert hyperlinks in a table customize the appearance of a datasheet find, sort, filter, and group data describe and work with table relationships work with the Query Wizard build queries in the Design view create data summaries using queries use criteria and expressions in queries create Crosstab and Parameter queries work with Action queries define SQL statements create SQL-specific queries

Getting Started with Access 2003

Course Name Getting Started with Access 2003 Audience This course is designed for application developers and end users who want to implement simple data management solutions using Microsoft Access 2003 database management system. Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements   ØMacromedia Flash plug-in for Windows for IE/NN Pre-requisites The user should be familiar with the basics of the Microsoft Office suite and Windows 95/98/XP operating systems. Course Duration 7 hours Course Objectives The Getting Started with Access 2003 WBT course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database tables to ensure maximum database efficiency. After completing this course, the user will be able to: define databases and identify the relationships existing in a database identify the generic features of Microsoft Access 2003 and features of Access 2003 for improved user experience identify the interface elements of Access 2003 customize the work area, toolbars, and menus create a database in Access 2003 identify data types for defining tables create and modify a table design enter data in a table and insert hyperlinks in a table customize the appearance of a datasheet find, sort, filter, and group data describe and work with table relationships work with the Query Wizard build queries in the Design view create data summaries using queries use criteria and expressions in queries create Crosstab and Parameter queries work with Action queries define SQL statements create SQL-specific queries Course Outline Access 2003 Fundamentals Database Concepts Basics of Access 2003 Customizing Access 2003 Quiz Designing Databases and Tables Creating a Database Creating Tables Quiz Working with Data Entering and Modifying Data Finding, Sorting, and Grouping Data Defining Table Relationships Quiz Building Queries Building Select Queries Building Analytical Queries Creating Crosstab, Parameter, and Action Queries Creating SQL Queries Quiz