|
|
|
|
|
|
This course is provided by Wintrac. Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course catalog
of over two thousand courses includes courses on Desktop Application Software
training, database
training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview:
This course guides students through the transition process of upgrading to the new and improved features in Access 2002, especially its Web-related features.
Prerequisites:
To benefit from the material presented in this course, students must be an intermediate-level user of Access 97. They should have completed the following courses: Access 97: Level 1 or Access 97: Level 2, or have equivalent knowledge. In addition, students should have some familiarity with the Internet and a Web browser. Finally, students should have completed the course Microsoft Office 97 to Office XP: New Features that covers the overall new features to the Office environment.
Target Student:
Students enrolling in this course should understand how to use Access 97 and have some familiarity with the Internet. This course covers the commonly used new features for an intermediate user. Due to the nature of this course and the minimal prerequisites, there are other more advanced new features that are not covered in depth.
Benefits:
Students will learn how to take advantage of usability improvements in Access 2002, how to enhance Access objects by exploiting new features, how to create data access pages, how to efficiently integrate with other applications, and how to use new and improved Access tools. In general, they will learn how to apply their knowledge of Access 97 to be functional in the Access 2002 environment and beyond that, to realize greater accomplishments.
What's Next:
This course is one in a series of New Features courses designed to meet the needs of individuals transitioning from Office 97 to Office XP. Students who want to learn new features in other applications can take individual Word 2002, Excel 2002, PowerPoint 2002, and Outlook 2002 New Features classes. Students who want to learn advanced features of Access 2002 or those seeking Microsoft Office User Specialist certification can take any the classes in the Access 2002 series.
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:
- Take advantage of usability improvements in Access XP, including changes to menus, toolbars, dialog boxes, the Database window; revised features related to an entire database; and ways to output and distribute an Access database and its objects.
- Enhance Access objects by exploiting new features in tables, queries, forms, and reports designed to make your work easier and more efficient.
- Create, edit, and deploy Data Access Pages using the Page Wizard and Design view.
Hardware/Software Requirements:
You will need:
To run this course, you will need:
- A Pentium 133 MHz or higher processor with a minimum of 64 MB of RAM for the operating system and an additional 8 MB of RAM for each Office application running simultaneously. (For Windows 98 or Windows 98 SE, 24 MB of RAM for the operating system. For Windows Me or Windows NT, 32 MB of RAM for the operating system.)
- A minimum of 520 MB of free hard-disk space.
- Either a local CD-ROM drive or access to a networked CD-ROM drive for installation purposes.
- A floppy-disk drive.
- A Microsoft Mouse, Microsoft IntelliMouse, or compatible pointing device.
- A Super VGA or higher resolution monitor.
- Microsoft Windows 98 or later, or Microsoft Windows NT 4.0 with Service Pack 6x or higher installed.
- A complete installation of Microsoft Office XP.
- Microsoft Internet Explorer 5.01 or higher.
See your reference manual for hardware considerations that apply to your specific hardware setup.
In addition, you will need an installed printer driver.
Note: This course was developed using the Windows 2000 platform. However, the manufacturer?s documentation states that Office XP can also run on Windows 98, Windows Millennium Edition, and Windows NT 4.0 with Service Pack 6x.
Course duration:
0.5 Day(s)
Course outline:
Lesson 1: Introducing Access XP
- Get Started
- Task A-1: Get started
- Task A-2: Use the Database window
- Task A-3: Organize database objects into groups
- Work with a Database
- Task B-1: Print a relationships report
- Task B-2: Use Name AutoCorrect
- Distribute Database Objects
- Task C-1: Output a report to snapshot file format
- Task C-2: Use email to send database information
- Task C-3: Explore file formats and convert a database
- Task C-4: Use the improved Compact and Repair Utility
Lesson 2: Explore Changes to Access XP Objects
- Work with Access Objects
- Task A-1: Ease of use features
- Task A-2: Find and replace data
- Task A-3: Use the improved spelling checker
- View Your Data in New Ways
- Task B-1: View related data in a subdatasheet
- Task B-2: Work in PivotTable view
- Task B-3: Modify a pivot table
- Task B-4: Work in PivotChart view
- Work with Forms and Reports
- Task C-1: Use conditional formatting in a form
- Task C-2: Group text boxes and other controls
- Task C-3: Work with subforms
Lesson 3: Work with Data Access Pages
- Create Data Access Pages
- Task A-1: Use the Page Wizard to create a data access page
- Task A-2: Navigate in a data access page
- Task A-3: Modify a page design in Design view
- Task A-4: Add a theme to a data access page
- Use Data Access Pages To View and Edit Data
- Task B-1: Edit data by using a data access page in a browser
- Task B-2: Restrict the function of a data access page to data-entry only
- Design Different Types of Data Access Pages
- Task C-1: Create a data access page with a one-to-many form
- Task C-2: Create and navigate in a grouped data access page>
- Task C-3: Save a report as a Data Access Page
|
|
|
|
|
