Introduction to Database Microsoft Access 2007 Presented By: Sahara Technology Solutions
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
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
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.
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
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
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.
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
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
Math Operators Marina G. Erechtchoukova
Relational Operators Marina G. Erechtchoukova
Boolean Operator Marina G. Erechtchoukova
String and Miscellaneous Operators Marina G. Erechtchoukova
Create a Database • click the Start button, and then click All Programs • click Microsoft Office, and then click Microsoft Office Access 2007
Create a Database (cont.) Click Blank Database. Type a name for your database in the File Name Box.
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.
Create a Database (cont.) To add data to the table, type in the data in each field cell.
Entering data Create a Database (cont.) Entering Data
Creating Forms To create a form from a table, click on the Form icon from the Create tab.
Creating Forms (cont.) Entering Data
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.
Creating Queries To create a query, click the Create tab. In the Ribbon, click Query Wizard.
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 >
Creating Queries (cont.) When the final screen appears, type the Names of the query
Click the button. . Creating Queries (cont.) The query is automatically saved and executed.
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.
Working with Reports To create a report by using the Report Wizard, click the Create tab, and in the Reports group, click Report Wizard.
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
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
Stop!! Class Activity • Video • Introduction to MS Access 2007
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
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
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