Sign In
Access 2010: Beginning
​Audience ​This course is designed for individuals interested in learning the skills necessary to design and create new databases, tables, and relationships, locate records using queries, create forms, and produce reports.
​Description ​Upon completion of this course, individuals will be able to:
  • Identify the basic components of a Microsoft Office Access 2010 database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports
​Prerequisites ​Microsoft Office Windows experience
​Suggested Class Size

​Minimum 3
Maximum 12

​Course Length ​Full day
Content 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
  
   

© 2015 Brazosport College | 500 College Drive | Lake Jackson, TX 77566 | (979) 230-3000 | Webmail | ASTRA | BC Alert | F.A.S. | Institutional Profile | Equal Opportunity | Login

A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu