|
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.
Total Items: 6 Total Time: 9 hour(s)
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
- Activities allow learners to apply course concepts in an interactive questioning environment.
- Exercises allow learners to practice in the actual application being studied.
- Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
- 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.
Lesson 1: Introduction to Access - 1 Hours
Summary:
This course provides information on the Access 2007 interface, creating a database using templates, and the available database views.
Objectives:
After completing this course, students will be able to:
- 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
Lesson 2: Creating Tables - 2 Hours
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:
After completing this course, students will be able to:
- 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 tables
Topics:
Lesson 3: Working withTables - 2 Hours
Summary:
This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships.
Objectives:
After completing this course, students will be able to:
- 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
Lesson 4: Creating Forms - 2 Hours
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:
After completing this course, students will be able to:
Lesson 5: Creating Reports - 1 Hours
Summary:
This course provides information on creating reports using Access 2007
Objectives:
After completing this course, students will be able to:
- Create a basic report
- Create a report using the Report Wizard
- Create a customized report
Lesson 6: Queries and Filters- 1 Hours
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:
After completing this course, students will be able to:
- 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:
- Formatting
- Input masks
- Validating data
- Table relationships
|
 Learn at your own pace
|
| Learn anytime, anywhere |
| No software to load |
| Online Instant Mentor 24x7 (Optional) |
| One time payment - No monthly fee |
| Unlimited learning for a year, 24X7 |
| No books to read |
| Use the course index for review anytime |
| 3 Days, 100% Money back guarantee |
|
Technical Requirements:
200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.
|
Cookies:
Cookies must be enabled.
|
Popup Blockers:
all pop-up blockers are disabled.
|
Firewalls:
Make sure any personal firewall programs allow mindleaders.com as a trusted site.
|
|
