Skip to Content



HOME
  • Course help
  • Free courses
  • Online courses
  • Courses in London
  • Courses in Manchester
 

Access: Introduction (In-House)

SquareOne Training
Course summary
Corporate Training for Teams
1 day
Full time
Nationwide
Course Dates
United Kingdom
Enquire for more information

Course description

             access

Access: Introduction (In-House)

This course gives those who have little or no experience of working with Microsoft Access a detailed introduction to this database software. During the course you will learn how to create a database with tables, forms, reports and queries. You will also gain an understanding of the advantages that using an Access Database can bring to your job role or business.

Suitability - Who should attend?

This course is suitable for all new users of Access wishing to gain an understanding of the package and learn how to create more professional databases.

Course Pre-Requisites

No previous experience of Microsoft Access is necessary, however delegates should have a previous understanding of working with computers.

For more information on suitability, please send an enquiry here

Training Course Content

Getting started with Access

  • Access Overview/Database Design Theory
  • What is a Relational Database
  • Screen Elements and Help Tools

    Tables

    • Using the Table Wizards
    • Manual Creation of Tables
    • Fields, Data Types and Properties
    • Input Masks
    • Data Validation
    • Importing Data
    • Primary Keys and Relationships

      Inputting Data

      • Adding data using the Table View
      • Adjusting the column widths

      Importing Data

      • Primary Keys and Relationships

      Finding Records

      • Using the Find feature to find Records
      • Using the Replace feature to replace text

        Filters

        • Using the filter button to find records

        Queries

        • Designing Queries
        • Query Wizard Overview
        • Sorting and Searching Queries
        • Multi-Table Relationship Queries
        • Update, Append & Delete Action Queries

          Forms

          • Introduction to Form Design
          • Form Wizards
          • Toolbox Controls
          • Combo Boxes & Command Buttons
          • Main/Sub Form Creation
          • Creating a Menu Form

            Reports

            • Report Wizard
            • Creating Reports
            • Printing Reports

            Why choose SquareOne Training

            25 years' experience of delivering quality IT Training Services

            All trainers Certified Microsoft Office Trainer (MOS) or higher

            Public and in-house training throughout the UK

            Expenses

            This training course will be delivered in the form of a closed course at your company's premises and can be custom tailored to meet the needs and requirements of your particular organisation.

            SquareOne can come to you no matter where you are based throughout the UK or Europe. The cost of this training course is available upon request.

            Please send an enquiry here

            About provider

            SquareOne Training

            SquareOne believe that no two people are the same, therefore all our courses are unique just like you. SquareOne will work with you and your company to tailor a course that is suitable for your business needs, development and future...


            Read more and show all courses with this provider

            Request info

            Fill out your details to find out more about Access: Introduction (In-House).

              Contact the provider

              Get more information

              Register your interest

            Country *

            Contact info

            SquareOne Training

            2 Tower Road
            CH41 1FN Birkenhead

             Show phone number
            www.squareonetraining.com


            Find more courses here

            Request Information

            Find out more about this Access: Introduction (In-House) course - simply fill out your details:

            Free course help

            Free Training Quote and Advice from Findcourses.co.uk Specialists

            Our experienced advisors help you find the most suitable course.

            Personalised course recommendations - all for free.

            Get started

            Case Study
            Excel Templates For Mexichem
            SquareOne Training

            At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.

            Read more
            SquareOne Deliver IT Rollout Pro...

            Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

            Read more
            View again