|
Other Courses |
| Office 2007 New Features |
| Access 2007 Intro |
| Access 2007 Intermediate |
| Access 2007 Advanced |
| Excel 2007 Intro |
| Excel 2007 Intermediate |
| Excel 2007 Advanced |
| PowerPoint 2007 Introduction |
| PowerPoint 2007 Intermediate |
| PowerPoint 2007 Advanced |
| Word 2007 Introduction |
| Word 2007 Intermediate |
| Word 2007 Advanced |
| Project 2007 Introduction |
| Project 2007 Advanced |
| Project 2007 Essentials |
| Outlook 2007 Introduction |
| Outlook 2007 Advanced |
| Publisher 2007 Introduction |
| Publisher 2007 Advanced |
| Visio 2007 Introduction |
| Access 2003 Intro |
| Access 2003 Intermediate |
| Access 2003 Advanced |
| Excel 2003 Intro |
| Excel 2003 Intermediate |
| Excel 2003 Advanced |
| PowerPoint 2003 Introduction |
| PowerPoint 2003 Intermediate |
| PowerPoint 2003 Advanced |
| Word 2003 Introduction |
| Word 2003 Intermediate |
| Word 2003 Advanced |
| Project 2003 Introduction |
| Project 2003 Advanced |
| Project 2003 Essentials |
| Outlook 2003 Introduction |
| Outlook 2003 Advanced |
| Publisher 2003 Introduction |
| Publisher 2003 Advanced |
| Visio 2003 Introduction |
| Visio 2003 Advanced |
|
|
[Legal Policy] | [ Privacy Policy] [Top]
|
|
Overview and objectives
This one-day Microsoft Access 2007 Training course builds on the skills
and concepts taught in Access 2007: Basic. Students will learn how to
normalize data; work with Lookup fields and subdatasheets; create join
queries; add objects to forms, print reports and labels; create charts;
and use PivotTables and PivotCharts.
Target audience
You should be comfortable using a personal computer and Microsoft
Windows XP or later. You should also have some experience using Access
2007. You will get the most out of this course if your goal is to become
proficient using more advanced Access features and functions, such as
relating tables, referential integrity, joins, queries, forms, reports,
charts, PivotTables, and PivotTables charts and forms.
Course prerequisites
Before taking this course, you should be familiar with personal
computers and the use of a keyboard and a mouse. Furthermore, this
course assumes that you've completed the following courses or have
equivalent experience: Windows XP: Basic, or Windows Vista: Basic and
Access 2007: Basic.
Course objectives
Normalize tables, analyze tables and view object dependencies, set table relationships, implement referential integrity between related tables, and set cascading deletes and updates.
Create a lookup field and a multivalued field, modify lookup field properties, and use a subdatasheet to add data to related tables.
Create join queries, create calculated fields in a query, and use queries to view summarized and grouped data.
Add unbound controls, graphics, and calculated fields to a form; create multiple item forms, split forms, datasheet forms, and subforms.
Add headers and footers in a report, use functions to add calculated values in a report, print table objects and database documents, and create labels.
Create and modify charts in forms and reports.
Create a PivotTable, modify a PivotTable, and create a PivotChart and a PivotTable form.
Course contents
Relational databases • Database normalization • Relating tables •
Implementing referential integrity
Related tables • Lookup fields • Modifying lookup fields • Subdatasheets
Complex queries • Joining tables in queries • Calculated fields • Summarizing and grouping values
Advanced form design • Adding unbound controls • Adding Graphics • Adding calculated values • Adding combo boxes • Advanced form types
Reports and printing • Customized headers and footers • Adding calculated values • Printing • Labels
Charts • Charts in forms • Charts in reports
PivotTables and PivotCharts • PivotTables • Modifying PivotTables • PivotCharts • PivotTable forms