Using Access Level One

by Skillsgen Claim Listing

This course is intended for new users to Relational Databases. The course is designed for those who wish to use Access on a personal level to create a database and produce reports from the data held.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Skillsgen Logo

img Duration

1 Day

Course Details

This course is intended for new users to Relational Databases. The course is designed for those who wish to use Access on a personal level to create a database and produce reports from the data held. 

Upon successful completion of this course delegates will be able to: understand the principes of database design, create tables, create forms, enter, sort and filter data, create basic queries, create basic reports and create and understand relationships. Please be sure to read the pre-requisites for this course to ensure you meet the requirements.

 

Course Content:

  • Forms:
  • Create a form from scratfch
  • Using the form wizard
  • Moving fields on the form
  • Formatting and alignment of fields
  • Form properties
  • Using the form toolbox
  • Tables:
  • Creating a new table
  • Field names and data types
  • Primary key
  • Table properties
  • Lookup lists
  • Getting Started:
  • Database concepts
  • Overview of the main parts of Access
  • Using Help
  • Sorting & Filtering:
  • In tables
  • In forms
  • In queries
  • In reports
  • Reports:
  • Using the report wizard
  • Sorting and grouping
  • Preview and printing
  • Queries:
  • Create a query
  • Selection criteria
  • Calculations and expressions
  • Summary query
  • Relationships:
  • Create a relationship
  • Referential integerity
  • Relationship types
  • Liverpool Branch

    South Road, Liverpool

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy