Database Design Applications

Subtopics

1.        Explain the principles of data analysis.

2.        Evaluate and compare a variety of database programs for features and functions.

3.        Determine when it is appropriate to use a database and identify the benefits derived.

4.        Demonstrate correct use of database terminology.

5.        Plan, design, and create a database file.

6.        Construct database using appropriate inputting, formatting, and editing skills.

7.        Set and modify field properties including limit field size, number formats, date/time formats, yes/no formats, validation rules, and input masks.

8.        Distinguish between different field types.

9.        Define and modify field names and data types.

10.     Manipulate a database.

11.     Import and export data into and from a database.

12.     Save database objects as file types.

13.     Use the Help feature of database software.

14.     Compact and repair a database.

15.     Produce documents integrating word processing, database, spreadsheet, and presentation files.

1.        Use the simple query wizard.

2.        Create a query in design view.

3.        Search, sort, index, merge, and manipulate database for specific information.

4.        Filter data (sort, find specific records, and replace).

5.        Create multi-table queries.

6.        Design and create action queries (make-table, update, append, and delete).

7.        Design and create advanced queries (setting top values, creating calculated field, creating function query, and creating parameter query).

8.        Verify accuracy of output.

1.        Define and create table relationships.

2.        Use table wizard and design view to create a table.

3.        Add records to tables.

4.        Apply the default values, input masks, validation rules, validation text, required fields, and lookup fields to field properties in a table in design view.

5.        Understand the difference between a one-to-one, one-to-many, and many-to-many relationships.

6.        Enforce referential integrity.

7.        Create and modify a multi-table select inquiry.

8.        Save a table, query, and forms as a Web page.

9.        Import/export linked tables.

1.        Design, create, save, and modify reports for data output.

2.        Create a report with the Report Wizard.

3.        Enhance reports using formatting features and graphics.

4.        Preview and print a report.

5.        Modify and format report properties (font, style font size, color, and caption).

6.        Use report sections.

7.        Perform grouping and sorting to a report.

8.        Create reports using all types of controls including Active X and calculated totals.

9.        Use advanced report design to create a running summary, insert a date/time control, and use label wizard.

1.        Design, create, and modify basic forms in database.

2.        Create a form with the form wizard.

3.        Create a form based on a query.

4.        Modify Format Properties.

5.        Enter and delete records using a datasheet or form.

6.        Use the control Toolbox to add controls, move a control, and resize a control.

7.        View and print records in a form.

8.        Use design view to disable the snap to grid feature, display the field list, move, move part of a paired control, align and space controls, add a label or image, and to edit an unbound control.

9.        Create and modify a subform.