مدخل إلى قواعد البيانات Microsoft access

  • Published on
    10-Jun-2015

  • View
    159

  • Download
    4

Embed Size (px)

DESCRIPTION

Notes of Lect

Transcript

  • 1. Database Microsoft Accessy@@

2. Microsoft Access@@@@@y@@@NcDatabase (DB) @pbbja@a@g@K W Database : . @ @ZDatabase Management System (DBMS)@@pbbja@a@ag@ Microsoft Access . Wpbbja@a@ag@@bL LW L L L L @ @Zpbbja@a@ag@@xbK W W Eone-to-one/one-to-many/many-to-manyF KRelational Model L KNetwork Model L KHierarchal Model L@ @ZMicrosoft Access@c@ob@ @ L K K 2 3. Microsoft Access@@@@@y@@@Nc K Windows LK @ @ :@c@pbbi@a@pa@ F W L KEMDB K L K L. L L . G Z@y . . @ @Z2003@c@ob@wbi@m Start All ProgramsMicrosoft OfficeMicrosoft Office Access 2003W 3002 L K : Menu Bar L WTools Bar L K 3 4. Microsoft Access@@@@@y@@@Nc K W L W L K @ @Zu@pbbi@b@bg K Create a new file Blank K KDatabase File New Database Save In File Name K K? ? Create W W K LK L K L:c@wbi@pbb EDatabase windowF WEObjectsF 4 5. Microsoft Access@@@@@y@@@Nc : : Tables @ aa@ OQ E F EF W Query pbna L K Z@ Forms @ xba L . . Z@ Reports@ bna LHTML Z@ pages @ pbza L K . Z@ba L Z@a@paya L@ @ZTables @aa@Zc . Fields W K Records W 5 6. Microsoft Access@@@@@y@@@Nc FieldsField1 Field2Feild3 Field4Field5Code Name Address Phone NumberE-mailRecords 1 Mohamed AhmedShendi+249-91231415 suda@sd.sd 2Suliman Ahmed Atbrah+249-91226899Ali@us.sd 3Shekh aldeenKhartoum+249-91258647 admin@lo.com @ @ZCreate a new table @u@u@bgW Create table in design view W K Create table by using wizard W K Create table by entering data W KKK Field 2 Field 1 @ @ZCreate Table in Design View@na@@i@u@bg KField name LK EData TypeF LField F L EProperties Esaving tableF L K EPrimary KeyF6 7. Microsoft Access@@@@@y@@@NcWField Name ? Name? ? Picture? K WKW EData TypeF Data Type W . J W TextL { WMemo L. . WNumberL. WDate/TimeL L W CurrencyL. W Auto number L. . ?? ? WYes/No - L L Microsoft Word Microsoft Excel OLE :L . Whyperlink LK Wlookup wizard L7 8. Microsoft Access@@@@@y@@@Nc K K ? ?. Microsoft AccessWEPrimary KeyF ESaving TableF @ @ZPrimary Key@ba@bna K K EPrimary KeyF K @ @Za file EFSave ECtrl+SF save Table name table as K ESaveFForms @xba@Z@bbq @ @ZCreate a new Form @u@x@bgW Create form in design view W KEControl tool boxF 8 9. Microsoft Access@@@@@y@@@NcCreate form by using wizard W K K @ @ZCreate form by using wizard@ba@anbi@u@x@bg Table/Query K E F Available Field EF K ESelected FieldF EF KNext EF EF KNext EJustified , Tabular , columnar F KNext EinternationalF KFinish K navigation Kbar 9 10. Microsoft Access@@@@@y@@@NcReports@@bna@@Z@brbq@ @ZCreate a new report @u@m@bg W Create report in design view W KEControl tool boxF Create report by using wizard WKK @ @ZCreate report by using wizard@ba@anbi@u@x@bg Table/Query K F Available Field E K ESelected FieldF E F EF EF EF Next KNext E F Next Justified , F EHeaderF KNext ETabular , columnar KNext L KFinish K 10

Recommended

View more >