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

Address : 2/B, #257, (BIIT Building),

9th A Main, Near Nagarjuna Chimney,

3rd Block, Jayanagar, Bangalore - 560011

 

E : : advancedexceltraning@gmail.com


Click to call : 8660169339 / 9844885059


Click on Whatsapp: +91-9844885059


Facebook | Linked in | Google + | Google Web





BUSINESS ANALYTICS COURSE



Advanced Excel & MIS Course

VBA & Macros Course

SAS Base & Advanced Course

Clinical sas Course

Statistical Analysis SAS Course

MSBI SSIS SSRS SSAS Course

Tableau Course

Business Analytics




SAP ERP COURSES


 

SAP fico Course

SAP ABAP Course


SAP PP Course

SAP SD Course

SAP MM Course

SAP HANA Course

SAP HR Course




GRAPHIC DESIGNING COURSES



Adobe photoshop Course

Adobe illustrator Course

Corel draw Course

Graphic designing Course

Infographics Course

Web designing Course

Video editing Course

Audio editing Course

3D Animation Course


Our Specialities


Flexible Timings

As per Office Time Or collage Timings Slots Will Be provided



Very Less Fee Structure

Comapred to other institute fee structure here is very less



Daily Theory & Practicals

Theory & Practical will be provided Everyday



Certificate

Certificates will be issued afte the courses



Course materials

Softcopy of course material will be given to every student



Placement Assistance

Placement support will be done after the course completion



Experienced Trainers & In Depth Knowledge

Very Experienced trainers will take sessions



 

 

 

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