Microsoft Access 2010: Level 3

Length: 1 day(s) | Audience: Information Worker | Level: 3

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization.

You will:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Organize a database for efficiency, performance, and to maintain data integrity.
  • Share data between Access and other applications.
  • Customize reports to organize the displayed information and produce specific print layouts

Lesson 1: Advanced Form Design

Topic A: Adding Controls to Forms

Topic B: Creating Subforms

Topic C: Organizing Information with Tab Pages

Topic D: Displaying a Summary of Data in a Form

Topic E: Applying Conditional Formatting

Lesson 2: Data Validation

Topic A: Field and Record Validation

Topic B: Form Validation

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Creating a Macro

Topic B: Restricting Records Using a Condition

Topic C: Validating Data Using a Macro

Topic D: Automating Data Entry Using a Macro

Topic E: Converting a Macro to VBA

Lesson 5: Distributing and Securing a Database

Topic A: Preparing a Database for Multiple User Access

Topic B: Implementing Security

Topic C: Setting Passwords

Topic D: Converting an Access Database to an ACCDE File

Topic E: Packaging a Database with a Digital Signature

Lesson 6: Managing Switchboards

Topic A: Creating a Database Switchboard

Topic B: Modifying a Database Switchboard

Topic C: Setting Startup Options

To ensure your success in your course you should have experience working with Microsoft Access 2010, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

Microsoft® Office Access® 2010: Level 1

Microsoft® Office Access® 2010: Level 2