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