1 / 25

Microsoft Office Access 2003

Microsoft Office Access 2003. Số tiết: 30 tiết lý thuyết 60 tiết thực hành Giáo viên: Từ thị Xuân Hiền. CHAPTER 1 FUNDAMENTALS. Microsoft Access is a powerful database program, you can use to store all kinds of information.

ejudy
Download Presentation

Microsoft Office Access 2003

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 Access 2003 Số tiết: 30 tiết lý thuyết 60 tiết thực hành Giáo viên: Từ thị Xuân Hiền

  2. CHAPTER 1FUNDAMENTALS

  3. Microsoft Access is a powerful database program, you can use to store all kinds of information. • Once information is stored in a Microsoft Access database, it's easy to find, analyze, and print. • This chapter is your introduction to Microsoft Access and the world of databases.

  4. 1. Introduction to Databases • A database is a collection of information that is organized into a list and stored in a manner similar to a file cabinet. • A database program lets you: • Store Information. • Find Information. • Analyze and Print Information. • Manage and Share Information.

  5. 1. Introduction to Databases • A Microsoft Access database may contain up to seven different database object types: • Tables: store a database's data in rows (records) and columns (fields). • Queries: ask a question of data stored in a table. • Forms: custom screens that provide an easy way to enter and view data in a table or query.

  6. 1. Introduction to Databases • Reports: present data from a table or query in a printed format. • Pages: designed for viewing and working with Microsoft Access data from an intranet or over the Internet. • Macros: help you perform routine tasks by automating them into a single command. • Modules: let you create libraries of functions that you can use throughout your application by using language Visual Basic.

  7. 1. Introduction to Databases • Starting Access : • Click the windows start button. • Select all programsmicrosoft office2003microsoft office access 2003. • Opening a Database: • Click the open button on the toolbar, or • Select fileopen from the menu, or Press ctrl + o.

  8. 2. Understanding the Access Program Screen • The Microsoft Access screen

  9. 2. Understanding the Access Program Screen • Title bar • Menu bar • Toolbar • Database window • Objects bar • Database objects • Status bar

  10. 3. Tour of a Table • The structure of a table

  11. 3. Tour of a Table • To open a table: • Click the tables icon in the objects bar and double-click the table or select the table and click open. • To move to the next record: • Click the next record navigation button, or press the key, or click the record you want to select.

  12. 3. Tour of a Table • To move to the previous record: • Click the previous record navigation button, or press the up arrow key, or click the record you want to select. • To move to the last record in a table: • Click the last record navigation button or press ctrl + end (when not editing record). • To move to the first record in a table: • Click the first record navigation button or press ctrl + home (when not editing record).

  13. 4. Adding, Editing, and Deleting Records • To add a new record: • Click the new record navigation button. Or • Click the new record button on the toolbar. • Enter the record information for the field, pressing tab to move to the next field and shift + tab to move to the previous field.

  14. 4. Adding, Editing, and Deleting Records • To edit a record: • Click the field you want to edit and make the changes. • To delete a record: • Place the insertion point anywhere in the record and click the delete record button on the toolbar.

  15. 5. Tour of a Form

  16. 5. Tour of a Form • Form which is used for adding, viewing, and modifying information in a database should be straightforward and easy. • Forms can also contain buttons that allow you to perform other actions, such as running macros to print reports or labels. • Forms can validate data • To open a form: • Click the forms icon in the objects bar and double-click the form or select the form and click open.

  17. 5. Tour of a Form • To move between records: • Use the record navigation buttons near the bottom of the screen. • To delete a record: • Place the insertion point anywhere in the record and click the delete record button on the toolbar. • To add a new record: • Click the new record navigation button

  18. 6. Tour of a Query • Example: The USA Employees query in Design view

  19. 6. Tour of a Query • Queries ask a question of the information in a table and then retrieve and display the results. • To open a query: • Click thequeries icon in the objects bar and double-click the query or select the query and click open. • To display a query in design view: • Open the query and click the view button on the toolbar or Click the queries icon in the objects bar, select the query, and click design.

  20. 7. Tour of a Report • With a report, you can print database information from tables and queries • Reports are the most static of all the database objects. • Unlike tables and forms, which allow user interaction, reports just sit there, waiting to be printed.

  21. 7. Tour of a Report • To open a report: • Click the reports icon in the objects bar and double-click the query or select the query and click open. • To zoom in print preview: • Click the area you want to zoom (either in or out) with the magnifying glass pointer. • To print a report: • Click the print button on the toolbar, or select fileprint from the menu, or press ctrl + p.

  22. 8. Previewing and Printing a Database Object • The Print Preview toolbar • The Print dialog box

  23. 8. Previewing and Printing a Database Object • To print preview: • Click the print preview button on the toolbar. or select fileprint preview from the menu. • To print: • Click the print button on the toolbar, or select fileprint from the menu, or Press ctrl + p.

  24. 8. Using the Zoom Box • In its current state, the Notes field is not wide enough to display its contents.

  25. 8. Using the Zoom Box • Press Shift + F2 to display the box, making the contents of any cell easier to view and edit.

More Related