TDW 3080 - Computer Essentials 3

Students will be able to demonstrate knowledge of:

1. Microsoft Access

   1. Introduction to Access

      1. Relational database concepts

      2. Use of a database

      3. Relationship from database to a spreadsheet

   2. Describe how to use Queries

      1. Query Wizard

      2. Data within a query

      3. Query design view

      4. Sort, find and filter data

      5. Apply AND and OR criteria

   3.   Describe how to use Forms

      1. Format datasheet

      2. Create a split form

      3. Use form layout view

      4. Add field to forms

      5. Create calculations

   4. Describe how to use Reports

      1. Insert an image

      2. Use report wizard

      3. Use report Layout view

      4. Group and sort orders

      5. Add subtotals and counts

      6. Resize, align and format reports

   5.  Describe how to modify Databases

      1. Examine relational databases

      2. Design related tables

      3. Create one-to-many relationships

      4. Modify number and currency fields

      5. Modify date/ time fields and validation properties

      6. Create attachment fields

   6. Describe how to improve Queries

      1. Create multi table queries

      2. Apply sorts and view SQL

      3. Develop AND and OR criteria

      4. Create calculated fields

      5. Build summary and crosstab queries

      6. Create a report on a query

   7. Describe how to import and Export Data

      1. Import and export data from Excel

      2. Link data

      3. Publish and merge from Word

      4. Export data PDF

      5. Create objects using database templates

   8. Describe how to use advanced Queries

      1. Query for top values

      2. Create a parameter query

      3. Modify query properties

      4. Create a Make Table and an Append query

      5. Create a Delete and an Update query

      6. Find unmatched records

   9. Describe how to advance Reports

      1. Apply advanced formatting

      2. Set Control layout and advance print layout

      3. Create multicolumn reports

      4. Use domain functions

      5. Create and modify charts

   10. Describe how to create Macros

       1. Understand and create macros
       2. Modify actions and arguments
       3. Assign a macro to a command button
       4. Use If statements and work with events
       5. Create a data and troubleshoot macros
   11. Describe how to create Modules and VBA
       1. Understand modules and VBA

       2. Compare macros and modules

       3. Create functions and use If statements

       4. Build class modules

       5. Modify sub procedures
       6. Troubleshoot modules

   12. Describe how to administer the Database

       1. Create a navigation form
       2. Compact and repair a database
       3. Change startup options
       4. Set a database password
       5. Backup, convert and split a database
   13. Describe how to access the Web
       1. Create a hyperlink field and hyperlink control
       2. Use HTML tags to format text
       3. Export and Import to HTML and XML
       4. Save and share a database with OneDrive
       5. Understand and create an Access web apps
   14. Describe how to database Application
       1. Normalize data and analyze relationship
       2. Evaluate and improve tables and fields
       3. Use subqueries
       4. Modify joins
       5. Create a switchboard form
       6. Pass criteria to a report from a form