Course Catalog > Microsoft Office 2003 > Intermediate Microsoft Access 2003
Intermediate Microsoft Access 2003
Intermediate Microsoft Access 2003 (1 Day)
Our 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 or an advanced user, Current Technologie's Microsoft Certified Trainers will make you a Microsoft Access guru.
Intermediate Microsoft Access 2003 is for those who have the basic skills using Access and want to learn how to enhance database designs by using the principals of table relationships & referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters & queries, customize forms & reports, and create data access pages .
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.
Course Objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
- Normalize sample tables by identifying design problems.
- Establish relationships between tables by analyzing table relationships and enforcing referential integrity.
- Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes.
- Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.
- Customize form designs by creating calculated fields, combo boxes, and unbound controls.
- Publish data to the Web by creating data access pages.
- Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Intermediate 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 Intermediate Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Intermediate Microsoft Access 2003
Lesson 1: Planning a Database
- Design a Relational Database
- Identify Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize the Data
- Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
- Create a New Database
- Create a Table Using a Wizard
- Create Tables in Design View
- Create Relationships between Tables
Lesson 3: Controlling Data Entry
- Restrict Data Entry with Field Properties
- Create an Input Mask
- Create a Lookup Field
Lesson 4: Finding and Joining Data
Find Data with Filters- Create Query Joins
- Join Unrelated Tables
- Relate DataWithin a Table
Lesson 5: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Lesson 6: Improving Your Forms
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add Command Buttons
- Create a Subform
Lesson 7: Customizing Your Reports
- Organize Report Information
- Set Report Control Properties
- Control Report Pagination
- Summarize Information
- Add a Subreport to an Existing Report
- Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
- Publish Access Data as a Word Document
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Office Specialist Access |
||
For More Information About Intermediate Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800