1 / 27

Microsoft Office 2003- Illustrated Introductory, Premium Edition

Microsoft Office 2003- Illustrated Introductory, Premium Edition. Getting Started. with Access 2003. Objectives. Understand relational databases Learn database terminology Start Access and open a database Work with the database window. Objectives. Navigate records Enter records

suki-stuart
Download Presentation

Microsoft Office 2003- Illustrated Introductory, Premium Edition

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Office 2003- Illustrated Introductory, Premium Edition Getting Started with Access 2003

  2. Objectives • Understand relational databases • Learn database terminology • Start Access and open a database • Work with the database window Getting Started with Access 2003

  3. Objectives • Navigate records • Enter records • Edit records • Preview and print a datasheet • Get Help and exit Access Getting Started with Access 2003

  4. Understand relational databases • Access is a relational database program • Access is used to enter, edit, and analyze lists of data • Relational databases minimize redundant data Getting Started with Access 2003

  5. Advantages of Access • Duplicate data is minimized • Information is more accurate • Data entry is faster and easier • Information can be viewed and sorted in multiple ways Getting Started with Access 2003

  6. Advantages of Access • Information is more secure • Information can be shared among several users • Information retrieval is faster and easier Getting Started with Access 2003

  7. Comparing Excel to Access • Additional layout capabilities • More storage capacity • Linked tables • Multiuser capabilities • Better data entry forms Getting Started with Access 2003

  8. Learning Database Terminology • Field make up records • Records make up tables • Tables make up a relational database Getting Started with Access 2003

  9. Access Objects • Table: stores all data • Query: answers a question • Form: provides data entry form • Report: provides formatted output Getting Started with Access 2003

  10. Access Objects • Page: creates a dynamic Web page • Macro: stores repetitive actions • Module: stores VBA code Getting Started with Access 2003

  11. Access Objects Customers table Record Sales table Field Links between tables Products table Table Getting Started with Access 2003

  12. Access Objects REPORTS FORMS QUERIES Data goes in TABLES Printouts All data is stored in tables, no matter how it is entered Getting Started with Access 2003

  13. Starting Access and Opening a Database • Starting Access • From the Start menu • From a Shortcut Getting Started with Access 2003

  14. Starting Access and Opening a Database Getting Started with Access 2003

  15. Starting Access and Opening a Database • Opening a Database within Access • Access Task Pane • Access Open button • Opening a Database from Windows • My Computer • Windows Explorer Getting Started with Access 2003

  16. Working with the Database Window Be able to identify these elements on the next slide: • Access title bar • Database toolbar • Database window toolbar • Object bar • Status bar Getting Started with Access 2003

  17. Working with the Database Window Access Title Bar Database Toolbar Database Window Toolbar Object Bar Status Bar Getting Started with Access 2003

  18. Navigating Records • Know the keyboard shortcuts • Understand Edit Mode versus Navigation Mode • Recognize the current record symbol Getting Started with Access 2003

  19. Navigating Records Getting Started with Access 2003

  20. Entering Records • Use either New Record button • Be able to move datasheet columns • Be able to move through fields using Tab or Enter • All new records are entered at the end of the datasheet • Records can be reordered by sorting them Getting Started with Access 2003

  21. Entering Records • AutoNumber fields automatically increment to the next value • Correct spelling is important • Manhattan vs. Manhatan vs. Manhatten • Consistent capitalization is important • Cooper vs. cooper vs. COOPER Getting Started with Access 2003

  22. Editing Records • Recognize the Editsymbol • Use the Undo button to undo an entry • Use the Delete Record button • Use Esc to remove changes to a record still being edited • Resize columns to see all data clearly Getting Started with Access 2003

  23. Previewing and Printing a Datasheet • Know how to Zoom in and out • Work with the Page Setup dialog box • Use the Print Preview toolbar Getting Started with Access 2003

  24. Page Setup dialog box • Margins • Print Headings • Page Orientation • Paper Size • Printer • Columns Getting Started with Access 2003

  25. Getting Help and Exiting Access Ways to get Help: • Help menu • Help button • Type a question for help box Getting Started with Access 2003

  26. Getting Help and Exiting Access Ways to exit Access: • Use the File>Exit menu option • Click the Close buttons Getting Started with Access 2003

  27. Summary • Use Access to create and work with relational databases • The database window helps you work with Access objects • Access objects help you find, enter, and manage information • Access Help provides additional information Getting Started with Access 2003

More Related