|
|
|
- Understand the general concepts of data management
- Explain basic database terminology
- Compare and contrast the file management and database management approaches
- Describe the advantages and disadvantages of database processing
- Describe the relational model
- Explain the difference between primary and foreign keys
- Draw a table-relationship diagram for a database
- Create a table in Access 2000
- Add, modify, and delete records in an Access table
- Use relational algebra to process queries
- Use QBE to retrieve data from Access tables
- Use conditions, calculated fields, and built-in functions in QBE
- Join tables in QBE
|
- Create a form using Form Wizard
- Create a main form with a subform
- Create a report using the Report Wizard
- Preview and print a report
- Define multiple criteria in a query
- Use AND and OR operators in a query
- Create a parameter query
- Create a custom form
- Create a multi-page form
- Create a custom report
- Modify report controls
- Add group and overall totals to a report
|
- Create a table using SQL
- Choose appropriate data types for SQL tables
- Understand the meaning and use of nulls
- Insert data into a table
- Understand the format of SQL SELECT command
- List the sequence of execution of the SELECT command clauses
- Rename columns on output
- Use simple conditions
- Retrieve unique rows with DISTINCT
- Use compound conditions
- Use computed columns
- Use LIKE, IN, BETWEEN
- Sort data using ORDER BY
- Sort with multiple keys and in descending order
- Use the SUM, COUNT, MAX, MIN and AVG aggregate functions
- Group data using GROUP BY clause
- Select specific groups using HAVING
- Test for nulls
- Join tables
- Use a subquery
- Use IN and EXISTS with a subquery
- Nest a subquery within a subquery
- Use a table alias
- Perform union, intersection and difference set operations
- Use ALL and ANY
- Use concatenation in a query
- Create a query for a report
- Change column headings and formats in a report
- Add a title to a report
- Group data in a report
- Include totals and subtotals in a report
- Send a report to a file that can be printed
|
- Elicit user information needs using an object-oriented approach (using CRC cards)
- Represent user information needs in an object-relationship diagram
- Transform an object-relationship diagram into a relational database
- Explain functional dependency
- Define first normal form (1NF), second normal form (2NF) and third normal form (3NF)
- Determine what normal form a table is in
- Transform a table into 3NF
|
- Export an Access table to an HTML document
- Create a data access page for an Access table
- Update a data access page using a Web browser
- Add hyperlink fields to an Access table
|
|
