Access - Level 3

Course Content

Access - Level 3

• Lesson 1: Relational Database Design
  • Designing a Relational Database
  • Scoping the System
  • Determining the Inputs
  • Normalising a Database
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Second Normal Form Case Study
  • Third Normal Form (3NF)
  • Database Indexing
• Lesson 2: Creating a Relational Database
  • Creating a New Database File
  • Creating Lookup Tables
  • Defining a Primary Key
  • Saving and Closing a Table
  • Creating the Expense Type Table
  • Creating the Transactions Table
  • Creating the Details Table
• Lesson 3: Setting Table Relationships
  • Understanding Table Relationships
  • Understanding Lookup Relationships
  • Looking Up the Employees Table
  • Looking Up the Expense Types Table
  • Viewing Table Relationships
  • Understanding Table Joins
  • Editing the Employee Table Join
  • Editing the Expense Type Table Join
  • Creating a New Join
  • Creating a Relationship Report
• Lesson 4: Importing and Exporting Records
  • Exporting Records to Microsoft Excel
  • Exporting Records to a Text File
  • Importing from Microsoft Excel
  • Importing from a Text File
  • Linking to an External Source 
• Lesson 5: Multi Table Queries
  • Understanding Relational Queries
  • Creating a Relational Query Design
  • Filtering a Relational Query
  • Filtering Related Fields
  • Adding More Tables and Fields
  • Utilising Hidden Fields
  • Understanding Query Joins
  • Creating an Inner Join
  • Creating a Left Outer Join
  • Creating a Right Outer Join
• Lesson 6: Aggregation Queries
  • Creating an Aggregation Query
  • Working with Aggregation Queries
  • Multiple Aggregations
  • Modifying Aggregation Headings
  • Aggregating Calculated Fields
  • Applying Criteria to Aggregates
  • Understanding Nested Queries
  • Creating an Assembly Query
  • Creating the Nesting Query
• Lesson 7: Action Queries
  • Creating a Make Table Query
  • Using a Make Table Query
  • Understanding Expressions and Update Queries
  • Preparing an Update Query
  • Running an Update Query
  • Updating Using Expressions
  • Running an Expression-Based Update
  • Creating a Delete Query
  • Running a Delete Query
  • Creating an Append Query
  • Running an Append Query
  • Turning Action Messages Off
• Lesson 8: Database Security
  • Understanding Database Trust
  • Enabling Blocked Content
  • Understanding the Trust Centre
  • Creating a Trusted Location
  • Opening a Database from a Trusted Location
  • Encrypting a Database
  • Decrypting and Opening a Database
  • Removing a Database Password
  • Understanding Package and Sign
  • Creating a Self-Signed Certificate
  • Creating a Signed Package
  • Extracting and Using a Signed Package
• Lesson 9: Database Wellness
  • Compacting and Repairing a Database
  • Understanding Database Splitting
  • Using the Database Splitter
  • Managing Linked Tables
  • Checking Object Dependencies
  • Analysing Database Performance
  • Documenting a Database
• Lesson 10: An Introduction to VBA
  • Understanding VBA
  • Coding VBA for an Event
  • Running VBA Event Code
  • Understanding MsgBox and InputBox
  • Modifying an Existing Procedure
  • Understanding the Modified Code
  • Creating a Standard Module
  • Loan Simulator Code
  • Running the Code
  • Understanding the Loan Simulator Code
  • Creating a Button for the Simulator
  • Attaching the Simulator Code

FAQs

• How do I enrol in this online training?

  You can enrol in this training on our website and make an online payment using any of the following option

  • Visa Credit or Debit Card
  • MasterCard
  • American Express
  • Diners Club
  • PayPal

  Once payment is received, you will automatically receive a payment receipt and access information via email.