Course Catalog > Microsoft Office 2003 > Advanced Microsoft Access 2003
Advanced Microsoft Access 2003
Advanced 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.
Advanced Microsoft Access 2003 is for those who want to expand their knowledge and abilities with Access into some of the more specialized and advanced capabilities, such as working with improperly structured data (normalization), perform summary operations on data, create macros to automate tasks, enhance forms & reports, and use Access in other Microsoft Office applications
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
Upon successful completion of this course, students will be able to:
- Restructure an existing set of data to improve the design of a database.
- Use a variety of techniques to summarize and present data with queries.
- Create and revise basic Access macros.
- Create macros that improve data entry efficiency and integrity.
- Improve the effectiveness of data entry in forms.
- Improve the effectiveness of data displayed in reports.
- Maintain an Access database by using various utility tools.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Advanced 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 Advanced Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Advanced Microsoft Access 2003
Module 1: Structuring Existing Data
- Import Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Module 2: Writing Advanced Queries
Create Unmatched and Duplicates Queries- Group and SummarizeRecords Using the Criteria Field
- Summarize Data with a Crosstab Query
- Create a PivotTable and a PivotChart
- Display a Graphical Summary on a Form
Module 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro to a Command Button
- Restrict Records Using a Where Condition
Module 4: Adding Interaction and Automation with Macros
Require Data Entry with a Macro- Display a Message Box with a Macro
- Automate Data Entry
Module 5: Making Forms More Effective
- Change the Display of Data Conditionally
- Display a Calendar on a Form
- Organize Information with Tab Pages
Module 6: Making Reports More Effective
- Cancel Printing of a Blank Report
- Include a Chart in a Report
- Arrange Data in Columns
- Create a Report Snapshot
Module 7: Maintaining an Access Database
- Link Tables to External Data Sources
- Back Up a Database
- Compact and Repair a Database
- Protect a Database with a Password
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Office Specialist Access |
||
For More Information About Advanced Microsoft Access 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800