Managing Databases using MS Access
ENDED
Online Webinar by
Mpower Learning
Inquire Now
Online
/ Webinar
Details
This seminar will train participants on how to use MS Access in creating database objects: tables, forms, queries, and reports. The training will include introduction to VBA used in MS Access to perform tasks that are not doable using regular methods.
OUTLINE
Understanding Databases
Creating Tables
Creating Access Objects: Queries, Forms, and Reports
More Database Features
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Click the "ENROLL NOW” to find Payment Methods (GCash, credit card, bank deposit, etc.)
Onsite:
Registration: Php2,199 per person
EARLY BIRD: Php1,999 per person
INCLUSIONS:
- 1 AM snack
- 1 PM snack
- 1 lunch (fastfood)
- Handouts
- Certificate
- overflowing coffee
- WIFI access
BRING OWN LAPTOP
Where: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
via Zoom:
Registration: Php2,099 per person
EARLY BIRD: Php1,899 per person
INCLUSIONS:
- PDF handouts
- PDF certificate
OUTLINE
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
- 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
Outline
Understanding Databases
Creating Tables
Creating Access Objects: Queries, Forms, and Reports
More Database Features
- 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
- 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
Schedules
No. of Days: | 1 |
Total Hours: | 8 |
Reviews
Be the first to write a review about this course.
Write a Review
Mpower Learning focuses on improving the leadership and productivity skills of Filipinos through its value-driven training.