Imate žicu za učenje?

Access 2010 Macros and VBA

Overview/Description Using Access macros and Visual Basic for Applications (VBA) code, you can easily add functionality to a database to suit your business needs. This course provides an introduction to programming in Access 2010 and explores when to use macros or VBA code to automate processes. It demonstrates how to create and modify different types of macros as well as how to specify actions, conditions, and event handlers. Target Audience A broad range of business users Expected Duration (hours) 1.0 Lesson ObjectivesAccess 2010 Macros and VBA create macros execute macro actions...

Advanced Importing and Exporting with Access 2010

Overview/Description Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010. Target Audience A broad range of business users...

Joins, SQL, and Action Queries in Access 2010

Overview/Description Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries. Target Audience A broad range...

Optimizing, Securing, and Sharing Access 2010 Databases

Overview/Description Access 2010 provides a variety of tools to assist you in optimizing, securing, and sharing a database application. This course demonstrates how to assess a database's performance and improve its efficiency. Also covered are the ways that you can secure a database for users and the common methods employed to share a completed database application. Target Audience A broad range of business users Expected Duration (hours) 1.0 Lesson ObjectivesOptimizing, Securing, and Sharing Access 2010 Databases use the Performance Analyzer to assess and improve database performance use...

PivotTables and PivotCharts in Access 2010

Overview/Description This course demonstrates how to create and manipulate PivotTables and PivotCharts as an effective way to organize and display Access 2010 database data, such as showing and hiding data, sorting and filtering data, performing basic and complex calculations, and exporting to an Excel spreadsheet. Target Audience A broad range of business users Expected Duration (hours) 1.0 Lesson ObjectivesPivotTables and PivotCharts in Access 2010 identify key characteristics of Access PivotTables create a PivotTable in an Access database use a PivotTable to analyze data create a...

Retrieving, Validating, and Attaching Data in Access 2010

Overview/Description You can use Microsoft Access 2010 to manage your data efficiently using advanced techniques. There are many 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 advanced techniques for retrieving and validating data in Access 2010. These include such features as lookup fields and using the Expression Builder to aid in the validation of controls. How to attach files to tables and forms, and edit them, is also demonstrated. Target Audience A broad range of...

Subforms, Subreports, and Conditional Formatting in Access 2010

Overview/Description Subforms and subreports allow you to display related data from separate sources in a single interface in Access 2010. This course will demonstrate how to use Access 2010 to create and use subforms and subreports. It also explores how to apply conditional formatting to tables, forms, and reports using the streamlined conditional Formatting Rules Manager. Target Audience A broad range of business users Expected Duration (hours) 1.0 Lesson ObjectivesSubforms, Subreports, and Conditional Formatting in Access 2010 create subforms set the default view of a subform create...

Using Access 2010 with SharePoint and Access Services

Overview/Description Access 2010 and Windows SharePoint Services provide a tightly integrated solution for making Access databases web capable. This course details the primary features that allow for the seamless integration of Access and SharePoint so that data can be shared across corporate networks or the Internet. It demonstrates how to share Access and SharePoint data, and how Access and SharePoint work together with a new feature called Access Services to make entire applications available through SharePoint. Target Audience A broad range of business users Expected Duration (hours) 1.0...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?