Course specifications
Course number: 074 461
Software version number: 2003
Course length: 1 day
Hardware/software required to run this course
This book was written for the Windows XP platform.
A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. (300 MHz is recommended.)
A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
128 MB of RAM.
A 5 GB hard disk or larger, if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
A 3 GB hard disk or larger, if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
A CD-ROM or DVD-ROM drive.
A mouse or other pointing device.
An 800 x 600 resolution monitor.
Network cards and cabling for local network access.
Internet access (see your local network administrator).
A printer (optional).
A projection system to display the instructor's computer screen.
Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.
Microsoft Office Professional Edition 2003.
Course description
Overview: Students will get the most out of this course if they want to learn to enhance their database designs by using the principles of data normalization and table relationships; to query multiple tables for data that is used in customized forms and reports; and to begin using data access pages.
Prerequisites: To ensure your success with this course, we recommend that you first take the following Element K Content courses or have equivalent knowledge:
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Performance-based 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:
Lesson 1: Principles of table design
Normalizing data
Normalizing data for fourth and fifth normal forms
Lesson 2: Principles of table relationships
Analyzing table relationships
Establishing and testing referential integrity
Lesson 3: Table design techniques
Data validation techniques
Indexing techniques
Lesson 4: Designing select queries
Using calculated fields in queries
Creating multiple-table queries
Lesson 5: Customizing form designs
Customizing the form design
Performing calculations on a form
Adding combo boxes to a form
Adding unbound controls
Lesson 6: Working with data access pages
Creating data access pages
Lesson 7: Customizing reports
Customizing a report created by the Report Wizard
Working with subreports
Appendix A: Using the Chart Wizard
Creating a chart in a form or report
Appendix B: New features of Access
View information on object dependencies
Property update options
SKU | 074461S3 |
---|---|
Weight | 1.0000 |
Coming Soon | N/A |
Days of Training | 1 |
Audience | Student |
Product Family | Select |
Product Type | Print Courseware |
Electronic | No |
ISBN | 758087349 |
Language | English |
Page Count | 172 |
Curriculum Library | Access |
Year | 2003 |
Manufacturer's Product Code | N/A |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2005-02-25 00:00:00 |
rtf | 074461S3 RTF File |
---|---|
outline | 074461S3 Outline File |