Vi ste ovdje
Overview/Description
You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports, as well as applying conditional formatting in Access 2007 tables, forms, and reports. Advanced query methods make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a...
Overview/Description
Microsoft Office Access 2007 offers several options for creating, customizing, and managing forms. This course describes multiple methods of form creation, including the Form, Split Form, Multiple Items, Blank Form, and Form Design tools and the Form Wizard. This course also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. The course demonstrates how forms can be customized using autoformat, or by adding the date and time, page numbers, logos, and other...
Overview/Description
Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive, and provides you with easier data manipulation techniques. This course explains the use of table templates, Design and Datasheet views, field creation, data types, and modifiable properties, and demonstrates the use...
Overview/Description
Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in...
Overview/Description
With Access 2007, Microsoft introduces some of the most significant changes to Access in years. Most notable is the intuitive new user interface that replaces the traditional menus and toolbars with features like the Ribbon, the Quick Access Toolbar, and the Microsoft Office button. This course provides an introduction to Access 2007 and demonstrates how to navigate within the new user interface. The introductory steps in planning a database, the components and views of an Access database, and database creation methods are also covered.
Target Audience
End-users seeking...
Overview/Description
Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and SharePoint lists. You can also export data and objects from an Access 2007 database to external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources. It also describes how to create and modify...
Overview/Description
SkillSoft Mentors are available to help students with their studies for the Using Access 2007 exam. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (hours)
0.0
Lesson...
Overview/Description
Microsoft Office Access 2007 makes it easy for you to share and manage data using the collaborative environment of a Microsoft Windows SharePoint site along with the many data management features available within Access 2007. This course explains how SharePoint sites can be used with Access and demonstrates options such as moving data to a SharePoint site, publishing data to a SharePoint site, importing from or linking to a SharePoint list, creating an Access view of a SharePoint list, working offline with SharePoint lists, as well as tracking data versioning in...
Overview/Description
Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying...
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment,...