Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Access 2019 – Level 1

  • Course Code:

    50532
  • 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 beginning level Access skills.

  • Skills GainedOpen or Close

    At Course Completion students will be able to:

    • Work in Access
    • Understand database concepts
    • Explore tables
    • Explore forms
    • Explore queries
    • Explore reports
    • Preview and print Access objects
    • Create databases from templates
    • Create databases and tables manually
    • Manipulate table columns and rows
    • Refine table structure
    • Create relationships between tables
    • Create forms by using the Form tool
    • Change the look of forms
    • Change the arrangement of forms
    • Sort information in tables
    • Filter information in tables
    • Filter information by using forms
    • Locate information that matches multiple criteria
    • Create reports by using a wizard
    • Modify report design
    • Preview and print reports
  • Course ModulesOpen or Close

    Module 1: Explore an Access Database

    This module discusses the Access interface and explores various database components, including tables, forms, queries, and reports.

     

    Lessons

    • Working in Access
    • Understanding Database Concepts
    • Exploring Tables
    • Exploring Forms
    • Exploring Queries
    • Exploring Reports
    • Previewing and Printing Access Objects

    Lab: Working in Access 2010

    • Explore the program window

    Lab: Exploring Tables

    • Explore tables

    Lab: Exploring Forms

    • Explore forms

    Lab: Exploring Queries

    • Explore queries

    Lab: Exploring Reports

    • Preview a report

    Lab: Previewing and Printing Access Objects

    • Preview and print database objects

    After completing this module, students will be able to:

    • Work in the Access environment.
    • Describe how a database works.
    • Open and move around in tables, forms, queries, reports, and other Access objects.
    • Preview and print objects, such as tables and forms.

     

    Module 2: Create Databases and Simple Tables

    This module explains how to create databases and tables, either manually or from templates, and how to change table formatting and structure. It also explains how to create relationships between tables.

     

    Lessons

    • Creating Databases from Templates
    • Creating Databases and Tables Manually
    • Manipulating Table Columns and Rows
    • Refining Table Structure
    • Creating Relationships Between Tables

    Lab: Creating Databases from Templates

    • Use a template as the basis for a database

    Lab: Creating Databases and Tables Manually

    • Create a table in a blank database, and then add records

    Lab: Manipulating Table Columns and Rows

    • Change table formatting

    Lab: Refining Table Structure

    • Change table structure

    Lab: Creating Relationships Between Tables

    • Create relationships between tables

    After completing this module, students will be able to:

    • Create databases in various ways.
    • Add tables to a database.
    • Rearrange and size table columns and rows.
    • Modify, add, and delete table fields.
    • Define table relationships.

     

    Module 3: Create Simple Forms

    This module explains how to create forms to view and enter data, modify the appearance of a form, and customize the layout of a form.

     

    Lessons

    • Creating Forms by Using the Form Tool
    • Changing the Look of Forms
    • Changing the Arrangement of Forms

    Lab: Creating Forms by Using the Form Tool

    • Create a form that uses all the fields in a table

    Lab: Changing the Look of Forms

    • Change a form’s appearance

    Lab: Changing the Arrangement of Forms

    • Arrange form labels and controls

    After completing this module, students will be able to:

    • Use the Form Tool to create a form based on a table.
    • Change the form’s properties.
    • Change the form’s layout.

     

    Module 4: Display Data

    This module explains how to display information in useful ways, by sorting and filtering tables, and by filtering information in forms.

     

    Lessons

    • Sorting Information in Tables
    • Filtering Information in Tables
    • Filtering Information by Using Forms
    • Locating Information That Matches Multiple Criteria

    Lab: Sorting Information in Tables

    • Sort a table in various ways

    Lab: Filtering Information in Tables

    • Filter a table

    Lab: Filtering Information by Using Forms

    • Use the Filter By Form command

    Lab: Locating Information That Matches Multiple Criteria

    • Find information that matches two criteria

    After completing this module, students will be able to:

    • Find information by sorting and filtering in tables.
    • Display information by filtering in forms.
    • Use the Advanced Filter/Sort command to find records that meet multiple criteria.

     

    Module 5: Create Simple Reports

    This module explains how to extract information from a database as a report. It also explains how to modify report design and preview and print reports.

     

    Lessons

    • Creating Reports by Using a Wizard
    • Modifying Report Design
    • Previewing and Printing Reports

    Lab: Creating Reports by Using a Wizard

    • Use a wizard to produce a report

    Lab: Modifying Report Design

    • Change the layout and formatting of a report

    Lab: Previewing and Printing Reports

    • Preview and fine-tune a report

    After completing this module, students will be able to:

    • Create reports to extract information from a database.
    • Customize the design of reports.
    • Provide neatly printed copies of reports.

     

  • PrerequisitesOpen or Close

    Before attending this course, students must have:

    • Basic computer knowledge.
    • Basic file-management skills.
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