LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL INQUIRE@INSIGHTSMANILA.COM

Fundamentals of MS Access

This training includes a thorough review of the fundamentals of MS Access (basic to advanced) in creating tables, queries, forms, and other database features.
​

Understanding Databases
  • Access Components Overview
  • Creating Databases
  • Using Keys
  • Entering Data Properly
  • Data Types

Creating Tables
  • Design View and Data Types
  • Field Properties
  • Creating Relationships
  • Understanding Data Integrity
  • Creating Lookup Fields

Creating Access Objects: Queries, Forms, and Reports
  • Basic Queries
  • Filtering with Criteria
  • Expressions, Totals, and Concatenating
  • Creating Calculated Fields
  • Creating Forms and Reports
  • Converting Queries to Forms
  • Modifying Forms and Reports
  • Customizing Report Controls

More Database Features (ADVANCED)
  • Importing and Exporting Data
  • Linking Data to an Access Table
  • Essential VBA Codes for Interactive Databases
  •  Passing of Data from One Form to Another
  •  Searching Databases​

Related Courses

Advanced MS Excel

MS PowerBI for Beginners

Macros and VBA Programming