Course

10103145 Access
Course Information
Description
Learn Microsoft Access database software to manage information, data, and records. Create, edit, and manipulate databases; add tables to organize data; create relationships; perform queries to extract information; create and use forms; develop reports for data analysis and reporting to stakeholders; use settings within Access to ensure efficient and accurate data entry.
Total Credits
1
Prior Learning Assessment
  • Exam-College Developed Challenge Exam
Course Competencies
  1. CREATE A DATABASE AND TABLES
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    Criteria
    1.1 Examine Database Concepts
    o Examine Database Objects
    o Use the Navigation Pane
    o Use Datasheet and Design View of a Table
    1.2 Create and Manage a Database
    o Use Templates
    o Review Database Properties
    o Create a Blank Database
    o Study Access Naming Rules
    o Investigate Data Types
    o Create and Save Database Objects
    o Open Database Objects
    o Rename Database Objects
    o Delete Database Objects
    o Close and Open a Database
    o Back Up and Recover a Database
    1.3 Create and Use a Table in Datasheet View
    o Create a New Table in Datasheet View
    o Edit the Primary Key
    o Add New Fields
    o Delete Fields
    o Edit Properties in Datasheet View
    o Add a Table Description
    o Save a Table
    o Close a Table
    o Open a Table
    o Rename a Table
    o Add, Edit, and Delete Records
    o Review Edit and Navigation Modes
    1.4 Import records from Excel
    1.5 Explore Datasheet View
    o Use Navigation Buttons
    o Modify the Field Order
    o Select a Display Font Face and Font Size
    o Modify the Row Height
    o Modify the Column Width
    o Modify the Field Alignment
    o Display Gridlines
    o Display Alternate Row Colors
    o Use the Datasheet Formatting Dialog Box
    o Hide and Unhide Table Fields
    o Add Total Rows
    o Save Changes
    1.6 Use Search, Sort, and Filter Tools to Find Records in a Table
    o Search Data in a Table
    o Sort Data in a Table with Datasheet View
    o Sort Data on a Single Field
    o Sort Data on Multiple Fields
    o Remove Sorting Criteria
    o Filter Data in a Table with Datasheet View
    o Create a Filter by Selection
    o Create a Text Filter, Number Filter, or Date Filter
    o Create Compound Filter Criteria
    o Remove Filter Criteria

  2. USE DESIGN VIEW, DATA VALIDATION, AND RELATIONSHIPS
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    Criteria
    2.1 Create a Table in Design View
    o Create a New Table in Design View
    o Add New Fields
    o Define a Primary Key
    o Delete Fields in a Table
    o Save, Close, Rename, and Open a Table
    2.2 Set Field Properties
    o Set the Field Size
    o Set Number and Currency Field Formats
    o Set Date/Time Field Formats
    o Set Yes/No Field Formats
    o Set Short Text and Long Text Field Formats
    o Set the Caption Property
    o Set the Default Value
    o Set the Required Property
    o Set the New Values Property
    2.3 Investigate Data Integrity and Data Validation
    2.4 Integrate Data Validation in Tables
    o Add Field Validation Rules
    o Add Record Validation Rules
    o Test Validation Rules
    o Create Validation Text
    o Create a Lookup Field
    o Define an Input Mask
    2.5 Change Field Properties after Records Are Added to a Table
    2.6 Design Relational Databases
    o Study Relational Principles
    o Describe the Steps to Design a Relational Database
    o Set up a One-to-One Relationship
    o Set up a One-to-Many Relationship
    o Set up a Many-to-Many Relationship
    o Describe a Foreign Key
    o Define a Relationship Using the Relationships Window
    o Enforce Referential Integrity
    o Cascade Updates
    o Cascade Deletes
    o Save a Relationship
    o Delete a Relationship between Tables
    o Edit a Relationship between Tables
    2.7 Print the Contents of a Table
    o Preview the Data Records
    o Print the Data Records without Previewing
    2.8 Use the Compact & Repair Database Utility

  3. CREATE AND USE QUERIES
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    Criteria
    3.1 Explore Queries and Use the Simple Query Wizard
    3.2 Create, Run, and Edit a Query in Design View
    o Create a Query Based on a Single Table
    o Add Fields into a Query
    o Run a Query
    o Switch Between Datasheet and Design Views
    o Save and Close a Query
    o Open a Saved Query
    o Rename a Query
    o Create a Query Based on Multiple Tables
    o Edit Fields in Query Design
    3.3 Add a Criterion to a Query
    o Use a Single Criterion
    o Use Comparison and Special Operators
    o Use Functions as Criteria
    o Use Wildcards in Criteria
    3.4 Control the Display of Query Results
    o Create a Filter by Selection
    o Create a Text Filter, Number Filter, or Date Filter
    o Create Compound Filter Criteria
    o Use the Unique Values Property
    o Use the Show Option for Query Fields
    o Apply Sorting
    o Format Query Fields
    3.5 Define Multiple Criteria in a Query
    o Use the AND Operator
    o Use the OR Operator
    o Combine the AND and OR Operators
    3.6 Create and Use a Simple Parameter Query
    o Create a Parameter
    o Enter the Parameter Data Type
    o Use Wildcards in a Parameter Query
    3.7 Adding Calculated Fields to a Query
    o Enter a Formula in a Calculated Field
    o Troubleshoot Calculated Fields
    o Use Functions in a Calculated Field
    3.8 Create and Use a Summary Query
    o Use Aggregate Functions
    o Build a Summary Query
    3.9 Build a Crosstab Query

  4. CREATE AND USE FORMS AND REPORTS
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    Criteria
    4.1 Create and Work With a Simple Form
    o Use the Form Wizard
    o Use the Form Button
    o Create a Split Form
    o View or Modify a Form
    o Save a Form
    o Open a Saved Form
    o Delete a Form
    4.2 Create and Customize a Form in Layout View
    o Create a Form Using the Blank Form Button
    o Use Form Controls
    o Add Fields to a Control Layout
    o Delete Fields from a Control Layout
    o Change Control Layouts
    o Adjust Control Widths and Heights
    o Add and Delete Rows and Columns in a Control Layout
    o Move a Control within a Layout
    o Move Control Layouts
    o Change the Font Options in a Form Control
    o Adjust Control Positioning in a Form
    o Sort Records on a Form
    o Add a Title, Date, or Logo to a Form
    o Add and Modify a Label on a Form
    o Create a Form from a Template with Applications Parts
    4.3 Facilitate Data Input with a Form
    o Restrict a Form to Data Entry
    o Limit Edits and Deletions on a Form
    o Add a Command Button
    o Test a Form
    4.4 Create and Work with a Simple Report
    o Use the Report Wizard
    o View or Modify a Report
    o Save a Report
    o Open a Saved Report
    o Delete a Report
    4.5 Creating and Customizing a Report in Layout View
    o Use the Blank Report Button
    o Investigate Report Control Layouts
    o Add and Delete Fields in a Control Layout
    o Customize a Report in Layout View
    o Adjust Column Widths
    o Add and Delete Rows and Columns in a Control Layout
    o Move a Control within a Layout
    o Change the Font Options in a Report Control
    o Adjust Control Positioning on a Report
    o Add a Title, Logo, Date, or Page Numbers to a Report Header or Footer
    o Add and Modify a Label on a Report
    4.6 Add Grouping, Sorting, and Totals
    o Review Sorting
    o Add a Group to a Report
    o Study Group and Sort Options
    o Add Totals to a Report
    4.7 Use Conditional Formatting in a Report
    o Describe Conditional Formatting Rules
    o Add Conditional Formatting to a Report
    o Manage Conditional Formatting Rules
    4.8 Print a Report
    o Preview a Report
    o Print a Report without Print Preview
    o Format and Print a Report with Multiple Columns