Quick Source Learning | Quick Source Learning | Access 2013 Basic Course

Access 2013 Basic Course

access2013

 

"


 

A13B

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

  • Introduction
  • Starting and Exiting Access 2013
  • Identifying the Parts of the Access 2013 Window
  • Accounts and Services
  • Using the Ribbon
  • Using the Quick Access Toolbar
  • Opening an Existing Database
  • Creating a Blank Desktop Database
  • Using Templates

Database Objects and Views

  • Introduction
  • Working with Database Objects
  • Working with Tabs
  • Saving a Database Object
  • Copying a Database Object
  • Using the Search Bar
  • Working with Views
  • Navigating in Form, Datasheet, or Layout View

Tables

  • Introduction
  • 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 Field Properties
  • Creating a Table Relationship

Queries

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

Forms

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

Reports

  • Introduction
  • Creating a Report
  • Using the Blank Report Tool
  • Using the Report Wizard
  • Designing a Report
  • Using the Group, Sort, and Total Pane
  • Views
  • Printing a Report

Data

  • Introduction
  • Sorting Data
  • Filtering Data
  • Importing Data
  • Creating a Custom Web App
  • Adding a Table to an App
  • Launching an App
  • Adding a Custom Action to the Action Bar

Output and Help

  • Introduction
  • Backing Up a Database
  • Finding and Replacing Data
  • Exporting Data to another Access Database
  • Exporting Data to Excel
  • Exporting Data to Other Formats
  • Using Access Help

 

More in this category: « PowerPoint 2013 Basic Course