Microsoft Access 2010: Fundamentals

Course Overview

Plan, design and create a relational database. Enter, edit, sort and filter data. Use queries to extract and manipulate data. Build forms to display and edit data using custom controls. Create reports to summarise and output data.

For those Microsoft students looking to improve their skills with Access, this Microsoft training course would be a good start.

Related Courses

• Microsoft Access 2010: Introduction for Beginners
• Microsoft Access 2010: Advanced Level 3
• Microsoft Access 2010: Intermediate
• Microsoft Access 2007/2010: Advanced
• Microsoft Access 2010: Specialised
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Advanced
• Microsoft Access 2007/2010: Advanced Skills
• Microsoft Access 2007/2010: Introduction for Beginners
• Microsoft Access 2007 2010: VBA Programming

Audience

Delegates should be familiar with basic PC concepts and the Windows / Microsoft Office environment. Any previous database experience would be advantageous, but none is required to successfully complete the course.

Course Outline

Getting Started

• Understanding database terminology
• Working with the Access interface
• Navigating multiple windows
• Creating a new database
• Using the Help tools

Designing a Database

• Structuring a table
• Using appropriate data types
• Modifying field properties
• What is a relational database?
• Using Primary and Foreign Keys
• Relationships and referential integrity
• Understanding and using different Join types
• Viewing related records
• Using Indexes.

Adding and Entering Data

• Adding new data to a table
• Editing existing data
• Finding data
• Sorting and filtering data
• Deleting data
• Importing data from other sources

Interrogating Data Using Queries

• Creating Select Queries
• Sorting data
• Adding criteria using a variety of data types
• Working with more complex criteria
• Querying related tables
• Modifying Join types to cross reference data
• Using Parameters to improve flexibility
• Performing calculations

Working With Other Query Types

• Updating data using Update Queries
• Deleting data using Delete Queries
• Archiving data using Make Table queries
• Copying information between tables using Append Queries
• Summarizing data using Total and Cross Tab queries

Creating and Customising Data Forms

• Creating data entry forms
• Entering and editing data via a form
• Formatting form items
• Using form sections appropriately
• Modifying form and form item properties
• Adding custom Windows controls to a form
• Adding calculated items to a form
• Displaying related data via sub-forms

Creating and Customising Reports

• Creating simple reports using the Report Wizard
• Formatting report items
• Using report sections appropriately
• Modifying report and report item properties
• Adding custom Windows controls to a report
• Adding calculated items to a report
• Displaying related data via sub-reports
• Sorting and grouping data