Please use our Learning Needs Analysis (LNA) to check your knowledge and experience in various application packages.

Once you have submitted your results we would be able to recommend you the appropritae course for your learning requirements.

At Phoenix Solutions4all we endeavour to treat all delegates in an individual way and therefore ask you to fill in this form so that we are able to put together a course that is most suited to you.​

For each question you are given the choice of 4 responses labelled A-D. Please choose one response that most accurately describes your knowledge level for each topic. Please note that this is not a test.

    A

    NO KNOWLEDGE

    I have never used it before or do not fully understand the topic.

    B

    BASIC KNOWLEDGE

    I have only the basic understanding of the topic and would prefer to cover it if possible

    C

    GOOD KNOWLEDGE

    I understand most of it - there may be gaps but it is not essential for me to cover the topic

    D

    COMPLETE KNOWLEDGE

    I understand it fully - use it often.

    Fields marked with * are mandatory

    Application

    Course Name

    First Name*

    Last Name*

    Email*

    Phone

    Company*

    Department*

    BASIC KNOWLEDGE

    GOOD KNOWLEDGE

    COMPLETE KNOWLEDGE

    NO KNOWLEDGE

    Fundamentals

    1.

    Stating a New Database

    2.

    Opening an Existing Database

    3.

    Closing a Database

    Table

    1.

    Creating a Table in Design View

    2.

    Defining Field Names and Data Types

    3.

    Setting Primary Keys

    4.

    Composite Primary Keys

    5.

    Entering Field Properties

    6.

    Adding Input Masks

    7.

    Applying Validation Rules and Text

    8.

    Inserting Additional Fields

    9.

    		[hidden Question default:Delete, Rename and Reorder Fields "Delete, Rename and Reorder Fields"]

    Delete, Rename and Reorder Fields

    10.

    Field Name Conventions

    11.

    Captions/ Labels for fields

    12.

    Switching between Design and Table Views

    13.

    Entering Data into a table

    14.

    Modifying Data in a table

    15.

    Formatting Tables

    16.

    Create a calculated field

    17.

    Finding & Replacing Data

    18.

    Hiding and Unhiding Fields

    19.

    Freezing Columns

    20.

    Renaming and Copying Tables

    21.

    Importing data from Excel

    22.

    Linking to a different Database Table

    23.

    Creating a Filter by selection

    24.

    Creating a Filter by form

    25.

    Saving a filter by form as a select query

    26.

    Creating relationships between tables

    27.

    Applying different types of relationships

    28.

    Applying Referential Integrity

    29.

    Cascading Updates and Deletions

    30.

    Joining Tables for a query

    Query

    1.

    Running a Select Query

    2.

    Creating a Query from the Query Window

    3.

    Adding Fields to a query

    4.

    Suppress the display of a field in a query

    5.

    Removing Fields from a query

    6.

    		[hidden Question default:Text, numeric, date, and logic criteria "Text, numeric, date, and logic criteria"]

    Text, numeric, date, and logic criteria

    7.

    Using Wild Card Characters in a query

    8.

    Working with multiple criterion

    9.

    		[hidden Question default:Using BETWEEN, AND, OR, NOT, NULL, IN "Using BETWEEN, AND, OR, NOT, NULL, IN"]

    Using BETWEEN, AND, OR, NOT, NULL, IN

    10.

    Creating Calculated fields in queries

    11.

    Using Simple Query Wizard

    12.

    Running Multiple Table Queries

    13.

    Using Find Unmatched Query Wizard

    14.

    Using Find Duplicates Query Wizard

    15.

    Generating Advanced Calculated fields

    16.

    Using Parameter Queries

    17.

    Calculating Totals in Queries

    18.

    Using Crosstabs Queries Wizard

    19.

    Using Action Queries

    Form

    1.

    Creating Forms using Auto Form

    2.

    Creating Forms Using the Form Wizard

    3.

    Data Entry in Forms

    4.

    Resizing and Moving Controls

    5.

    Formatting Controls

    6.

    Using Format Painter

    7.

    Changing Text Attributes

    8.

    Inserting Moving Sizing and Deleting Fields

    9.

    Resizing Forms

    10.

    Displaying Properties of an item

    11.

    Creating Sub Forms

    12.

    Setting Form Properties

    13.

    Calculations within Forms

    14.

    Combining Text Values

    15.

    Changing the Data Source of the form

    16.

    Changing the Tab Key Order on the forms

    17.

    Using the Forms Toolbox

    Report

    1.

    Generating Standard Reports using Wizard

    2.

    Inserting and Deleting Controls on Reports

    3.

    Customising Reports

    4.

    Using Expressions on Reports

    5.

    Adding Sub Reports

    6.

    Creating Parameter Reports

    7.

    Generating Mailing Labels

    8.

    Creating a Chart

    9.

    Formatting a Chart

    10.

    Changing the type of chart

    Macro

    1.

    		[hidden Question default:Creating, Editing and Deleting a Macro "Creating, Editing and Deleting a Macro"]

    Creating, Editing and Deleting a Macro

    2.

    Running a Macro

    3.

    		[hidden Question default:Macro Action(s) "Macro Action(s)"]

    Macro Action(s)

    4.

    Autokeys

    5.

    Conditional Macro

    6.

    Generating a Message Box

    Advanced Features

    1.

    Designing a Switchboard

    2.

    Formatting Switchboard Forms

    3.

    Creating a Splash Screen

    4.

    Using Autoexec

    5.

    Customise Ribbon and Quick Access Toolbar

    6.

    Creating a Custom Tab

    7.

    Sample Subroutine

    8.

    Sample Function

    Many thanks for completing the LNA form.

    Please use the comment box below to tell us any topics or features of the application that you think
    would benefit you at your workplace:

                        Contact Us Now

                        Our services are bespoke and can be tailored to your company’s requirements upon request. 

                        Why not talk to us today?