State Employees: Training Classes for ND State Employees
Access 2010 Module 2
Prerequisite
Basic computer skills - use of mouse, keyboard, and understanding of Windows.
Lesson 1: Creating and Using Forms
- Introduction to Forms
- Creating Forms Using AutoForm
- Creating Forms Using the Form Wizard
- Working with Form Controls
- Error Checking in Forms and Reports
- Adding and Deleting Controls
- Moving and Sizing Controls
- Aligning and Spacing Controls
- Working with Control Properties
- Working with Form Properties
- Working with Headers and Footers
- Printing Forms
- Using Forms to Add Records
- Sorting Records in Form View
Lesson 2: Using Subforms1
- Overview of Subforms
- Creating Subforms
- Using the SubForm Wizard
- Creating Subforms Using Drag-and-Drop
- Displaying Information with Subforms
- Changing the Subform View
- Changing the Subform Layout
- Using Subforms to Add Table Records
Lesson 3: Using Advanced Form Features 1
- Creating Forms in Design View
- Using Calculated Controls
- Adding an Unbound Control
- Understanding the Syntax of an Expression
- Creating an Expression Manually
- Creating an Expression Using the Expression Builder
- Improving Data Entry Accuracy
- Using Shortcut Keys
- Setting the Tab Order
Lesson 4: Creating and Using Reports
- Advantages of Reports
- Creating Reports Using AutoReport
- Creating Reports Using the Report Wizard
- Examining Report Sections
- Working with Report Controls
- Adding and Deleting Controls
- Adding a Calculated Control to a Report
- Moving, Sizing, Aligning and Spacing Controls
Lesson 5: Using Advanced Report Features
- Working with Report Control and Section Properties
- Grouping and Sorting Records in Reports
- Changing Report Properties
- Printing Reports
- Creating Reports in Design View
- Customizing Headers and Footers
- Forcing Pagination
- Concatenating Text Fields
- Working with Subreports
Lesson 6: Enhancing Forms and Reports
- Using AutoFormat
- Changing the Appearance of Forms and Reports
- Applying Special Effects to Forms and Reports
- Applying Colors to Forms and Reports
- Formatting Form Sections
- Adding Graphics to Forms and Reports
Lesson 7: Using Data Access Pages
- Introduction to Data Access Pages
- Saving Forms and Reports as Data Access Pages
- Using the Page Wizard
- Creating Data Access Pages in Design View
- Saving PivotTables and PivotCharts as Data Access Pages
Lesson 8: Managing Databases
- Importance of Database Management
- Working with Object Dependencies
- Identifying Object Dependencies
- Modifying Object Dependencies
- Compacting and Repairing Databases
- Backing Up Databases
Lesson 9: Importing and Exporting Data
- Introduction to Importing and Exporting Data
- Importing Data into Tables
- Importing Data into New Tables
- Appending Imported Data to Existing Tables
- Exporting Data to Other Office 2003 Applications
- Working with XML Documents
- Exporting Access Data as XML Documents
