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

 


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