Microsoft® Office Access® 2010: Transition from Access® 2003
Overview
You will identify and use the new and enhanced features to Microsoft® Office Access® 2010 since the release of Microsoft Access 2003.
Prerequisites
Students enrolling in this course should have worked on Access 2003 or earlier, and be familiar with the Internet. This course covers the commonly used new features for a typical user.
Target Student:
This course is designed for experienced Access users who have worked with the earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2010.
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:
- 1 GHz Pentium-class processor or faster
- Minimum 1 GB of RAM is recommended
- 10 GB hard disk or larger. (You should have at least 1 GB of free hard disk space available for the Office installation.)
- CD-ROM drive
- Mouse or other pointing device
- 1024 x 768 resolution monitor recommended
- Network cards and cabling for local network access
- Internet access (contact your local network administrator)
- Printer (optional) or an installed printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- Projection system to display the instructor’s computer screen
Software Requirements
Each computer requires the following software:
- Microsoft® Office Professional Plus 2010 (Beta)
Microsoft® Silverlight™ 3.0
Course Objectives
Upon successful completion of this course, students will be able to:
- identify the components of the Microsoft Office Access 2010 interface.
- build tables and forms and also work with macros.
- create queries and reports.
- work with external data.
- build a database for the web.
Course duration
0.5 Day(s)
Course outline
- Lesson 1: Identifying the Components of the Access 2010 Environment
- Topic 1A: Explore the User Interface
- Topic 1B: Access Commands on the Ribbon Tabs
- Topic 1C: Access the Contextual Tabs
- Topic 1D: Customize the Access Environment
- Lesson 2: Building Tables and Forms
- Topic 2A: Create a Table
- Topic 2B: Build Forms from Existing Table Data
- Topic 2C: Design a Form
- Topic 2D: Work with Macros
- Lesson 3: Creating Queries and Reports
- Topic 3A: Query a Database
- Topic 3B: Generate Reports
- Topic 3C: Format a Report
- Lesson 4: Working with External Data
- Topic 4A: Import Data
- Topic 4B: Export Data to Other Applications
- Lesson 5: Building a Database for the Web
- Topic 5A: Create Tables and Forms in a Web Database
- Topic 5B: Create Queries and Reports in a Web Database
- Topic 5C: Prepare to Publish a Database to Access Services
Appendix A: New
Features in Microsoft Office Access 2010
Appendix B: Enhanced
File and Compatibility Features in Access
Appendix C: Publish
a Database to Access Services
