fbpx

Microsoft Access 2019 edasijõudnutele (e-õpe, inglise keeles)

Koolituse maht: 16 akadeemilist tundi ehk 2 õppepäeva, mille saad endale sobivale ajale jaotada.

Sihtgrupp: Students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

Koolitusel osalemise eeldused:

Experience in the following is required for this Microsoft Access class:

  • Introductory-level knowledge and skills working with Microsoft Access.

To complete the training and get a certification you need to pass the quiz 100%.

Koolituse teemad

This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

1. Relationships

  • Review
  • Referential Integrity
  • Relationships
    1. Data Types and Relationships
    2. Formalize the Relationship between Tables
  • A Few Words about Naming Conventions
  • Exercise: Creating Relationships

2. Queries

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries
    1. Make Table Queries
    2. Append Queries
    3. Update Queries
    4. Delete Queries
    5. Creating Crosstab Queries
    6. Delete a Query
    7. Rename a Query
  • Exercise: Creating Select and Action Queries
  • Exercise: Creating a Parameter Query

3. Table Functions

  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from other Databases
  • Tables from Templates and Application Parts
  • Exercise: Importing Data from Excel
  • Exercise: Exporting Data to Excel

4. Forms

  • Design View
    1. Form Sections
    2. Adding a Header and Footer
    3. Adding a Logo to the Header
    4. Adding a Title to the Header
    5. Adding Fields to a Form
    6. Arranging Fields on a Form
    7. Spacing Objects on a Form
  • Formatting
  • Tab Order
    1. Setting Properties on a Form
    2. Controls
  • Create Forms with Application Parts
  • Creating a Subform
  • Exercise: Creating Forms
  • Alter a Form
    1. Delete Forms
    2. Remove Form Controls
    3. Format a Form

5. Reports

  • Design View
  • Report Sections
    1. Report Header
    2. Page Header
    3. Group Header
    4. Detail
    5. Group Footer
    6. Page Footer
    7. Report Footer
    8. Adding a Report Header/Footer
    9. Adding a Logo to the Report Header
    10. Adding a Title to the Report Header
    11. Adding Fields to a Report
    12. Add Calculated Fields
  • Arranging Fields on a Report
  • Resizing the Detail Section
    1. Eliminating Repeating Headings
    2. Set Margins
  • Grouping and Sorting
  • Setting Properties on a Report
    1. Report Property Sheet
    2. Section Property Sheet
    3. Object Property Sheet
    4. Adding Record Counts
  • Special Report Fields
    1. Dates
    2. Page Numbering
  • Controls
    1. Printing a Report
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report
    1. Adding a Background and Images and Applying a Theme
  • Exercise: Creating Reports

6. Macros

  • Macro Basics
    1. Open a Table, Form, and Report
    2. Run a Query
    3. Print a Report
  • Running a Macro
  • Exercise: Creating Simple Macros

7. Completing the Desktop Application

  1. The Navigation Form
  2. Running Macros from a Navigation Form
  3. Setting the Navigation Form as the Default Form
  4. Exercise: Creating a Navigation Form
  5. Splitting the Database
    1. Encrypt with a Password
  6. Distributing the Front-End Database
  7. Database Maintenance
    1. Compact and Repair
    2. Backup/Recover a Database
    3. Maintain Backward Compatibility

Koolituse eesmärk

The main purpose of this online course is to give students advanced-level skills in Microsoft Access 2019.

Koolituse õpiväljundid

After completing this course, students will:

  • Learn about database relationships.
  • Learn to work with table relationships.
  • Learn to work with queries at an advanced level.
  • Learn to work with forms at an advanced level..
  • Learn to work with reports at an advanced level.
  • Learn to work with macros.
  • Learn to complete the desktop application with the navigation form.

Koolitus toimub e-õppe keskkonnas, kuhu saab siseneda isikliku kasutajanime ja parooliga. Need saadetakse Teile pärast koolitusarve tasumist või erikokkuleppel.

Täiendkoolituse õppekava rühm: arvutikasutus

Registreerimine

Koolitusel osalemine
Vabu kohti: saadaval
The Koolitusel osalemine ticket is sold out. You can try another ticket or another date.

Kuupäev

11.jaan. 2020 - 12.jaan. 2020

Hind

220€ +km
Valdkonnad
Registreerimine

Koolitaja