Duration : 30 Hrs | 1hr theory/day 1hr Practical

Microsoft Access Course Content

Database design

 

Theory of normal forms

De-normalisation

Naming conventions

 

Access performance issues

 

Indexes

Data validation

Table level validation

Relationships and referential integrity

Relationships

Field types

Referential integrity options

Join types

Using Lookups for referential integrity

Multi-table datasheet view

 

Building and modifying forms

 

Using advanced forms features

The form worksurface

Creating a calculated control

Adding a graphic to a form

Multi-table forms

Using the Subform control

Switchboard forms

 

Advanced queries

 

Filtering query results

Parameter queries

Creating summary queries

Formatting query output

Query join types

Self joins and aliases

Cross joins

 

Access and the Internet

 

Using hyperlinks

Using hyperlinks in forms

Exporting datasheet views to HTML

Data access pages

 

Action queries

 

What is an action query?

Planning an action query

Make table queries

Append queries

Delete queries

Update queries

 

Producing reports

 

Applying sorting and grouping to reports

Performing calculations on reports

Adding a graphic to a report

Using the sub-report control

Modifying section properties

Using the Chart Wizard

 

Database Management Tools

 

Setting a database password

Sharing a database

Start-up options

Splitting a database

 

Intents (in detail)

 

Access Macros

What is a Macro?

Creating a Macro

Running a Macro

Using Macros with events

Macro examples

 

 


Contact US


A : :PHILLOS,

#257, (BIIT Building),9th A Main, Near Upahaara Darshini,

 3rd Block, Jayanagar, Bangalore - 560011

 

E : : nishu.phillos@gmail.

 

Ph : : 984488 5059 / 96208 90035 / 903588 5059

 

Whatsapp : 984488 5059 / 96208 90035

 

Facebook | Linked in | Google + | Google Web


 



ANIMATION & MULTIMEDIA

 

Adobe photoshop Course


 

Adobe illustrator Course



Corel draw Course



Graphic designing Course



Infographics



DTP Course



Web designing Course



Video editing Course



Audio editing Course



2D Animation Course



3D Animation Course



 



BUSINESS ANALYTICS & REPORTING TOOLS



 

Microsoft Advanced Excel Course


 

VBA & Macros Course


 

Microsoft Access Course


 

SAS Base & Advanced Course



Clinical sas Course



Statistical SAS Course



MSBI SSIS SSRS SSAS Course



Tableau Course



Business Analytics


 

 



SAP ERP Course



 

 

SAP fico Course


 

SAP ABAP Course


 

SAP WM Course



SAP PP Course



SAP SD Course



SAP MM Course



SAP HANA Course



SAP BI BO Course


 

 



.net Course



java / J2EE Course



Android Course



Oracle Sql & Plsql Course



Sql Server Course



PHP and MYSQL Course



Sql Course



Vmware Course



Tally ERP Course



Basic Excel


 

 



Why Phillos.....?


 

In Depth technical Knowledge

 

Live Project guidence

 

Real Time Working Environment

 

100% Placement Support

 

One On One Sessions availablity

 

Fast track & Super fast track classes

 



 

 

 

 

Related course

 

Oracle Sql and Plsql Training in bangalore

Oracle Sql and Plsql Training in bangalore

Data Visualization - Tableau Training

Data Visualization - Tableau Training

Related Links