Microsoft Office Academic Course: Access 2010

MOAC5

Código do Curso:

MOAC5

Duração:

25 horas

Valor:

295,00 €

Este valor não inclui IVA.

Próximas Turmas:

Tags:

Para mais informações, contacte-nos!

<

Objectivo geral do curso

O conhecimento adquirido neste curso visa capacitar o formando para utilizar Microsoft Office Access 2010 como ferramenta de trabalho do seu dia-a-dia e prepará-lo para o exame Microsoft Office Academic Course: Access 2010.

Objectivos Específicos da Aprendizagem

Depois de completar este curso os formandos estarão habilitados para:


Destinatários

Destina-se a todos os que desejam aprender e dominar as funcionalidades fundamentais da aplicação Microsoft Office Access 2010 e prepararem-se para o exame Microsoft Office Academic Course: Access 2010.

Pré-Requisitos

Conhecimentos básicos de informática e de utilização do sistema operativo Microsoft Windows e o domínio a um nível intermédio do idioma Inglês (técnico).

Conteúdos Programáticos

Módulo 1: Database Essentials
Software Orientation: Microsoft Access
  • Opening Screen

Getting Started
  • Starting Access
  • Opening an Existing Database

Working in the Access Window
Software Orientation: Navigation Pane
  • Using the Navigation Pane
  • Using Object Tabs
  • Changing Views

Using the On-Screen Tools
  • Using the Ribbon
  • Using the Quick Access Toolbar
  • Using KeyTips

Software Orientation: Introducing the Backstage View
Using the Backstage View
  • Using the Backstage View

Using the Microsoft Office Access Help Button
  • Using the Help Button and Connection Status Command

Defining Data Needs and Types
  • Defining Table Fields
  • Defining and Modifying Data Types for Fields
  • Defining Database Tables

Módulo 2: Create Database Tables
Software Orientation: Getting Started with Microsoft Access
Creating a Database
  • Using a Template to Create a Database
  • Creating a Blank Database

Software Orientation: Templates Group and Application Parts
Creating a Table
  • Using the Application Parts Gallery and Quick Start

Creating a Table from Another Table
Saving a Database Object
  • Saving a Table

Módulo 3: Work with Tables and Database Records
Navigating Among Records
  • Navigating Using the Keyboard
  • Using Navigation Buttons

Software Orientation: Records Group, Record Selector Box, and Record Shortcut Menu

Entering, Inserting, Editing, and Deleting Records
  • Entering, Editing, and Deleting Records

Working with Primary Keys
  • Defining a Primary Key
  • Defining and Modifying a Multifi eld Primary Key

Finding and Replacing Data
  • Finding and Replacing Data

Attaching and Detaching Documents
  • Attaching and Detaching Documents

Sorting and Filtering Data and Setting Field Viewing Options within a Table

Software Orientation: Sort & Filter Group
  • Sorting Data within a Table
  • Filtering Data within a Table
  • Removing a Filter
  • Freezing/Unfreezing and Hiding/Unhiding Fields

Software Orientation: Relationship Tools on the Ribbon

Understanding Table Relationships
  • Defining Table Relationships
  • Modifying Table Relationships
  • Printing Table Relationships

Módulo 4: Modify Tables and Fields
Modifying a Database Table
  • Modifying Table Properties
  • Renaming a Table
  • Deleting a Table

Software Orientation: Field Properties

Creating Fields and Modifying Field Properties
  • Setting Field Properties
  • Defining Input Masks
  • Allowing Zero-Length Strings in a Field
  • Setting Memo Fields as Append Only
  • Setting Data Validation Rules
  • Entering Captions

Software Orientation: Add & Delete Group
  • Creating Fields
  • Deleting a Field
  • Creating Multivalued Fields

Módulo 5: Create Forms
Software Orientation: Forms Group

Creating Forms
  • Creating a Simple Form
  • Creating a Form in Design View
  • Creating a Form in Layout View
  • Using the Form Wizard
  • Applying a Theme

Sorting and Filtering Data within a Form
  • Sorting Data within a Form
  • Filtering Data within a Form
  • Using Filter by Form

Módulo 6: Create Reports
Software Orientation: Reports Group

Creating Reports
  • Creating a Simple Report
  • Using the Report Wizard
  • Creating a Report in Design View

Applying a Theme
  • Applying a Theme

Working with Reports
  • Sorting Data within a Report
  • Filtering Data within a Report
  • Finding Data within a Report

Módulo 7: Create and Modify Queries
Software Orientation: Queries Group

