Course Catalog > Microsoft Office Training > Introduction to Microsoft Access 2007
Introduction to Microsoft Access 2007
Introduction to Microsoft Access 2007 (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.
Introduction to Microsoft Access 2007 is for new users of Access 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.
Intended Audience
- This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes.
- The Introduction to Access 2007 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.
- Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Course Objectives
Upon successful completion of this course, students will be able to:
- Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
- Design a simple database.
- Build a new database with related tables.
- Manage data in a table.
- Query a database using different methods.
- Design forms.
- Generate reports.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Introduction to Microsoft Access 2007 $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 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Introduction to Microsoft Access 2007
Lesson 1: Working with Access 2007
- Define Database Concepts
- Explore the User Interface
- Explore the Ribbon
- Customize the Access Environment
- Obtain Help
- Use an Existing Access Database
Lesson 2: Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data’
- Designate Primary and Foreign Keys
- Determine Table Relationships
Lesson 3: Building a Database
- Create a New Database
- Create a Table
Create Table Relationships
Lesson 4: Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
Lesson 5: Querying a Database
- Filter Records
- Create a Select Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
- View Data Using an Access Form
- Create a Form
- Create a Form Using the Form Wizard
- Modify the Design of a Form
Lesson 7: Generating Reports
- View an Access Report
- Create a Report
- Create a Report Using the Report Wizard
- Add a Calculated Field to a Report
- Format the Controls in a Report
- AutoFormat a Report
- Prepare a Report for Print
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Certified Application Specialist (MCAS) - Access | ||
For More Information About Introduction to Microsoft Access 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800