Powerpoint Presentation On Ms Access 2010

Power Ponint Presenataion (MS Access)

Powerpoint Presentation On Ms Access 2010 

To Record A Slide Show In Power Point -

• Click The Slide Show Tab, then Locate The Set up group.

• Click the record slide show drop down arrow. Select eighter ''Start Recording From Current Slide OR ''Start Recording From The Beginning''.

• A Dialog Box Will Appear, ''Select and animation timings'' and second option is ''Narration And Laser Pointer'' And Then Click On ''Start Recording Option''.

• Soon You Click On ''Start Recording'' Your Presentation Will Open On A New Screen OR Full Screen.

• Perform Your Slide Show When You Are Ready To Move To The Next Slide, Click ''Next'' Button Represented Wth And Arrow Mark On The ''Recording Toolbar''

# Video In Power Point -

1. Select The File Tab.

2. Select Export And Then Click Create A Video, Video Export Option Will Apper On The Right.

3. Click The Drop Down Arrow Next To TECHNICAL NITESH Computer And HD Displays For The Size And Quality Of Your Video.

4. Select The Option According Whether You Want To Record Narration Or Not.

5. Click Create Video And Then Save The Video.

#Play Music For The Selected Duration In Power Point :-

1. Download Or Store Music To Your PC Hard Drive And From There Upload It To Power Point.

2. In The Main Menu On The ''Insert'' Tab, Click ''Audio'' And Then Click On ''Audio On My PC''

3. Locate And Double Click On The Music File.

4. Click On ''Play In Background'' Under ''Playback'' tab.

2MS ACCESS

Microsoft Access Database Is A Rational Database Management System. Which Combine GUI (Graphical User Interface) With Microsoft Jet Database Engine.

This Software Is Used To Build Application Software.

It Can Import And Use Data From Access, SQL, Oracle etc.

MS Access Is Just One Part Of Microsoft's Overall Data Management Product Strategy.

It Shows Data In Its Own Format Based On The Access Jet Database Engine.

Like, Rational Databases, Microsoft Access Also Allows You To Link Related Information Easily.

It Can Also Import Or Link Directly To Data Stored In Other Applications.

Access Can Work With Most Popular Databases That Support Yhe Database Connectivity (OBDC) Standard, Including SQL Server, Oracle And DB2.

Software Developers Can Use Microsoft Access To Develop Application Software.

Microsoft Access Stores Information Which Is Called A Database.

1. Database Creation:- Create Your microsoft Access Database And Specify What Kind Of Data You Will Be Storing.

2. Data Input:- After Your Datatbase Is Created, The Data Of Every Business Day Can Be Entered Into The Access Database.

3. Query:- This Is A Fancy Term To Basically Describe A Process Of Retriving Information From The Database.

4. Report (Optional):- Information From The Database Is Organized In A Nice Presentation That Can Be Printed In An Access Report.

#Extensions For Microsoft Access -

1. Access Database.accdb

2. Access Project.adp

3. Access Project.mdw

4. Access Blank Project Template.adn

5. Access Workgroup.mdw

6. Protected Access Database. Accde

#Table -

Table Is An Object That Is Used To Define And Store Data.

When You Create A New Table, Access Ask You To Defins Fields Which Is Also Known As Column Headings.

Powerpoint Presentation On Ms Access 2010

Each Filed Must Have A Unique Name, And A Data Type.

Table Contains Fields Or Columns That Stores Different Kinds Of Data, Such As A Name, Or An Address, And Records Or Rows That Collect All The Information About A Particular Instance Of The Subject, Such As All The Information About Customer, And Employee Etc.

You Can Define A Primary Key, One Or More Fields That Have A Unique value For Each Record, And One Or More Indexes On Each Table To Help Retrive Your Data More Quickly.

#Query:-

An Object That Provides A Custom View Of Data From One Or More Tables. Queries Are A Way Of Searching For And Compiling Data From One Or More Tables.

Running A Query Is Like Asking A Detailed Question Of Your Database.

When You Build A Query In Access, You Are Defining A Specific Search Conditions To Find Excatly The Data You Want.

In Access, You Can Use The Graphical Query By Example Facility Or You Can Write Structured Query language (SQL) Statements To Create Your Queries.

You Can Define Queries To Select That Creates New Tables From Data In One Or More Exciting Table.

#Form:-

Form Is An Object In A Desktop Database Designed Primarily For Data Input Or Display Or For Control Of Application Execution.

You Can Use Forms To Customize The Presentation Of Data That Your Application Extracts From Queries Or Tables.

Forms Are Used For Entering, Modifying And Viewing Records

The Reason Forms Are Used So Often Is That They Are The Easy Way To Guide Peoples Towards Entering Data Correctly.

When You Enter Information Into A Form In Access, The Data Goes Excatly Where The Database Designer Wants it To Go In One Or More Related Tables.

#Report:-

Report Is An Object In Desktop Database Designed For Formatting, Calculating, Printing And Summarizing Selected Data.

You Can View A Report On Your Screen before You Print It.

If Forms Are For Output Purposes, Then Reports Are For Output.

Anything You Plan To Print Deserves A Report, Whether It Is A List Of Names And Addresses, A Financial Summary fort A Period, Or A Set Of Mailing Lables.

Reports Are Useful Because They Allow You To Present Components Of Your Database In Easy-To-Read Format.

You Can Even Customize A Report's Appereance To Make It visualy Appealing.

Access Offers You The Ability To Create A Report From Any Table Or Query.

#Blank Database:-

MS Access – Query

A Query Is A Request From Data Result, And For Action On Data.

You Can Use A Query To Answer A Simple Question, To Perform Calculations, To Combine Data From Different Tables, Or Even To Add, Change, Or Delete table Data.

With A Query You Can Apply A Filter To The Table's Data, So That You Only Get The Information That You Want.

Queries That You Use To Retrieve Data From Table Or To Make Calculations Are Called Select Queries.

Queries That Add, Change, Or Delete Data Are Called Action Queries.

You Can Also Use A Query To Supply Data For A Form Or Report.

In A Well Designed Database, The Data That You Want To Present By Using A Form Or Report Is Often Located In Several Different Tables.

The Tricky Part Of Queries Is That You Must Understand How To Construct One Before You Can Actually Use Them.