Microsoft Access: Basic

Course Dates:

Call for Dates

Course Specifications

Course length: 1.0 day(s)

Course Objective:

You will create and modify new databases and their various objects.

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports

Course Content

Lesson 1: Getting Started with Access Databases

  • Identify the Elements of the Access Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database

  • Create a New Database
  • Create a Table
  • Manage Tables
  • Establish Table Relationships

Lesson 3: Managing Data in a Table

  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets

Lesson 4:  Querying a Database

  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form

 
Lesson 6: Generating Reports

  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list

WU EDGE - Western Union Business Solutions


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy