- Home /
- Shop All /
- User Productivity /
- Microsoft Office /
- Microsoft Office Access 2010: Level 4
Product Description
Course length: 1.0 day(s)
Target Student: This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.
Prerequisites: To ensure the successful completion of Microsoft® Office Access® 2010: Level 4, the following Element K courses or equivalent knowledge is recommended:
Microsoft® Office Access® 2010: Level 4
Course Specifications
Course number: 084590Course length: 1.0 day(s)
Course Description
Course Objective: You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.Target Student: This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.
Prerequisites: To ensure the successful completion of Microsoft® Office Access® 2010: Level 4, the following Element K courses or equivalent knowledge is recommended:
- Microsoft® Office Access® 2010: Level 1
- Microsoft® Office Access® 2010: Level 2
- Microsoft® Office Access® 2010: Level 3
Hardware Requirements
For this course, you will need one computer to run Windows Server 2003 and Active Directory Services. This system should have the following configuration:- A minimum of 2 GB of RAM.
- Disk partitions formatted as the NTFS.
- At least 40 GB hard disk space or larger.
- 500 MB of available disk space on the system drive.
- A DVD-ROM drive, local or network accessible.
- A 800 x 600 resolution or higher SVGA monitor.
- A keyboard and mouse, or other pointing device.
- Paging file size should be equal to the amount of RAM on the server plus 10 MB.
- An x64 architecture-based computer with an Intel processor that supports an Intel Extended Memory 64 Technology (Intel EM64T) or AMD processor that supports the AMD64 platform.
- A minimum of 4 GB of RAM per server plus 5 MB of RAM for each mailbox.
- Disk partitions formatted as the NTFS.
- At least 80 GB hard disk space or larger.
- 2 GB of available disk space on the system drive.
- A DVD-ROM drive, local or network accessible.
- A 800 x 600 resolution or higher SVGA monitor.
- A keyboard and mouse, or other pointing device.
- Paging file size should be equal to the amount of RAM on the server plus 10 MB.
- 1 GHz Pentium®-class processor or faster.
- A minimum of 1 GB of RAM is recommended.
- 20 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for Office 2010 installation.
- A DVD-ROM drive.
- A keyboard and mouse or other pointing device.
- A 1024 x 768 resolution SVGA monitor is recommended.
- Network cards and cabling for local network access.
- Internet access (check with your local network administrator).
- A printer (optional) or an installed printer driver.
- A projection system to display the instructor's computer screen.
Software Requirements
Windows Server 2003 and Active Directory Domain Controller:
- Microsoft® Windows® Server 2003, Enterprise Edition with SP2
- Microsoft® Management Console (MMC) 3.0
Windows Server 2008 and SharePoint 2010 Server:
- Microsoft® Windows® Server 2008, Enterprise Edition
- Microsoft® Office SharePoint® Server 2010
On Student and Instructor Computers:
- Microsoft® Windows® XP Professional with Service Pack 3
- Microsoft® Office Professional Edition 2010
- Microsoft® .NET Framework 3.5 SP1
- Microsoft® Windows® Search 4.0 (KB940157)
- Microsoft® Windows® Rights Management Services (RMS) Client with Service Pack 3
Course Objectives
Upon successful completion of this course, students will be able to:- share Access data with other applications.
- use VBA to automate a business process.
- create and modify a database switchboard and set the startup options.
- secure and distribute databases.
- share databases using a SharePoint site.
Course Content
- Lesson 1: Integrating Access into Your Business
- Topic 1A: Import XML Data into an Access Database
- Topic 1B: Export Access Data to the XML Format
- Topic 1C: Export Data to an Outlook Address Book
- Topic 1D: Collect Data Through Email Messages
- Lesson 2: Automating a Business Process with VBA
- Topic 2A: Create a Standard Module
- Topic 2B: Develop Code
- Topic 2C: Call a Procedure from a Form
- Topic 2D: Run a Procedure
- Lesson 3: Managing Switchboards
- Topic 3A: Create a Database Switchboard
- Topic 3B: Modify a Database Switchboard
- Topic 3C: Set the Startup Options
- Lesson 4: Distributing and Securing Databases
- Topic 4A: Split a Database
- Topic 4B: Implement Security
- Topic 4C: Set Passwords
- Topic 4D: Convert an Access Database to an ACCDE File
- Topic 4E: Package a Database with a Digital Signature
- Lesson 5: Sharing Databases Using a SharePoint Site
- Topic 5A: Export a Table to a SharePoint List
- Topic 5B: Import Data from a SharePoint List
- Topic 5C: Publish a Database to a SharePoint Site
- Topic 5D: Move a Database to a SharePoint Site
- Topic 5E: Work Offline