Access 2013

Was bietet Ihnen dieser Kurs?

In this elearning course, you will learn how to effectively use Microsoft Access 2013 for both your individual needs and for the development of complex business solutions. You will gain an introduction to the planning of databases, structuring data and the creation of the required tables. You define data types, field properties and relationships between your different tables. Furthermore, you get to know how to set filters, create queries for evaluation and will learn how to simplify data input and maintenance via forms and create professional reports.


Kurs Eckdaten

In addition to the instructional content, practice exercises and test questions are also included.

50
NUMBER OF LESSONS
5
LEARNING HOURS
2.5
AUDIO HOURS
 


Der Lerninhalt im Wesentlichen

  • What is a database?
  • Structure of a database
  • Starting and exiting Access
  • The Access application window
  • Opening a database
  • Creating a database

  • Planning a database
  • Tables and data fields
  • Creating a table in the design view
  • Defining field properties
  • Using the input mask
  • Using the output format
  • Creating a validation rule
  • Assigning an index
  • Defining lookup list

  • Entering and editing data in a table
  • Copying data between programs
  • Changing the datasheet view
  • Sorting data records
  • Finding and replacing data

  • Basics of relationships
  • Referential integrity
  • Setting up and deleting relationships
  • Showing dependent data

  • What are filters?
  • Using operators
  • Using selection-based filters
  • Using form-based filters
  • Saving form-based filters

  • What are queries?
  • Creating simple queries with the wizard
  • Creating select queries in the design view
  • Editing a query
  • Queries for table creating and deletion

  • Creating AutoForms
  • Creating forms with the wizard
  • Editing forms in the layout view
  • Entering and editing text

  • Creating basic reports
  • Creating reports with the wizard
  • The print preview
  • Printing and exporting data

Systemanforderungen Client

Windows

  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 oder höher
  • Bei den Sicherheitseinstellungen muss der Eintrag “ActiveX-Steuerelemente ausführen, die für Scripting sicher sind“ aktiviert sein.

* Ab der IE Version 8 und höher der IE in den "IE7 Kompatibilitätsmodus" geschaltet wird, um eine einwandfreie Darstellung der Inhalte zu gewährleisten.


Über Uns

EXPAND Global bietet Lerntechnologie und -inhalte für den Arbeitsplatz der Zukunft. Wir sind Experten für innovative Lernwerkzeuge, Entwicklung von E-Learning Inhalten, Off-the-Shelf E-Learning für Microsoft Office, Microlearning, mobiles Lernen, Gamification and Performance Support.

 

Kontaktieren Sie uns