10103145Access
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. Develop a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Implement database concepts
    Describe the features of the Access window
    Create a database
    Create tables in Datasheet and Design views
    Add records to a table
    Close a database
    Open a database
    Print the contents of a table
    Import data
    Create and use a query
    Create and use a form
    Create and print custom reports
    Modify a report in Layout View
    Perform special database operations
    Design a database to satisfy a collection of requirements

  2. Query a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Create queries using Design view
    Include fields in the design grid
    Use text and numeric data in criteria
    Save a query and use the saved query
    Create and use parameter queries
    Use compound criteria in queries
    Sort data in queries
    Join tables in queries
    Create a report and a form based on a query
    Export data from a query to another application
    Perform calculations and calculate statistics in queries
    Create crosstab queries
    Customize the Navigation Pane

  3. Maintain a database
    Assessment Strategies
    Through actual performance of the skill
    In submitted files as specified on the assignment sheet
    By specified assignment deadlines
    Criteria
    Add, change, and delete records
    Search for records
    Filter records
    Update a table design
    Use action queries to update records
    Specify validation rules, default values, and formats
    Create and use single-value lookup fields
    Create and use multivalued lookup fields
    Use delete queries to delete records
    Add new fields to an existing report
    Format a datasheet
    Specify referential integrity
    Use a Subdatasheet
    Sort records

  4. CREATE A DATABASE AND TABLES
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    by specified assignment deadlines
    Criteria
    1.1   Explore 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

  5. USE DESIGN VIEW, DATA VALIDATION, AND RELATIONSHIPS
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    by specified assignment deadlines
    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
    o   Property Update Options Smart Tag
    o   Switch between Datasheet and Design Views
    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   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 into a Table
    2.6 Design Relational Databases
    o   Study Relational Principles
    o   Outline 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   Identify a Foreign Key
    o   Create Relationships between Tables
    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 and Repair Database Utility

  6. CREATE AND USE QUERIES
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    by specified assignment deadlines
    Criteria
    3.1 Analyze 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 Operators
    o   Use Wildcards in Criteria including the ? Wildcard Character, the * Wildcard Character, and the # Wildcard Character
    3.4 Control the Display of Query Results
    o   Filter Data in a Query
    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

  7. CREATE AND USE FORMS AND REPORTS
    Assessment Strategies
    through actual performance of the skill
    in submitted files as specified
    by specified assignment deadlines
    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   Examine Form Control Layouts
    o   Add Fields to a Control Layout
    o   Delete Fields from a Control Layout
    o   Customize a Form in Layout View
    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   Adjust Control Positioning 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 Application 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   Examine Report Controls
    o   Investigate Report Control Layouts
    o   Add and Delete Fields in a Control Layout
    o   Customize a Report in Layout View
    o   Change Control Layouts
    o   Adjust Column Widths
    o   Add and Delete Rows and Columns in a Control Layout
    o   Move a Control within a Layout
    o   Adjust Control Positioning on a Report
    o   Add a Title, Logo, Date, or Page Numbers to a Report
    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   Group and Sort Options
    o   Add Totals to a Report
    4.7 Use Conditional Formatting in a Report
    o   Examine 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