MOS MOUS Access Certification XP
|
Access 2002 includes fundamentals, proficient and expert training levels
|
$150.00
|
n74050d
|
|
|
MOUS Word 2002 CBT CD
|
$150.00
|
n74020d
|
|
|
MOUS Excel 2002 CBT CD
|
$150.00
|
n74030d
|
|
|
MOUS Outlook 2002 CBT CD
|
$150.00
|
n74070d
|
|
|
Frontpage 2002 CBT CD
|
$100.00
|
n74091d
|
|
|
MOUS PowerPoint 2002 CBT CD
|
$100.00
|
n74041d
|
|
|
Complete MS Office XP Curriculum CBT CDs (MOUS XP)
(includes Access 2002, Excel 2002, FrontPage 2002, Outlook 2002, PowerPoint 2002, Word 2002)
|
$299.00
|
n74011d
|
|
Microsoft MOS MOUS Access XP Training CD for MS Office Certification
MS Access 2002 Fundamentals MOS MOUS Certification XP |
|
This MOS (Formerly MOUS) Training course presents the learner with the fundamentals of Microsoft Access 2002. This course guides the learner through the basics of Access
databases and covers topics such as creating and modifying databases, and establishing relationships between tables.
Learn To
• Identify advantages of a relational database.
• Identify the basics of a relational database.
• Sequence the steps for planning a relational database.
• Create a table in Datasheet view.
• Identify features of the Table Wizard
• Create a table in Design view.
• Identify features of relationships between tables.
• Create a one-to-many relationship between tables.
• Sequence the steps to define a many-to-many relationship between two tables.
Audience
The intended audiences for this course are Project or Office Managers,
Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of
other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing
documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).
Total Learning Time
6 to 8 hours
Unit 1: Basics of Access 2002
2 - 3 hours
• Identify advantages of a relational database.
• Identify the basics of a relational database.
• Sequence the steps for planning a relational database.
• Open a database by using Microsoft Access.
• Match database objects with their features.
• Identify the functions of each database object view.
• Create a blank database.
• Identify the options available when creating a database by using a database template.
• Get help by using the Office Assistant.
• Identify features of the Help Window.
Unit 2: Table Creation and Modification
2 - 3 hours
• Create a table in Datasheet view.
• Identify features of the Table Wizard.
• Create a table in Design view.
• Create a field for a table in Design view.
• Move a field in a table in Datasheet view.
• Modify a field property in a table in Design view.
• Create an input mask in a table field.
• Delete a field from a table in Design view.
• Set a field as a primary key in Design view.
• Set an index for a field in a table.
• Match optimum field data types with their features.
• Customize an input mask for a field in a table in Design view.
• Identify features of the Lookup Wizard.
• Identify the functions of Lookup field properties.
• Enter data into a table in Datasheet view.
• Edit data in a table in Datasheet view.
• Delete data from a table in Datasheet view.
• Add a hyperlink to a table in Datasheet view.
• Sort table data by a single field.
• Copy data into fields from other Office applications by using Office Clipboard.
• Match the record navigation controls with their functions.
• Locate a record in a datasheet by using the Find command.
• Filter by selecting a value in Datasheet view.
• Filter by excluding a selected value in Datasheet view.
• Filter by form in Datasheet view.
• Filter for input by entering specific criteria in a Filter For box.
• Filter a record by using the Advanced Filter/Sort window.
• Resize a column in Datasheet view.
• Format a datasheet.
Unit 3: Table Relationships and Data Integrity
2 hours
• Identify features of relationships between tables.
• Create a one-to-many relationship between tables.
• Sequence the steps to define a many-to-many relationship between two tables.
• Print a relationship report of a database.
• Identify features of a subdatasheet.
• Validate data integrity in a table.
• Identify features of the Required property used to ensure data integrity.
top
MS Access 2002 Proficient MOS MOUS Certification XP |
|
This MOS ( formerly MOUS) Training courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases.
Learn To
• Create a single-table query in Design view.
• Create a multiple-table query in Design view.
• Create a simple query by using the Simple Query Wizard.
• Identify features of the Form Wizard.
• Identify features of the AutoForm Wizard.
• Add a record to a form.
• Identify features of the Report Wizard.
• Print a report from Print Preview.
• Add a control label to a report.
• Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
• Link an existing Microsoft Access table to a database.
• Publish a table to Microsoft Excel.
Audience
The intended audience for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners
will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office
97 or 2000 programs and be familiar with Windows 9X or later operating system(s).
Total Learning Time
6 to 8 hours
Unit 1: Querying Data
1 - 2 hours
• Create a single-table query in Design view.
• Create a multiple-table query in Design view.
• Create a simple query by using the Simple Query Wizard.
• Match query wizards with their functions.
• Identify the effects of opening queries.
• Sort a query by output.
• Apply a criterion to a query.
• Apply an aggregate tool to a query.
• Add a table to a query.
• Add a calculated field to a query.
• Match the field properties with their features.
Unit 2: Forms Introduction
1 - 2 hours
• Identify features of the Form Wizard.
• Identify features of the AutoForm Wizard.
• Add a record to a form.
• Insert a picture into a field.
• Add an unbound control image to a form.
• Identify features of controls in a form.
• Add a calculated text box to a form.
• Format controls by using the Formatting toolbar.
• Match form control properties with their functions.
• Add a section to a form by using the menu bar.
• Identify functions of the Form Properties sheet.
Unit 3: Reports and Data Access Pages
2 hours
• Identify features of the Report Wizard.
• Print a report from Print Preview.
• Add a control label to a report.
• Modify a control layout in a report.
• Add a calculated text box to a report.
• Format the data display for a control in a report.
• Modify the control properties in a report.
• Add a section to a report.
• Modify the report properties in a report.
• Identify features of the Page Wizard that are used to create data access pages.
• Sort a record on a data access page in Page view.
• Group records on a data access page in Page view.
Unit 4: Database Integration
2 hours
• Identify options of the Import Spreadsheet Wizard that are used to import an Excel worksheet to a data access page.
• Link an existing Microsoft Access table to a database.
• Publish a table to Microsoft Excel.
• Publish a report to Microsoft Word.
• Export a database object to Hypertext Markup Language (HTML).
• Import an Extensible Markup Language (XML) document.
• Export a database object as an XML document.
top
MS Access 2002 Expert (MOUS XP) |
|
This course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration, shared workbooks, and consolidating data across
workbooks. This course also teaches, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools.
Learn To
• Create a new template file.
• Modify an existing template file.
• Create a new workbook by using a user-defined template.
• Create a shared workbook.
• Highlight changes in a shared workbook.
• Accept a change in a shared workbook.
• Import a delimited text file.
• Import data from a fixed-width text file.
• Import data from a database.
Audience
The intended audiences for this course are End Users and Power Users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or
managerial duties. They may be involved in working with accounting and financial data. The audience will include end users, help desk/support personnel, and other network designers. It
is expected that learners should have a working knowledge of Microsoft Windows 9x or later operating systems, and basic knowledge of either Microsoft Office 97 or 2000 programs.
Learners should have also completed courses 74030 and 74031 or have equivalent knowledge.
Total Learning Time
7 to 8 hours
Unit 1: Template and Database Integration
2 - 3 hours
• Create a new template file.
• Modify an existing template file.
• Create a new workbook by using a user-defined template.
• Open a spreadsheet solutions template.
• Enter data in a list by using the data form.
• Sort a row in a list by using multiple columns.
• Sort a column in a list by using multiple rows.
• Create a custom sort order.
• Apply a custom filter to a list.
• Summarize data in a list by using subtotals.
Unit 2: Workbook Capabilities
2 - 3 hours
• Create a shared workbook.
• Highlight changes in a shared workbook.
• Accept a change in a shared workbook.
• Merge multiple workbooks.
• Create a workspace file.
Unit 3: Data Analysis and Automation
2 hours
• Import a delimited text file.
• Import data from a fixed-width text file.
• Import data from a database.
• Create an Extensible Markup Language (XML) query.
• Identify the features of the real-time data (RTD) function.
• Export data in text file format.
• Save a workbook in XML spreadsheet format.
• Create a PivotTable.
• Identify different formats to apply to a PivotTable report.
• Change the summary functions in a PivotTable.
• Hide data in a PivotTable.
• Manipulate a field in a PivotTable.
• Identify features of a PivotChart.
• Record a macro.
• Run a macro.
• Edit a macro.
• Assign a macro to a Custom Button.
• Create a scenario.
• View a scenario.
• Create a scenario report.
• Forecast using the Goal Seek command.
• Generate the optimal solution under set constraints by using Solver.
Testing Information
Microsoft
top
|
