Quick Source Learning | Quick Source Learning | Access 2010 Basic Course

Access 2010 Basic Course

Microsoft Access

 

"


 

A10B

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:

Getting Started

  • Starting and Exiting Microsoft Access 2010
  • Identifying the Parts of the Access Window
  • Using the Ribbon
  • Using the Quick Access Toolbar
  • Creating a New Database   
  • Creating a Database Based on a Template
  • Opening an Existing Database   

Database Objects and Views

  • Working with Database Objects
  • Saving a Database Object
  • Copying a Database Object
  • Using the Search Bar
  • Viewing Information on Object Dependencies 
  • Working with Views
  • Navigating in Form, Datasheet, or Layout View

Tables

  • Creating a New Blank Table
  • Adding Fields to a Table in Datasheet View
  • Adding Fields to a Table in Design View
  • Selecting Records and Fields in Datasheet View
  • Adding a Record
  • Deleting a Record or Field
  • Setting or Changing Field Properties
  • Setting Table Properties

Queries

  • Using the Query Wizard
  • Designing a Query
  • Using Query Criteria
  • Sorting in a Queries
  • Select Queries
  • Make Table Queries
  • Append Queries
  • Update Queries
  • Delete Queries

Forms

  • Creating a Form
  • Using the Blank Form Tool
  • Using the Form Wizard
  • Form Sections
  • Controls
  • Tabbed Pages
  • Creating a Subform Using the Form Wizard

Reports

  • Creating a Report
  • Using the Blank Report Tool
  • Using the Report Wizard
  • Report Sections
  • Grouping and Sorting
  • Views
  • Printing

Data

  • Entering Data
  • Sorting and Filtering Data
  • Importing Data
  • Formatting Text 
  • Moving and Copying Text
  • Using the Office Clipboard
  • Finding and Replacing Data

Output and Help

  • Backing Up a Database
  • Converting a Database
  • Exporting Data to Another Access Database
  • Exporting Data to Excel
  • Exporting Data to Other Formats
  • Using Access Help
  • Displaying Access Keys