Download
microsoft access 2007 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Access 2007 PowerPoint Presentation
Download Presentation
Microsoft Access 2007

Microsoft Access 2007

1808 Views Download Presentation
Download Presentation

Microsoft Access 2007

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Introduction to Database Microsoft Access 2007 Presented By: Sahara Technology Solutions

  2. Agenda for today • Take a Pre-Test • Intro to the Microsoft Access 2007 • Exploring MS Access 2007 • The New Office Ribbon • The MS Access 2007 Menus and Buttons • Exploring MS Access 2007 Objects • Designing a Database • Questions and Demonstrations • Watch a Video • Do Hands-on work (designing a dBase) • Take a Post-Test

  3. Agenda Continued(Hands-on Session) The Hands-On part of this session will touch on the following: Objectives • Building the Database • Setting up Tables and Fields • Building Table Relationships • Entering and Editing Data in Tables • Creating and Using Forms • Making Forms More Usable with Controls • Making Forms Attractive • Analyzing and Reporting Data • Sorting Records • Filtering Records • Using Queries to Make Data Meaningful - Part 1 • Using Queries to Make Data Meaningful - Part 2 • Using Reports to Make Data Meaningful to Others

  4. What is Microsoft Access 2007

  5. Overview of Access • MS Access 2007 is the database software in the Microsoft 2007 Office Suite. It allows you to order, manage, search, and report large amounts of information. • A database contains objects that store, edit, and format information. Data is organized in a database in the form of tables. • Two common types of databases Flat file and Relational. • Flat file: database contains all the data in a single table, • Relational: database stores data in multiple tables.

  6. Access Objects • There are FOUR main objects found in MS Access Databases: • Tables:- a collection of data about a topic arranged in rows and columns. • Forms: - a place to enter data easily • Queries: - a tool that lets you view, change, and analyze data in different ways • Reports:- a method to present your data in a printed format, such as charts & invoices

  7. Access Database Objects • Tables contain rows called records and columns called fields. • Queries are requests for specific information from a database. Queries are virtual tables built on a given SQL statement

  8. Access Database Objects (cont. …) • Forms are parts of user interface. Forms are used to enter, edit or browse data from a database • Reports present requested information and allow to create hard copies.

  9. Text Memo Numbers Byte Integer Long integer Single Double Date/time Currency AutoNumber Yes/No Yes/no True/False 1/0 OLE Objects Hyperlink Lookup Wizard Data Types

  10. Query Criteria • To be selected a record must satisfy a criterion • Expressions may contain the following operators: • Math Operators • Relational operators • Boolean Operators • String Operators • Miscellaneous Operators Marina G. Erechtchoukova

  11. Math Operators Marina G. Erechtchoukova

  12. Relational Operators Marina G. Erechtchoukova

  13. Boolean Operator Marina G. Erechtchoukova

  14. String and Miscellaneous Operators Marina G. Erechtchoukova

  15. Create a Database • click the Start button, and then click All Programs • click Microsoft Office, and then click Microsoft Office Access 2007

  16. Create a Database (cont.) Click Blank Database. Type a name for your database in the File Name Box.

  17. Create a Database (cont.) Create a Database To create fields for the table, double click the Add New Field cell, type First Name and press the ENTER key.

  18. Create a Database (cont.) To add data to the table, type in the data in each field cell.

  19. Entering data Create a Database (cont.) Entering Data

  20. Creating Forms To create a form from a table, click on the Form icon from the Create tab.

  21. Creating Forms (cont.) Entering Data

  22. Database Queries • You use a query to retrieve specific information from a database. • A query is a question that you enter in a database program. • The database program then performs the required operations to present the answer in the form of a report. • A query helps you view specific data to modify or analyze it.

  23. Creating Queries To create a query, click the Create tab. In the Ribbon, click Query Wizard.

  24. Creating Queries (cont.) When the New Query window appears, make sure Simple Query Wizard is selected. Transfer data from the Available Field to the Selected Field one at a time using >

  25. Creating Queries (cont.) When the final screen appears, type the Names of the query

  26. Click the button. . Creating Queries (cont.) The query is automatically saved and executed.

  27. Creating Queries (cont.)

  28. Creating Queries (cont.)

  29. Creating Queries (cont.)

  30. Creating Reports • With a Wizard • Design view: • Specify source for the report • Select Fields from the Fields List • Add labels • Add format • Switch the view to see the result.

  31. Working with Reports To create a report by using the Report Wizard, click the Create tab, and in the Reports group, click Report Wizard.

  32. Working with Reports

  33. Report Design View • Page Header contains data and graphics appearing at the top of each page • Report Header contains the data and graphics appearing at the top of the first report page • Detailed section contains data from tables or queries • Page Footer contains the data and graphics appearing at the bottom of every page • Report Footer contains the data and graphics appearing at the bottom of the last report page

  34. Report Types • Columnar reports– a single record on a page • Tabular reports– datasheets: fields from the tables are presented as columns • Justified reports combine two previous types of the reports

  35. Stop!! Class Activity • Video • Introduction to MS Access 2007

  36. Discussing the Video (Interactive learning) • What did you learn from the video? • How can you use what was learned from the video and the presentation

  37. Class Exercise (Hands-on)The RBHS SUSU club Assignment Objectives • Building the Database • Setting up Tables and Fields • Building Table Relationships • Entering and Editing Data in Tables • Creating and Using Forms • Making Forms More Usable with Controls • Making Forms Attractive • Analyzing and Reporting Data • Sorting Records • Filtering Records • Using Queries to Make Data Meaningful - Part 1 • Using Queries to Make Data Meaningful - Part 2 • Using Reports to Make Data Meaningful to Others

  38. Summary • Reviewed Previous Day’s work • Took a Pre-Test • Discussed Microsoft Access 2007 • Explored MS Access 2007 new interface • New ways to perform familiar tasks • Discussed Access objects • Watched a video • Did hands-on exercises • Take Post Test