Transcript Make the switch to Access 2010

Before you begin
If a yellow security bar appears at the top of the
screen in PowerPoint, click Enable Editing.
You need PowerPoint 2010 to view this
presentation. If you don’t have PowerPoint 2010,
download the PowerPoint Viewer (see the URL in
the notes pane).
®
®
Microsoft Access 2010 Training
Make the switch to Access 2010
Course contents
• Overview: Let’s get up to speed
• Lesson: Includes six instructional movies
• Suggested practice tasks
• Test
• Quick Reference
Make the switch to Access 2010
Overview: Let’s get up to speed
If you’re an experienced Access user,
this course is for you: the course
explains how to switch to Access 2010
from a previous version.
Here you’ll learn how to perform
familiar tasks in Access 2010, such as
using existing databases, creating new
databases, building tables, and editing
forms and reports.
Make the switch to Access 2010
Course goals
• Use Backstage view to open existing databases
and create new databases.
• Save an existing database as an Access 2010 file.
• Use the ribbon to start Design view for tables,
forms, reports, and queries.
• Use Layout view to edit forms and reports.
• Use Layout view to group data in reports.
Make the switch to Access 2010
Get started with Access 2010
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Start something with the Navigation Pane
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Get to know the ribbon
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Use files from previous versions
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Get started fast: templates and web databases
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Design on the fly with Layout view
Point to the bottom of the video to see the video controls. Drag or point
along the progress bar to move forward or go back.
Make the switch to Access 2010
Suggestions for practice
1. Create a new, blank database.
2. Add fields to a table.
3. Navigate the Navigation Pane.
4. Navigate the ribbon.
5. Publish a web database.
6. Change a web database and save your changes to the
web.
Online practice (requires Access 2010)
Make the switch to Access 2010
Test question 1
You can use Design view to change the forms and reports
in a web database. (Pick one answer.)
1. True.
2. False.
Make the switch to Access 2010
Test question 1
You can use Design view to change the forms and reports
in a web database.
Answer:
2. False.
You can use Layout view to change the forms and reports in
a web database, but not Design view.
Make the switch to Access 2010
Test question 2
As soon as you open an Access 97 database in Access
2010, you can enter data and make design changes. (Pick
one answer.)
1. True.
2. False.
Make the switch to Access 2010
Test question 2
As soon as you open an Access 97 database in Access
2010, you can enter data and make design changes.
Answer:
2. False.
In that scenario, you can only read data. If you want to do
more, save the file in the Access 2010 file format.
Make the switch to Access 2010
Test question 3
You can publish a web database to any web site. (Pick one
answer.)
1. True.
2. False.
Make the switch to Access 2010
Test question 3
You can publish a web database to any web site.
Answer:
2. False.
Your Microsoft SharePoint® 2010 server has to run Access
Services.
Make the switch to Access 2010
Test question 4
In the Navigation Pane, you open a form for data entry by
doing which of the following? (Pick one answer.)
1. Right-clicking the form and clicking Design view.
2. Double-clicking the form.
3. You don’t use the Navigation Pane. You use the Open
command on the Home tab of the ribbon.
Make the switch to Access 2010
Test question 4
In the Navigation Pane, you open a form for data entry by
doing which of the following?
Answer:
2. Double-clicking the form.
You can also right-click an object and click Open.
Make the switch to Access 2010
Test question 5
When you save an MDB file in the new file format (as an
ACCDB file), you can open that new file in Access 2003.
(Pick one answer.)
1. True.
2. False.
Make the switch to Access 2010
Test question 5
When you save an MDB file in the new file format (as an
ACCDB file), you can open that new file in Access 2003.
Answer:
2. False.
You can only open ACCDB files in Access 2007 or 2010.
Also, remember that any features unique to 2010 won’t
work in 2007.
Make the switch to Access 2010
Quick Reference Card
For a summary of the tasks covered in this course, view the
Quick Reference Card.
Make the switch to Access 2010