Course Catalog > Microsoft Office 2003 > Introduction to Microsoft Access 2003
Introduction to Microsoft Access 2003
Introduction to Microsoft Access 2003 (1 Day)
Our Microsoft Access 2003 relational database training courses will help you learn how to build, maintain, and implement relational databases.
Whether you are new to Microsoft Access 2003 or an advanced user, Current Technologie's Microsoft Certified Trainers will make you a Microsoft Access guru.
Introduction to Microsoft Access 2003 is for new users of Access 2003 who have little-to-no experience with relational databases, this course will provide skills necessary to create a database and enter, find, and report on the data it contains.
Come Experience the Current Technologies Computer Learning Center Way of training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Objectives
The primary objective is to teach the basic skills necessary to use the Access 2003 program.
- Understand database concepts and terminology in Access 2003.
- Design and create tables.
- Enter and manipulate data in tables.
- Use Access queries to select and analyze information in a table.
- Create data forms for viewing and inputting data.
- Create reports that summarize and group data.
- Perform database maintenance procedures.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Introduction to Microsoft Access 2003 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Introduction to Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Introduction to Microsoft Access 2003
Lesson 1: An Overview of Access 2003
- Understand Relational Databases
- Examine the Access Environment
- Open the Database Environment
- Examine an Access Table
Lesson 2: Managing Data
Examine an Access Form- Add and Delete Records
- Sort Records
- Display Recordsets
- Update Records
- Run a Report
Lesson 3: Establishing Table Relationships
- Identify Table Relationships
- Identify Primary and Foreign Keys in the Relationships Window
- Work with Subdatasheets
Lesson 4: Querying the Database
Create a Select Query- Add Criteria to a Query
- Add a CalculatedField to a Query
- Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
- Examine Form Design Guidelines
- Create a Form Using AutoForm
- Create a Form Using the Form Wizard
- Modify the Design of a Form
Lesson 6: Producing Reports
- Create an AutoReport
- Create a Report by Using the Wizard
- Examine a Report in Design View
- Add a Calculated Field to a Report
- Modify the Format Properties of a Control
- AutoFormat a Report
- Adjust the Width of a Report
- Hide and Unhide Worksheets
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
Microsoft Office Specialist |
||
For More Information About Introduction to Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800