Creating a Query
  • Creating a Query from a Table
  • Creating a Find Duplicates Query
  • Creating a Query from Multiple Tables
  • Finding Unmatched Records

Software Orientation: Design Tab

Modifying a Query
  • Adding a Table to a Query
  • Removing a Table from a Query
  • Adding Criteria to a Query

Sorting and Filtering Data within a Query

Sorting Data within a Query
  • Filtering Data within a Query

Módulo 8: Use Controls in Reports and Forms
Software Orientation: Controls and Header/Footer
  • Groups in Reports and Forms

Adding Bound and Unbound Controls
  • Adding Unbound Controls
  • Adding Bound Controls
  • Adding Calculated Controls
  • Adding Controls Using a Wizard
  • Adding Button Controls Using the Wizard

Defining Control Tab Order

Software Orientation: Report Design Tools Format Tab

Formatting Controls
  • Formatting Controls
  • Formatting Controls on a Form
  • Creating Conditional Formatting on Controls

Software Orientation: Arrange Tab

Arranging Control Layout
  • Adding, Moving, and Removing a Control
  • Arranging and Anchoring Controls

Arranging Control Alignment, Size, and Position

Módulo 9: Advanced Tables
Creating a Custom Table
  • Creating a Custom Table
  • Inserting and Deleting Rows

Using the Table Analyzer
  • Using the Table Analyzer

Summarizing Table Data
  • Summarizing Table Data

Módulo 10: Advanced Forms
Software Orientation: The Templates
  • Group and the Forms Group

Creating Advanced Forms
  • Creating a Multi-Item Form
  • Creating a Split Form
  • Creating a Subform

Using Application Parts to Create
  • Blank Forms

Creating a Navigation Form

Módulo 11: Advanced Reports
Defining Groups
  • Using the Report Wizard
  • Adding Group Headers and Footers
  • Changing Grouping Options

Creating Aggregate Fields
  • Creating Aggregate Fields

Software Orientation: Print Preview Tab

Creating the Print Layout
  • Using Print Preview to Create a Print Layout

Using the Label Wizard
  • Creating Labels Using the Label Wizard

Módulo 12: Advanced Queries
Creating Crosstab Queries
  • Creating Crosstab Queries

Creating a Subquery
  • Creating a Subquery

Saving a Filter as a Query
  • Saving a Filter as a Query

Creating Action Queries
  • Creating an Append Query
  • Creating a Make Table Query
  • Creating an Update Query
  • Creating a Delete Query

Understanding Advanced Query Modification
  • Creating a Join
  • Creating a Calculated Query Field
  • Creating Aggregated Queries

Módulo 13: Display and Share Data
Creating a Chart Using the Chart Wizard
  • Creating a Chart Using the Chart Wizard

Formatting a Chart
  • Changing Chart Options
  • Changing Format Options
  • Refreshing Data in a Chart

Changing Chart Types
  • Changing Chart Types

Building a PivotChart
  • Creating a Pivot Chart
  • Formatting a PivotChart
  • Changing the PivotChart Type

Saving a Database Object as Another File Type
  • Using the Save & Publish Tab

Printing a Database Object

Módulo 14: Import and Export Data
Software Orientation: External Data Tab

Importing Data
  • Importing Data from a Specific Source
  • Linking to an External Data Source

Saving and Running Import Specifications
  • Saving Specifi cations
  • Running Import Specifications

Exporting Data
  • Exporting from a Table
  • Exporting from a Query

Saving and Running Export Specifications
  • Saving Export Specifications
  • Running Export Specifications

Módulo 15: Database Tools
Maintaining a Database
  • Backing Up a Database
  • Saving as a Previous Version
  • Compacting and Repairing a Database

Setting Database Properties

Encrypting a Database
  • Encrypting and Decrypting a Database

Configuring Database Options
  • Configuring Database Options

Software Orientation: Database Tools Tab

Using Database Tools
  • Identifying Object Dependencies
  • Using the Database Documenter
  • Splitting a Database

Metodologia

Os cursos são presenciais e os módulos de cada curso são compostos por:
  • Uma parte teoria, em que o formador apresenta, explica e dá exemplos de utilização das funcionalidades da aplicação
  • Uma parte demonstrativa, em que o formador demonstra a utilização das funcionalidades da aplicação na prática
  • Uma parte de laboratório, em que os formandos são desafiados a fazer simulações de casos práticos e exercícios, para praticar e solidificar a sua aprendizagem
  • A carregar as mensagens do Twitter...