• Opening a Database
• Trusted Locations
• Setting the Default Folder Location
• Closing the Access Program

• Creating a New Blank Database
• Adding Fields and Setting the Field Type
• About Access Data Types
• Closing and Naming a Table

• Opening a Table within a Database
• ‘Datasheet View’ vs. ‘Design View’
• Adding Records to a Table
• Navigating Through Records
• Adjusting Column Width
• Automatically Resizing a Column Widths
• Rearranging the Column Order

• Field Properties
• Input Masks
• Validating Numbers
• Validating Dates
• Data Entry Required / Not Required
• Field Properties – Reference Materials
• Field Properties – Logical Operators
• Field Properties – General
• Field Properties – Format
• Field Properties – Input Mask Characters

•  Renaming a Table
•  Editing Data within a Record
•  Deleting Data within a Record
•  Using the Undo Command
•  Deleting a Single Record
•  Deleting Multiple Records
•  Deleting a Table

•  Defining a Primary Key
•  Indexing
•  Creating a Single-Field Index
•  Creating a Multiple-Field Index
•  Deleting Multi-Field Indexes

• Text Filters
• Single Filter
• Multiple Filters

• Sorting Records
• Removing a Sort
• Sorting on Multiple Fields

• Searching Through Records

• One-To-Many Relationship
•  Many-To-Many Relationship
•  One-To-One Relationships
•  Creating Relationships between Tables
•  Referential Integrity
•  Cascade Options
•  Cascade Update Related Fields
• Cascade Delete Related Records
•  Enabling Cascade Options
•  Deleting Relationships

• Creating Forms
• Modifying Forms
• Saving a Form
• Form View
• Adding and Formatting Attachments
• Modifying Data within Records
• Deleting Records using a Form
• Adding Records using a Form
• Closing Forms
• Deleting a Form
• Filtering a Form
• Removing a Filter from a Form
• Inserting and Modifying a Form Header
• Inserting and Modifying a Form Footer

•  Creating a Query
•  Adding Criteria to a Query
•  Running a Query
•  Editing Criteria In a Query
•  Saving a Query
•  Creating a Two Table Query and Sorting the results
•  Refining a Query
•  Wildcards
•  Deleting a Query
•  Hiding and Un-Hiding Query Fields

• Creating a Report
•  Using the Report Wizard
•  Modifying the Layout of a Report
•  Widening a Report Column
•  Modifying the Report Title
•  Adding a Logo to a Report
•  Formatting a Form using Themes
•  Modifying Field Names within a Report
•  Inserting and Formatting the Date & Time
•  Adding Existing Fields to a Report
•  Resizing Reports For Printing
•  Totals
•  Closing a Report
•  Deleting a Report

•  Exporting a Table As an Excel File
•  Exporting a Table As a Text File
•  Exporting a Table As a Text CSV File
•  Exporting a Table As a PDF File
•  Exporting a Table As an XML File

• Print Previewing
•  Portrait and Landscape
•  Adjusting Layout In Print Preview
•  Margins
•  Printing a Complete Table
•  Printing Selected Records
•  Printing a Query or Reports
•  Printing Forms

• Opening a Database
•  Opening a Table
•  The Ribbon (Toolbar)
•  Ribbon Tabs
•  Groups
•  Dialog Box Launcher
•  Navigating
•  Contextual Tabs
•  Minimising the Ribbon
•  The File Tab
•  Microsoft Access Help
•  Closing Access 2010

• Database
•  Table
•  Record
•  Field
•  Field Data Types
•  Field Properties
•  Primary Key
•  Types of Database

• Setting a trusted location

•  Creating a Lookup within a Field.
•  Modifying a Lookup within a Field.
•  Deleting a Lookup within a Field.
•  Creating an Input Mask.
•  Modifying an Input Mask.
•  Deleting an Input Mask.
•  Modifying a Field to Require Data Entry.
•  Modifying a Field So That It Does Not Require Data Entry.

• Creating and modifying a One-To-One Relationship.
•  Creating and modifying a One-To-Many Relationship.
•  Creating and modifying a Many-To-Many Relationship using a Junction Table.
•  Enforcing Referential Integrity.
•  Automatic Updating of Related Fields.
•  Automatic Deletion of Related Records.

• Inner Join.
•  Outer Join.
•  Subtract Join.
•  Self Join

•  About Queries
•  Update Query.
•  Delete Query.
•  Make Table Query.
• Append Query.
•  Crosstab Query.
•  Find Duplicates Query.
•  Find Unmatched Records Query.
•  One Variable Parameter Query.
•  Two Variable Parameter Query.
•  Using Wildcards In a Query:
•  Maximum or Minimum Values In a Query.
•  Using Calculated Fields That Perform Arithmetic Calculations.
•  Grouping Information In a Query using Functions.

•  Types of Form Controls
•  Bound Controls Vs. Unbound Controls.
•  Text Box.
•  Combo Box.
•  List Box.
•  Check Box.
•  Limit to List
•  Distinct Values.
•  Arithmetic Expressions.
•  Logical Expressions.
•  Modifying the Tab Order in a Form.
•  Creating a Sub-Form.
•  Linking a Sub-Form.

•  Formatting Arithmetic Calculation Controls
•  Applying a Running Sum For a Group or Over All
•  Concatenating Fields within a Report.
•  Inserting a Data Field In a Report Group.
•  Inserting a Data Field In a Report Page.
•  Inserting a Data Field In Report Headers and Footers.
•  Sorting and Grouping Records In a Report By Field(S).
•  Forcing Page Breaks For Groups In a Report.
•  Creating a Linked Sub-Report.

•  Creating Macros
•  Assigning a Macro to a Command Button.
•  Assigning a Macro to an Object.
•  Assigning a Macro to a Control.

• Office Administrators & Clerks
• Data Entry Operators
• Business Analysts & Assistants
• Students and Academic Researchers

• Build and manage relational databases
• Design forms, queries, and reports with ease
• Automate database functions using macros
• Export data in various professional formats

• Database Administrator (Entry-Level)
• MIS Executive
• Data Entry Specialist
• Business Support Assistant
• Administrative Coordinator

• KHDA-Certified Certification: Validate your database skills with a Dubai-recognized certificate
• Hands-On Practice: Projects using Access tools and features
• Industry-Relevant Training: Learn practical database skills for administrative, analytical, and IT roles
• Flexible Learning: Available in both online and offline formats
• Expert Trainers: Guided by professionals with experience

• Basic computer literacy
• No prior experience in databases required

Unlock the power of data management with the Microsoft Access course at Aptech Computer Training, available at our Dubai and Sharjah branches. This practical, hands-on course is ideal for professionals, analysts, administrative staff, and students who want to design, build, and manage relational databases for personal, business, or organizational use.

Participants will explore core database concepts, relational models, forms, queries, reports, and macros. The course emphasizes real-world applications such as data entry, search and filter operations, database security, table relationships, form design, and automation through macros. Learners will also be guided on how to export data for use in Excel, PDF, XML, and CSV formats.

By the end of the course, students will be equipped to confidently build efficient databases, manage complex data sets, and generate dynamic reports, all using Microsoft Access.