get to know access 2007

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Microsoft® Office Access™ 2007 Overview:

Microsoft ® Office Access ™ 2007 Overview Get to know Access Tappan Library

Course goals :

Get to know Access 2007 Course goals What’s a database? When to choose Access or Excel Find out what Access can do for you Search, download and use Access 2007 templates Provide resources for further learning

What’s a database?:

Get to know Access 2007 What’s a database? If you’ve got data, you’ve got lists and that’s a database! Phone books, recipe cards, contacts in your email address book. Those are all databases. Access & Excel organize your data by rows and columns. Access & Excel call rows records and columns fields . The table is called a database.

“Relational” means data in multiple tables:

Get to know Access 2007 “Relational” means data in multiple tables A relational data structure divides your information into logical pieces, and places each piece in a separate table. For example, a Sales database puts customer names, addresses, and other key facts — in one table, and information about what those customers order in another table.

To relate, or not to relate? :

Get to know Access 2007 To relate, or not to relate? So how can you tell if you need a relational structure? Actions and repeated data need a relational structure. The customer Hanari Carnes... Take the example pictured here: ...places an order on July 8... ...and another on July 10. One customer, many actions.

When to choose Access or Excel.:

Get to know Access 2007 When to choose Access or Excel. They’re both databases. Wondering when to use Access over Excel? $149 vs $499 Are you tracking expenses? Mostly numbers? Need to do calculations? That’s where Excel shines. Keeping track of text & numbers but don’t need too many formulas? Want an easy way to input data and generate reports? Access is for you.

Tables have relationships:

Get to know Access 2007 Tables have relationships Access is different because it can use related tables. It’s designed so that one table can find and use data in another table. That way, when you keep track of work items, for example, there’s no need to type employee names or project names that you’ve already stored. It prevents data redundancy and saves storage.

Tables have relationships:

Get to know Access 2007 Tables have relationships The picture shows that Projects have related tasks and employees assigned to them. You enter a new task in the Tasks table. As part of that, you select a project number from the Project field, which uses data from the Projects table and Employees table.

How does Access 2007 work? :

Get to know Access 2007 How does Access 2007 work? Even if you’ve never used Access before, you can be working with your own Access 2007 database in five minutes or less. You’ll see the Getting Started page when you open Access 2007. After you’ve opened a database, you can return to the Getting Started page at any time by closing the database.

Take it easy, make it easy: templates:

Get to know Access 2007 Take it easy, make it easy: templates Access 2007 database templates mean that you can start a database in moments, without having to design and create it. Popular useful databases are provided for you. They’re free, they’re built for the purpose, and new ones keep getting added to the Getting Started page.

Command your database: the Ribbon:

Get to know Access 2007 Command your database: the Ribbon The Ribbon at the top of every screen shows you all the commands for working with a database. On the Create tab, for example, you’ll find the commands to create new tables and other database objects. You’ll use the External Data tab when you want to import or export data.

Getting started is a breeze:

Get to know Access 2007 Getting started is a breeze When you first open them, most templates display a form . Usually, it’s the form you’ll use the most. You get started with your new database by entering data in that form. That’s really all it takes to get started — download the database and start typing.

What can Access do for you?:

Get to know Access 2007 What can Access do for you? Another Access advantage: Forms and Reports make data easy to see. Lists and worksheets can be hard to read. They go up and down, back and forth, over and over. In contrast, Access forms and reports let you show only the data you need, with the look you like.

Forms follow function:

Get to know Access 2007 Forms follow function Forms help you quickly see just what’s important. A form can show you the data from one table or from more than one table, so that you can see all the data you want in one place (or hide data). A form connected to more than one table lets you enter data without having to open those tables.

Create a new form or report:

Get to know Access 2007 Create a new form or report The template databases in Access 2007 contain many forms and reports, designed to fill your needs for each particular kind of data. If you want a new form or report, it’s easy to create one any time. The Create tab on the Ribbon has commands for all sorts of new database objects.

Let’s try out Access 2007 :

Get to know Access 2007 Let’s try out Access 2007 Let’s take the rest of our time with Access 2007. You’ll see the Getting Started page when you open Access 2007.

Resources for continued learning & practice :

Get to know Access 2007 Resources for continued learning & practice Microsoft Access Home Page Access 2007 Training Courses Access 2007 Demos Access 2007 Webcasts Access 2007 Quick Reference Guide Book – Simplified Office 2007 - Sherry Willard Kinkoph Book – Picture Yourself Learning Microsoft Access 2007 - Faithe Wempen

authorStream Live Help