Qhov wikiHow no qhia koj li cas los tsim cov ntaub ntawv siv cov ntaub ntawv los ntawm Microsoft Excel daim ntawv nthuav qhia los ntawm kev xa cov ntaub ntawv ncaj qha mus rau Access, uas yog Microsoft cov ntaub ntawv tswj hwm software, lossis xa tawm Excel cov ntaub ntawv mus rau hauv hom ntawv uas ua haujlwm nrog feem ntau cov software software. Microsoft Access yog ib feem ntawm Microsoft Office software pob thiab tsuas yog muaj rau Windows.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv Microsoft Access
Kauj Ruam 1. Qhib Microsoft Access
Nws yog lub app liab nrog A. Ua li ntawd qhib lub Access template page.
Kev nkag mus yog tsim los siv nrog Excel thiab los nrog Excel hauv Microsoft Office Professional thiab tsuas yog muaj rau Windows
Kauj Ruam 2. Nyem qhov khoob database
Qhov kev xaiv no yog nyob rau sab laug-sab laug ntawm lub qhov rais.
Yog tias koj xav siv tus qauv sib txawv rau koj li Access database, xaiv tus qauv uas koj xav tau hloov
Kauj Ruam 3. Nyem Tsim thaum hais kom sai
Qhov kev xaiv no yog nyob rau hauv qab txoj cai kaum ntawm lub qhov rai pop-up. Koj Access database yuav qhib.
Kauj Ruam 4. Nyem rau Cov Ntaub Ntawv Sab Nraud tab
Nws nyob hauv cov ntawv qhia zaub mov saum toj ntawm Access window.
Kauj Ruam 5. Nyem Txuag Txawv Tebchaws
Koj yuav pom qhov no nyob rau sab laug-sab laug ntawm Cov Ntaub Ntawv Sab Nraud toolbar. Cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 6. Xaiv Cov Ntaub Ntawv
Nws nyob hauv cov ntawv qhia zaub mov nco-down. Xaiv qhov kev xaiv no ua rau cov ntawv qhia tawm.
Kauj Ruam 7. Nyem rau Excel
Qhov kev xaiv no nyob hauv cov ntawv qhia zaub mov pop-out. Nyem rau nws ua kom lub qhov rai ntshuam qhib.
Kauj Ruam 8. Nyem Xauj
Nws nyob rau sab xis-sab xis ntawm lub qhov rais.
Kauj Ruam 9. Xaiv Excel daim ntawv nthuav qhia
Mus rau daim nplaub tshev uas koj daim ntawv Excel nyob, tom qab nyem rau Excel daim ntawv uas koj xav qhib.
Kauj Ruam 10. Nyem Qhib
Nws nyob hauv qab-txoj cai kaum ntawm lub qhov rais.
Kauj Ruam 11. Qhia meej tias yuav xa cov ntaub ntawv li cas
Nias lub xov tooj cua khawm mus rau sab laug ntawm ib qho ntawm cov hauv qab no:
- Ntshuam cov ntaub ntawv los rau hauv lub rooj tshiab hauv cov ntaub ntawv tam sim no - Xaiv qhov kev xaiv no yog tias koj tsim cov ntaub ntawv tshiab uas tsis muaj cov ntxhuav lossis yog tias koj xav ntxiv lub rooj tshiab rau cov ntaub ntawv keeb kwm yav dhau los. Los ntawm kev tsim lub rooj tshiab koj tuaj yeem kho cov ntaub ntawv hauv Access.
- Ntxiv daim ntawv theej ntawm cov ntaub ntawv rau lub rooj - Xaiv qhov kev xaiv no yog tias koj siv cov ntaub ntawv khaws tseg uas twb muaj lawm thiab xav ntxiv cov ntaub ntawv mus rau ib qho ntawm cov lus hauv cov database. Los ntawm kev ntxiv cov lus uas twb muaj lawm, koj tuaj yeem hloov kho cov ntaub ntawv hauv Access.
- Txuas mus rau cov ntaub ntawv los ntawm kev tsim lub rooj sib txuas - Xaiv qhov kev xaiv no los tsim qhov txuas txuas hauv cov ntaub ntawv, uas yuav qhib Excel database hauv Excel. Nrog rau txoj hauv kev no, koj tsis tuaj yeem hloov kho cov ntaub ntawv hauv Access.
Kauj ruam 12. Nyem OK
Koj yuav pom qhov no hauv qab ntawm lub qhov rais.
Kauj Ruam 13. Xaiv ib daim ntawv
Nyob rau sab saum toj ntawm lub qhov rais, nyem lub npe ntawm daim ntawv uas koj xav kom ntshuam los ntawm koj daim ntawv Excel uas koj xaiv.
- Los ntawm lub neej ntawd, Excel tsim phau ntawv ua haujlwm nrog peb daim ntawv teev npe uas sau tias "Sheet 1," "Sheet 2," thiab "Sheet 3." Koj tsuas tuaj yeem xa ib daim ntawv ntawm ib lub sijhawm; yog tias koj muaj cov ntaub ntawv ntawm tag nrho peb daim ntawv, koj yuav tsum ua tiav qhov kev hloov pauv nrog ib daim ntawv thiab tom qab ntawd rov qab mus rau "Cov Ntaub Ntawv Sab Nraud" tab thiab rov ua dua txhua kauj ruam rau txhua daim ntawv ntxiv.
- Koj tuaj yeem tshem tawm, ntxiv, thiab kho cov npe ntawm cov ntawv no hauv Excel, thiab qhov kev hloov pauv dab tsi koj yuav pom nyob hauv Access database.
Kauj Ruam 14. Nyem Next
Nws nyob hauv qab-txoj cai kaum ntawm lub qhov rais.
Kauj Ruam 15. Pab kom lub npe kab lus
Khij lub npov "Thawj Kab Muaj Kab Hauv Lub Npe" yog tias koj daim ntawv Excel muaj nws tus kheej kab lus kab lus nyob rau kab saum toj kawg nkaus (piv txwv li, A kab).
Uncheck lub thawv yog tias koj xav tau Access los tsim kab lus kab lus
Kauj Ruam 16. Nyem Next
Kauj Ruam 17. Kho koj daim ntawv nthuav tawm txhua kab thiab kab lus yog tias xav tau
Yog tias koj xav import txhua daim teb los ntawm daim ntawv nthuav tawm yam tsis hloov, hla cov kauj ruam no:
- Txhawm rau kho qhov chaw, nyem rau kab ntawv kab ntawv uas koj xav hloov, tom qab ntawd hloov lub npe ntawm daim teb, hom ntaub ntawv, thiab/lossis seb nws puas tau txheeb xyuas.
- Yog tias koj tsis xav import ib daim teb, khij lub npov "Tsis Txhob Nkag Mus (Hla)".
Kauj Ruam 18. Nyem Next
Kauj Ruam 19. Teeb tus yuam sij thawj rau lub database
Kom tau txais txiaj ntsig zoo tshaj plaws, tawm qhov kev teeb tsa ua ntej ntawm no raws li-yog cia Access teeb tsa tus yuam sij.
Koj tseem tuaj yeem teeb koj tus kheej qhov tseem ceeb los ntawm kev tshuaj xyuas "Xaiv kuv tus kheej lub hauv paus tseem ceeb" thiab nkag mus rau nws hauv qhov chaw tom ntej ntawm qhov kev xaiv ntawd, lossis koj tuaj yeem xaiv "Tsis muaj tus yuam sij thawj" (tsis pom zoo)
Kauj ruam 20. Nyem Next
Kauj Ruam 21. Ntxiv lub npe
Ntaus lub npe rau daim ntawv rau hauv "Ntshuam rau Rooj" teb.
Hla cov kauj ruam no kom tawm ntawm cov ntaub ntawv teev tseg rau nws lub npe tsis raug
Kauj Ruam 22. Nyem Ua tiav
Qhov kev xaiv no yog nyob rau sab qis-sab xis ntawm lub qhov rais.
Kauj Ruam 23. Nyem Kaw
Nws nyob hauv qab-txoj cai kaum ntawm lub qhov rais. Qhov no yuav kaw qhov rai ntshuam thiab tsim koj cov ntaub ntawv.
Koj thawj zaug tuaj yeem txheeb xyuas "Txuag ntshuam cov kauj ruam" lub thawv yog tias koj xav kom ntseeg tau tias Access yuav nco qab koj cov chaw rau cov ntaub ntawv no
Txoj Kev 2 ntawm 2: Siv Peb Tus Kheej Database Software
Kauj Ruam 1. Qhib koj daim ntawv Excel
Ob npaug nias rau daim ntawv Excel uas koj xav hloov mus rau hauv cov ntaub ntawv.
Yog tias koj tseem tsis tau tsim koj daim ntawv, qhib Excel, nyem rau Phau ntawv dawb paug, thiab tsim koj daim ntawv ua ntej mus.
Kauj Ruam 2. Nyem Cov Ntaub Ntawv
Nws nyob hauv cov ntawv qhia zaub mov uas yog nyob rau sab saum toj ntawm lub qhov rai Excel (Windows) lossis nyob rau sab saum toj ntawm lub vijtsam (Mac).
Kauj Ruam 3. Nyem Txuag Li
Koj yuav pom qhov kev xaiv no hauv Cov ntaub ntawv ntawv qhia zaub mov
Kauj Ruam 4. Nyem ob npaug rau Lub PC no
Nws nyob nruab nrab ntawm nplooj ntawv.
Hla qhov kauj ruam no ntawm Mac
Kauj Ruam 5. Xaiv hom ntawv
Nyem rau "Save as type" (Windows) lossis "File Format" (Mac) drop-down box, tom qab ntawd xaiv ib qho ntawm cov hauv qab no:
- Yog tias koj siv lub computer-based database thov, nyem a . CSV (comma cais qhov tseem ceeb) hom ntawv.
-
Yog tias koj siv Web-based database thov, nyem rau . XML hom ntawv.
Yog tias koj daim ntawv Excel tsis muaj XML cov ntaub ntawv hauv nws, koj yuav tsis tuaj yeem xaiv XML
Kauj Ruam 6. Nyem Txuag
Nws nyob hauv qab ntawm lub qhov rais. Qhov no yuav txuag koj cov ntaub ntawv siv koj li kev nyiam xaiv.
Kauj Ruam 7. Tsim cov ntaub ntawv tshiab hauv koj daim ntawv thov database
Cov txheej txheem no yuav txawv nyob ntawm daim ntawv thov uas koj siv, tab sis feem ntau koj yuav qhib daim ntawv thov, nyem Tshiab (los yog Cov ntaub ntawv > Tshiab), thiab ua raws li cov lus qhia ntawm lub vijtsam.
Kauj Ruam 8. Nrhiav Ntshuam… khawm
Nws feem ntau pom los ntawm txhaj rau Cov ntaub ntawv xaiv, tab sis koj daim ntawv thov database yuav txawv.
Kauj Ruam 9. Xaiv koj daim ntawv Excel
Nrhiav thiab ob-nias cov ntawv koj tau xa tawm los ntawm Excel.
Kauj Ruam 10. Ua raws li lub database app cov lus qhia kom xa cov ntaub ntawv
Kauj Ruam 11. Txuag lub database
Feem ntau koj tuaj yeem qhib "Txuag" cov ntawv qhia los ntawm nias Ctrl+S (Windows) lossis ⌘ Command+S (Mac).
Lub tswv yim
- Muaj ntau lub vev xaib online dawb cov vev xaib uas koj tuaj yeem siv los tsim cov ntaub ntawv khaws cia, txawm hais tias koj yuav tau sau npe rau tus as khauj nrog feem ntau ntawm cov kev pabcuam no.
- Yog tias koj tsis muaj lub peev txheej siv software tau zoo, koj kuj tseem xav tau ib qho program cais los qhib cov ntaub ntawv database ntawm PC lossis Mac.
