Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Access 2019 – Level 2

  • Course Code:

    50533
  • Course Duration:

    1 Day
  • Course Price:

    $395.00
  • Availability:

    Call/Email to register interest
  • Overview & ObjectivesOpen or Close

    This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Access.

    This course is intended for information workers who want to learn intermediate-level Access skills.

     

     

  • Skills GainedOpen or Close

    At Course Completion students will be able to:

    • Restrict the type of data
    • Restrict the amount of data
    • Restrict the format of data
    • Restrict data by using validation rules
    • Restrict data to values in lists
    • Restrict data to values in other tables
    • Modify forms created by using a wizard
    • Add controls
    • Add subforms
    • Use e-mail forms to collect data
    • Create queries by using a wizard
    • Create queries manually
    • Use queries to summarize data
    • Use queries to perform calculations
    • Use queries to update records
    • Use queries to delete records
    • Create reports manually
    • Modify report content
    • Add subreports
  • Course ModulesOpen or Close

    Course OutlineModule 1: Maintain Data Integrity

    This module explains how to ways to help ensure the accuracy of data entered into a database.

     

    Lessons

    • Restricting the Type of Data
    • Restricting the Amount of Data
    • Restricting the Format of Data
    • Restricting Data by Using Validation Rules
    • Restricting Data to Values in Lists
    • Restricting Data to Values in Other Tables

    Lab: Restricting the Type of Data

    • Add fields with various data types

    Lab: Restricting the Amount of Data

    • Change the Field Size property of various fields

    Lab: Restricting the Format of Data

    • Use input masks to guide data entry

    Lab: Restricting Data by Using Validation Rules

    • Create and test validation rules

    Lab: Restricting Data to Values in Lists

    • Use the Lookup wizard to create a list

    Lab: Restricting Data to Values in Other Tables

    • Display a list of values from another table

    After completing this module, students will be able to:

    • Restrict the type and amount of data entered into a field.
    • Require that data entered in a field be in a certain format.
    • Use validation rules to prohibit invalid data.
    • Limit the options for entering information in a database.
    • Create a list of possible values for a field from the entries in a field in a related table.

     

    Module 2: Create Custom Forms

    This module explains how to customize forms to facilitate data entry and display.

     

    Lessons

    • Modifying Forms Created by Using a Wizard
    • Adding Controls
    • Adding Subforms
    • Using E-Mail Forms to Collect Data

    Lab: Modifying Forms Created by Using a Wizard

    • Use the Form wizard to create a form, and then modify it

    Lab: Adding Controls

    • Add and delete controls

    Lab: Adding Subforms

    • Add a subform to an existing form

    After completing this module, students will be able to:

    • Work in Design view to modify a form.
    • Customize forms by adding controls.
    • Use subforms to enter data in more than one table.

    Module 3: Create Queries

    This module explains how to use the Query wizard to create a select query, how to use the Query Designer to created less common queries, and how to perform calculations and update and delete table information.

    Lessons

    • Creating Queries by Using a Wizard
    • Creating Queries Manually
    • Using Queries to Summarize Data
    • Using Queries to Perform Calculations
    • Using Queries to Update Records
    • Using Queries to Delete Records

    Lab: Creating Queries by Using a Wizard

    • Create a query based on two related tables

    Lab: Creating Queries Manually

    • Create a parameter query manually

    Lab: Using Queries to Summarize Data

    • Summarize the values in records selected by a query

    Lab: Using Queries to Perform Calculations

    • Create a query that displays calculation results in a new field

    Lab: Using Queries to Update Records

    • Create a query to update table data

    Lab: Using Queries to Delete Records

    • Create a query to delete table data

    After completing this module, students will be able to:

    • Create queries to find records and create calculated fields.
    • Summarize matched records.
    • Have Access update and delete records.

     

    Module 4: Create Custom Reports

    This module explains how to extract information from a database as a report. It also explains how to modify a report content and add a subreport.

     

    Lessons

    • Creating Reports Manually
    • Modifying Report Content
    • Adding Subreports

    Lab: Creating Reports Manually

    • Create a report from scratch

    Lab: Modifying Report Content

    • Modify the content of a report

    Lab: Adding Subreports

    • Add a subreport with calculations to a main report

    After completing this module, students will be able to:

    • Create reports to extract information from a database.
    • Customize the appearance and contents of a report.
    • Insert a subreport within a report and perform calculations in it.

     

  • PrerequisitesOpen or Close

    Before attending this course, students must have:

    • Basic computer knowledge.
    • Basic file-management skills.
    • Basic knowledge of the Access interface and database, table, and form creation and manipulation.

     

Hav a question

Have a Question?

Give us a Call

Contact Us
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NDc2Mjg0NjEzMzgiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
Excel 2013 – Level 2
November 26, 2015 25% off
Thank You. We will contact you as soon as possible.
Featured Course: Excel Level 2
Learn to use excel with this intermediate level one day course from MIS Global Technologies and gain the following skills:
  • VLOOKUP
  • Reference functions
  • Use Database Tables
  • Data Validation tools
  • Use Hyperlinks
  • Protect workbooks
CONTACT US
Thank You. We will contact you as soon as possible.
Excel Level 2
Featured Course: Office 365
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services. You will learn how to:
  • Implement and Manage Identities by Using DirSync
  • Manage Clients and End-User Devices
  • Provision SharePoint Online Site Collections
  • Configure Exchange Online and Lync Online for End Users
CONTACT US
Thank You. We will contact you as soon as possible.
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NTU1MTI2NDQyNTAiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
MIS Global Technologies
Phone: 1300 731 939
Suite 513, Level 5 Westfield Office Tower
159-175 Church Street Parramatta NSW 2150
Thank You. We will contact you as soon as possible.
We're happy to answer any questions you may have or provide you with any help you need when choosing the course that's right for you. Please leave a message in the form below and one of our friendly staff will get back to you as soon as possible
Thankyou! Your enquiry has been sent successfully. One of our friendly staff will get back to you soon. For anything urgent you can always call us on 1300 731 939
Featured Course: Excel Level 1
Learn to use excel with our one day course for beginners at MIS Global Technologies and learn about the following:
  • How to enter and edit data
  • How to Insert rows and columns
  • The BEDMAS rule
  • How to format dates
  • How to modify the header or footer
Reserve Your Place Today
Thank You. We will contact you as soon as possible.
Excel Level 2
Please leave a message and let us know which course you are interested in taking with us. One of our friendly staff will contact you as soon as they are available and will help you with your studies.
Thank you for your interest