Microsoft Access Expert

MO-500:Microsoft Access Expert create and maintain Access database facilities, including tables, communications, data entry forms, multi-level reports and multi-table requests. Candidates are Expected to Demonstrate the correct Application of the Basic Functions of Access and perform tasks Independently.

1. Modify Database Structure

Import objects or data from other sources
Delete database objects
Hide and display objects in the Navigation Pane

2. Manage table Relationships and Keys

Understand relationships
Display relationships
Set primary keys
Enforce referential integrity
Set foreign keys

3. Print and export data

Configure print options for records, forms, and reports
Export objects to alternative formats

4. Create and modify tables

Import data into tables
Create linked tables from external sources
Import tables from other databases
Hide fields in tables
Add total rows
Add table descriptions
Find and replace data
Sort records
Filter records

5. Create and Modify Queries

Create simple queries
Create basic crosstab queries
Create basic parameter queries
Create basic action queries
Create basic multi-table queries
Save and run queries
Add, hide, and remove fields in queries
Sort data within queries
Filter data within queries
Format fields within queries

6. Modify forms in layout view

Add, move, and remove form controls
Set form control properties
Add and modify form labels
Modify tab order on forms
Sort records by form field
Modify form positioning
Insert information in form headers and footers
Insert images on forms

7. Modify Reports in layout view

Group and sort fields on reports
Add report controls
Add and modify labels on reports
Format a report into multiple columns
Modify report positioning
Format report elements
Change report orientation
Insert information in report headers and footers
Insert images on reports

Fees Structure :	5500 INR / 65 USD
Total No of Class :	53 Video Class
Class Duration :	25:30 Working Hours
Download Feature :	Download Avalable
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure Buy Now Sample Demo

Fees Structure :	10000 INR / 120 USD
Class Duration :	30 Days
Class Recording :	Live Class Recording available
Class Time :	Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support :	Call / Whatsapp : +91 8680961847
Working Hours :	Monday to Firday 9 AM to 6 PM
Payment Mode :	Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure Pay Online

Microsoft Access Expert

1. Modify Database Structure

2. Manage table Relationships and Keys

3. Print and export data

4. Create and modify tables

5. Create and Modify Queries

6. Modify forms in layout view

7. Modify Reports in layout view

Why People Like us!

More Info

Account

Contact