Quick Source Learning | Quick Source Learning | Access 2010 Advanced Course

Access 2010 Advanced Course

Microsoft Access

 

"


A10A

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

Database Design Basics

  • Database Design
  • Dividing Information into Tables
  • Setting a Primary Key
  • Creating a Relationship Using the Relationship Window
  • Enforcing Referential Integrity
  • Setting the Join Type
  • Creating an Index

Queries

  • Creating a Crosstab Query
  • Creating a Find Duplicate Query
  • Creating a Find Unmatched Query
  • Creating a Top Values Query
  • Using Parameters in Queries
  • Changing the Query Type
  • Adding Items to a Query

Controls

  • Inserting Controls
  • Working with Control Layouts
  • Changing the Tab Order for Controls
  • Creating a Calculated Control
  • Applying Conditional Formatting
  • Setting a Default Value for a Control
  • Using Windows Themes in Controls

Forms and Subforms

  • Designing a Form
  • Creating a Split Form
  • Adding a Subform to a Form
  • Creating a Form with Nested Subforms
  • Inserting a Datasheet into a Form
  • Creating a Navigation Form
  • Working with the Navigation Form

Reports

  • Creating a Grouped or Summary Report
  • Creating Alternating Row Colors on a Report
  • Setting Section and Report Properties
  • Using the Subreport Wizard
  • Adding a Table, Query, Form, or Report to a Subreport
  • Adding a Table or Query as a Datasheet
  • Distributing a Report by E-Mail
  • Exporting a Report as a PDF or XPS file

Macros

  • Creating a Standalone Macro
  • Grouping Macro Actions
  • Creating an Embedded Macro
  • Running a Macro
  • Adding Error-Handling Actions to a Macro
  • Single Stepping through a Macro
  • Changing Macro Security

Security and Customization

  • Enabling or Disabling Content
  • Using the Trust Center
  • Creating a Signed Package
  • Extracting and Using a Signed Package
  • Encrypting a Database with a Password
  • Opening and Decrypting a Database
  • Customizing Access options

Extras

  • Attaching Files
  • Working with Attachments
  • Using the Expression Builder
  • Entering an Input Mask in a Table
  • Entering an Input Mask in a Query or Control
  • Collecting Data Using E-Mail
  • Preventing the Navigation Pane from Appearing by Default

 

More in this category: Access 2010 Basic Course »