Microsoft Access 2007 - Database Design

Learn to identify the components of a database, open a table & find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between tables to ensure data accuracy...

Course Outline

Students enrolled in this course will learn to indentify the components of a database, open a table and find information stored in it, create and customize table designs, enter data and validate using input validation formulas, create relationships between tables to ensure data accuracy and deploy referential integrity. Other topics include creating forms for entering data into tables, creating, editing, running queries, creating, enhancing, and previewing reports, and importing/exporting data to and from various sources.

Course Content

The Basics

• Database Concepts
• Creating a Database
• Converting Access Files
• Working with Objects
• Using Access 2007 Help

Table Data

• Table Concepts
• Viewing Data in a Table
• Changing the Datasheet Appearance
• Entering and Editing Data
• Applying Filters

Table Design

• Creating a Table
• Changing the Table Design

Data Entry

• Data Entry Concepts
• Data Formats
• Input Masks
• Input Validation
• Adding Records

Relationships

• Relationships Between Tables
• Creating a Relationship
• Referential Integrity
• Removing a Relationship
• Printing Relationships

Creating and Using Forms

• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Creating a Form in Design View
• Opening a Form
• Changing a Form Design
• Adding Controls
• Placing Controls
• Multiple-Choice Controls
• Error Checking

Queries

• Using the Query Wizard
• Creating a Query in Design View
• Selecting and Sorting in a Query
• Calculations
• Action Queries
• Parameter Queries

Reports

• Creating Reports
• Using the Report Wizard
• Previewing Reports
• Creating Reports in Design View
• Changing Report Design
• Control Operations
• Control Attributes

Importing and Exporting Data

• Importing and Exporting
• Importing a Text File
• Importing Data from an Access Database
• Exporting Data
• Troubleshooting Importing and Exporting Problems

Printing

• Printing Objects
• Print Preview

Additional Details

Pre-Requisites

Good understanding of Windows and Microsoft software.

Certificates offered

Certificate of completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Great course

Reviewed by Trevor H. 2011

   

Course instuctor did not hand out the manuals until end of the day. Therefore not able to write notes in for reference later on. - kinda silly.

Reviewed by Mike C. 2011

   

You shoudl have a Excel 3 class available

Reviewed by Brandy Z. 2011

   

Great training, had to meet the various needs from no experience to some with experience. Washrooms looked tired and need of improvement. Personally prefer an early start/early finish 8am to 3pm would be great

Reviewed by David S. 2011

   

Course materials were not handed out till the end of the course and may have been useful to follow along. Some of the example/course files were missing from my folder.

Reviewed by Craig B. 2011

   

The Instructor was very knowledgable on the subject. The class moved quickly. I think an additional day would have been nice.

Reviewed by Cheryl . 2011

   

Trainer was open to answering questions and provide information in a clear manner.

Reviewed by Maureen D. 2011

   

Well presented, hands on course! The instructor was extremely knowledgable and helpful!! I have already reccommended this course to my managers.

Reviewed by Kelly D. 2011

   

The trainer I had was great. She had a great personality that kept me interested. Awesome Job! Thank you

Reviewed by Lindsey G. 2011

   

The course was excellent and the instructor did a great job but why does everybody cut the time short. I think we should take a shorter lunch and get more class time instead of leaving a half of an hour early!

Reviewed by Darlene T. 2011

   

EXCELLENT instructor!!! Very patient ... customized the class to the needs of the students!

Reviewed by Jackie G. 2011

   

The only improvement I can suggest is focusing a bit more on the basics of Visio - more on Org & flow charts as opposed to so much time spent on designing rooms.

Reviewed by Karyn G. 2011

   

George was personable and easy to follow and work with.

Reviewed by Suzanne S. 2011

   

Sue is an awesome instructor!

Reviewed by Cathy P. 2011

   

The instructor was excellent. It was evident that several of us who were competent with Excel 2003 Level 1 should have probably taken Excel 2007 Level 1 again rather than Excel 2007 Level 2, but the instructor was very patient and managed to cover basics from Level I as well as Level 2.

Reviewed by Kim C. 2011

   

With myself being very green with this program I got very useful information that I can use daily.

Reviewed by Rick . 2011

   

One more hour would allow for more hands-on training.

Reviewed by Kerstin M. 2011

   

Good course. Friendly instructor. I found the speed of the course to be a little slow for me, however I understand that other attendees required more help/detail than I did. Overall, a good experience.

Reviewed by Jenna N. 2011