12 Month Subscription - $35
|
Summary:
This series covers how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data.
Audience:
This course is for anyone who wants to learn more about Access 2007.
Features:
● Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
● Audio accompanies each lesson page throughout the course.
● Show Me Hows allow learners to access instructional demonstrations from all courses in the series.
● Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
● Activities allow learners to apply course concepts in an interactive questioning environment.
● Full-page images allow learners to experience an application as if it were open on their computer.
● Exercises allow learners to practice in the actual application being studied.
● A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
● Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
● Search text enables learners to rapidly search all text within a course to easily retrieve information required.
● Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
● A skill assessment generates a customized learning path based on the results of a pre-test.
● A glossary provides a reference for definitions of unfamiliar terms.
● Bookmarking tracks a learner's progress in a course.
Topics included in this course:
Access 2007 Series: Introduction to Access
Access 2007 Series: Creating Tables
Access 2007 Series: Working with Tables
Access 2007 Series: Creating Forms
Access 2007 Series: Creating Reports
Access 2007 Series: Creating Queries and Filters
Access 2007 Series: Introduction to Access
Summary:
This course provides information on the Access 2007 interface, creating a database using templates, and the available database views.
Objectives:
Use the Ribbon to access command buttons and groups
Use the Office menu to access commands dealing with the whole application or database
Use the Navigation Pane to view and open database objects
Start a new database by using templates provided by Microsoft Office Online
Topics:
The interface
Creating a database
Views
top
Access 2007 Series: Creating Tables
Summary:
This course provides details about creating tables in Access 2007, as well as how to add and delete records and tables from a database. It also covers basic database terminology, data types, primary keys, flat files, and relational databases.
Objectives:
Recognize data types and basic database terminology
Add and delete fields from a table
Set the primary key for a table
Identify flat files and relational databases
Create simple tables
Add, modify, and delete records from a table
Topics:
Database terminology
Data types
Adding and deleting fields
Primary keys
Flat files and relational databases
Creating tables
Adding, modifying, and deleting records
top
Access 2007 Series: Working with Tables
Summary:
This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships.
Objectives:
Apply basic formatting to a database table
Create input masks for table fields
Create validation rules for table fields
View and modify the relationships between tables
Topics:
Formatting
Input masks
Validating data
Table relationships
top
Access 2007 Series: Creating Forms
Summary:
This course provides information on creating forms in Access 2007, including simple forms, more complex multiple items forms, and split forms. It also shows how to create customized forms using the Form Wizard.
Objectives:
Create simple forms using the Form button
Create split and multiple items forms
Use the Form Wizard to create customized forms
Edit and customize a form using Form Design view
Topics:
Creating and Modifying Simple Forms
Creating Complex Forms
Using the Form Wizard
Form Design
top
Access 2007 Series: Creating Reports
Summary:
This course provides information on creating reports using Access 2007.
Objectives:
Create a basic report
Create a report using the Report Wizard
Create a customized report
Topics:
Creating Basic Reports
Using the Report Wizard
Report Design
top
Access 2007 Series: Creating Queries and Filters
Summary:
This course provides information on how to use queries and filters to search and sort your database tables. It shows how to filter using the Sort and Filter feature and how to build queries using the Query Wizard.
Objectives:
Explain the difference between a query and a filter
Apply sorts and filters to your tables
Build a query using the Query Wizard
Add query criteria to narrow the focus of your queries
Topics:
Defining queries and filters
Sorting and filtering
Simple queries
Using query criteria
top
12 Month Subscription - $35
|
