Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive, and provides you with easier data manipulation techniques.
This course explains the use of table templates, Design and Datasheet views, field creation, data types, and modifiable properties, and demonstrates the use of masked input fields and indexing. The course also explores viewing, editing, navigating, sorting, finding, and filtering records, in addition to printing data and implementing and maintaining table relationships.
Target Audience
End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.
Prerequisites
Familiarity with a Windows environment
Lesson Objectives
Creating Tables in Access 2007
- create a table from a template in a given scenario
- identify the elements in an Access 2007 table
- identify the table templates
Using the Design and Datasheet Views in Access 2007
- create a table using Datasheet view
- create a table using Design view
Modifying Tables in Access 2007
- modify a table
- modify a table in Design view
- create a validation rule
Using Masked Input Fields and Indexing in Access 2007
- create a masked input field in a table
- apply indexing to a table
Creating and Modifying a table in Access 2007
Manipulating Data in Records in Access 2007
- view, edit, and navigate records
- sort and filter data
- find and replace data
- print records
Setting up Relationships between Access 2007 Tables
- create a relationship
Filtering Data and Creating Table Relationships in Access 2007
Creating a Relational Database in Access 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-605 Using Microsoft Office Access 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Beginning Access
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Access 2007: Basics
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|