Description: Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively.
This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Duration: 00:51
Description: Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Duration: 01:00
Description: Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries.
This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Duration: 01:00
Description: Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table.
This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Duration: 01:00
Description: Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information.
This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Duration: 00:38