Objective:

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:

Contents:

• 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

Instructors:

• Certified As MCSD & MCAD & MCPD.