UMBC Training Centers logo

Microsoft® Office Access® 2010: Level 1

 

Course Description | Outline | Business Applications Training | IT Training

Persistent Attack and Exploitation: Offense

 

 

Course Outline

 
Lesson 1: Getting Started with Access Databases

Topic 1A: Identify the Elements of the Access 2010 Interface
Topic 1B: Identify the Components of a Database
Topic 1C: Examine the Relational Database Design Process
Lesson 2: Building the Structure of a Database

Topic 2A: Create a New Database
Topic 2B: Create a Table Using the Design View
Topic 2C: Manage Tables
Topic 2D: Establish Table Relationships
Lesson 3: Managing Data in a Table

Topic 3A: Modify Table Data
Topic 3B: Sort and Filter Records
Topic 3C: Work with Subdatasheets
Lesson 4: Querying a Database

Topic 4A: Create a Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform Calculations on a Record Grouping
Lesson 5: Designing Forms

Topic 5A: Create a Form
Topic 5B: Modify the Design of a Form
Topic 5C: View and Edit Data Using an Access Form
Lesson 6: Generating Reports

Topic 6A: Create a Report
Topic 6B: Add a Control to a Report
Topic 6C: Format the Controls in a Report
Topic 6D: Enhance the Appearance of a Report
Topic 6E: Prepare a Report for Print