Access 2010 - Part 2

Course details

Students will expand their knowledge of Microsoft® Access® 2010 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports.

Course Outline 

1 - Advanced Form Design

• Adding Controls to Forms 
• Creating Subforms 
• Organizing Information with Tab Pages 
• Displaying a Summary of Data in a Form 
• Applying Conditional Formatting

2 - Data Validation

• Field and Record Validation 
• Form Validation

3 - Using Macros to Improve User Interface Design

• Creating a Macro 
• Restricting Records Using a Condition 
• Validating Data Using a Macro 
• Automating Data Entry Using a Macro 
• Converting a Macro to VBA

4 - Advanced Database Management

• Linking Tables to External Data Sources 
• Managing a Database 
• Determining Object Dependency 
• Documenting a Database 
• Analyzing the Performance of a Database

5 - Distributing and Securing a Database

• Preparing a Database for Multiple User Access 
• Implementing Security 
• Setting Passwords 
• Converting an Access Database to an ACCDE File 
• Packaging a Database with a Digital Signature

6 - Managing Switchboards

• Creating a Database Switchboard 
• Modifying a Database Switchboard 
• Setting Startup Options 

Target Audience: This course is designed for students wishing to gain intermediate-level skills or inpiduals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.