Utbildningar

QA-DAC13L3

Ladda ner som PDF

Microsoft Access 2013 Level 3

You've covered many of the basic functions of Microsoft Access and now you're ready to learn advanced Access features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Target Audience:

Your training in and use of Microsoft Access 2013 has provided you with a solid foundation in the basic and intermediate skills. You have worked with the various Access objects, such as tables, queries, forms and reports.

Prior knowledge

  • Understand the steps required to properly design a database
  • Create a database
  • Create tables and table relationships
  • Control data entry with field properties
  • Create queries and understand query joins
  • Create reports and subreports
  • Add and format controls on forms and reports
  • Import and export data

Objectives:

At the end of this course you will be able to:

  • Create and customise advanced forms
  • Work with data validation
  • Create and revise Access 2013 macros
  • Use tools to manage database efficiency
  • Distribute and secure databases
  • Work with switchboards and startup options

Course Outline:

Lesson 1: Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Create Subforms
  • Topic C: Organise Information with Tab Pages
  • Topic D: Enhance Navigation of Forms
  • Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Topic A: Field and Record Validation
  • Topic B: Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Topic A: Create a Macro
  • Topic B: Restrict Records Using a Condition
  • Topic C: Validate Data Using a Macro
  • Topic D: Automate Data Entry Using a Macro
  • Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Topic A: Link Tables to External Data Sources
  • Topic B: Manage a Database
  • Topic C: Determine Object Dependency
  • Topic D: Document a Database
  • Topic E: Analyse the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Topic A: Splitting a Database for Multiple User Access
  • Topic B: Implement Security
  • Topic C: Set Passwords
  • Topic D: Convert an Access Database to an ACCDE File
  • Topic E: Package a Database with a Digital Signature

Objectives:

At the end of this course you will be able to:

  • Create and customise advanced forms
  • Work with data validation
  • Create and revise Access 2013 macros
  • Use tools to manage database efficiency
  • Distribute and secure databases
  • Work with switchboards and startup options

Course Outline:

Lesson 1: Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Create Subforms
  • Topic C: Organise Information with Tab Pages
  • Topic D: Enhance Navigation of Forms
  • Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Topic A: Field and Record Validation
  • Topic B: Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Topic A: Create a Macro
  • Topic B: Restrict Records Using a Condition
  • Topic C: Validate Data Using a Macro
  • Topic D: Automate Data Entry Using a Macro
  • Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Topic A: Link Tables to External Data Sources
  • Topic B: Manage a Database
  • Topic C: Determine Object Dependency
  • Topic D: Document a Database
  • Topic E: Analyse the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Topic A: Splitting a Database for Multiple User Access
  • Topic B: Implement Security
  • Topic C: Set Passwords
  • Topic D: Convert an Access Database to an ACCDE File
  • Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

  • Topic A: Create a Database Switchboard
  • Topic B: Modify a Database Switchboard
  • Topic C: Set Startup Options

Utbildningen levereras i samarbete med

Kurs-ID: QA-DAC13L3
Längd: 1 dagar
Pris exkl moms: 4 176 kr

Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.

Tipsa