If several languages coalesce the grammar
3 min ago
It will seem like simplified English.
1 hours ago
As a skeptical Cambridge friend of mine occidental.
MS-Access is a RDBMS (Relational Database Management System) which is used to maintain database for specific organization (Like: - School, College, Bank, Company etc.) MS-Access is an object oriented package. User can enter huge records within a file. MS-Access provides us the great feature to make relationship between multiple tables with data retrievable facility also (means add new records, delete, and modify etc.) MS-Access file known as database and extension is “.MDB†or “ACCDBâ€. How to start MS-Access:-Ø Click on start buttonØ Click on all programsØ Click on Microsoft officeØ Click on Microsoft Access 2010ORØ Press Windows Button + R (Run) à Type msaccessà OkDatabase: - A database is a collection of all those multiple tables which provide for maintain all records and prepared for all types of reports of an organization, institute, college, school etc.Ex: - Student table Fee table Exam table There are six objects in MS-Access:-Ø TableØ QueryØ FormØ ReportØ MacroØ Switchboard Table object: - This is primary object of MS-Access which uses to create the structure of table according to user needs and enter large amount of information based on structure.There are two view of table object:-
Ø Press Windows Button + R (Run) à Type msaccessà Ok
Ø Design view: - For create the structure as user needs.Ø Datasheet: - For enter the records according to structure.
How to create Table in MS-Access:-Process:-Ø Open MS-AccessØ Click on blank databaseØ Enter any nameØ Click on create buttonØ Click on view icon and select design viewØ Enter your table name and ok
Ø Define the structure as you need
Field Name Data type Roll Auto No Name Text Add Text Course Text Fee Currency D_O_B Date/Time Remark Memo Picture Ole object Link Hyperlink Pin code Number Regular Yes/no Attachment Attachment
Field Name
Data type
Roll
Auto No
Name
Text
Add
Course
Fee
Currency
D_O_B
Date/Time
Remark
Memo
Picture
Ole object
Link
Hyperlink
Pin code
Number
Regular
Yes/no
Attachment
Ø Click on datasheet viewØ Click on yesØ Enter the records
Roll Name Add Course Fee D_O_B Remark Memo
How to Insert Picture?ProcessØ Mouse Right ClickØ Click on insert objectØ Then a dialog box openØ Click on create newØ Select Microsoft word document from object typeØ Then Microsoft word will openØ Click on insert buttonØ Select your pictureØ Click on close buttion
How to Create Hyperlink?ProcessØ Mouse Right ClickØ Click on hyperlinkØ Click on edit hyperlinkØ Then a dialog box openØ Select your fileØ Click on ok
How to Attach File?ProcessØ Mouse Right ClickØ Click on Manage AttachmentØ Then a dialog box openØ Click on add buttonØ Then a dialog box openØ Select your fileØ Click on openØ Click on ok
Ø Click on ok