| |
DOMANDE IN-ATES [?] |
QUIZ DOMANDE [?] |
DOMANDE IN TOTALE |
| |
192 |
61 |
253 |
| 1. Understanding Databases
|
0 |
47 |
47 |
| SEZIONE 1
1.1 Key Concepts
DOMANDA DI CAMPIONE
|
0
|
19
|
19
|
1.1.1. Understand what a database is. |
0 |
4 |
4 |
1.1.2. Understand that information is the processed output of data. |
0 |
4 |
4 |
1.1.3. Understand how a database is organized in terms of tables, records and fields. |
0 |
4 |
4 |
1.1.4. Understand that all database data is stored in tables. Understand that changes are automatically saved. |
0 |
2 |
2 |
1.1.5. Know some of the common uses of large-scale databases like: airline booking systems, government records, bank account records, hospital patient details. |
0 |
5 |
5 |
| SEZIONE 2
1.2. Database Organization
DOMANDA DI CAMPIONE
|
0
|
20
|
20
|
1.2.1. Understand that each table in a database should contain data related to a single subject type. |
0 |
4 |
4 |
1.2.2. Understand that each record in a database should contain data related to a single subject. |
0 |
1 |
1 |
1.2.3. Understand that each field in a table should contain only one element of data. |
0 |
1 |
1 |
1.2.4. Understand that field content is associated with an appropriate data type like: text, number, date/time, yes/no. |
0 |
2 |
2 |
1.2.5. Understand that fields have associated field properties like: field size, format, default value. |
0 |
1 |
1 |
1.2.6. Understand what a primary key is. |
0 |
4 |
4 |
1.2.7. Understand that the main purpose of an index is to speed up search queries. |
0 |
7 |
7 |
| SEZIONE 3
1.3 Relationships
DOMANDA DI CAMPIONE
|
0
|
8
|
8
|
1.3.1. Understand that the main purpose of relating tables in a database is to minimize duplication of data. |
0 |
5 |
5 |
1.3.2. Understand that a relationship is built by matching a unique field in one table with a field in another table. |
0 |
1 |
1 |
1.3.3. Understand the importance of maintaining the integrity of relationships between tables. |
0 |
2 |
2 |
| 2. Using the Application
|
37 |
1 |
38 |
| SEZIONE 1
2.1. Working with Databases
DOMANDA DI CAMPIONE
|
11
|
1
|
12
|
2.1.1. Open, close a database application. |
2 |
0 |
2 |
2.1.2. Open, close a database. |
2 |
0 |
2 |
2.1.3. Create a new database and save to a location on a drive. |
2 |
0 |
2 |
2.1.4. Display, hide built-in toolbars. Restore, minimize the ribbon. |
4 |
0 |
4 |
2.1.5. Use available Help resources. |
1 |
1 |
2 |
| SEZIONE 2
2.2. Common Tasks
DOMANDA DI CAMPIONE
|
26
|
0
|
26
|
2.2.1. Open, save and close a table, query, form, report. |
1 |
0 |
1 |
2.2.2. Switch between view modes in a table, query, form, report. |
5 |
0 |
5 |
2.2.3. Delete a table, query, form, report. |
4 |
0 |
4 |
2.2.4. Navigate between records in a table, query, form. Navigate between pages in a report. |
12 |
0 |
12 |
2.2.5. Sort records in a table, form, query output in ascending, descending numeric, alphabetic order. |
4 |
0 |
4 |
| 3. Tables
|
63 |
3 |
66 |
| SEZIONE 1
3.1. Records
DOMANDA DI CAMPIONE
|
6
|
0
|
6
|
3.1.1. Add, delete records in a table. |
2 |
0 |
2 |
3.1.2. Add, modify, delete data in a record. |
4 |
0 |
4 |
| SEZIONE 2
3.2. Design
DOMANDA DI CAMPIONE
|
42
|
3
|
45
|
3.2.1. Create and name a table and specify fields with their data types like: text, number, date/time, yes/no. |
4 |
0 |
4 |
3.2.2. Apply field property settings: field size, number format, date/time format, default value. |
7 |
1 |
8 |
3.2.3. Understand consequences of changing data types, field properties in a table. |
5 |
2 |
7 |
3.2.4. Create a simple validation rule for numbers. |
7 |
0 |
7 |
3.2.5. Set a field as a primary key. |
4 |
0 |
4 |
3.2.6. Index a field (with, without duplicates allowed). |
5 |
0 |
5 |
3.2.7. Add a field to an existing table. |
7 |
0 |
7 |
3.2.8. Change width of columns in a table. |
3 |
0 |
3 |
| SEZIONE 3
3.3. Relationships
DOMANDA DI CAMPIONE
|
15
|
0
|
15
|
3.3.1. Create a one-to-many relationship between tables. |
4 |
0 |
4 |
3.3.2. Delete a one-to-many relationship between tables. |
2 |
0 |
2 |
3.3.3. Apply referential integrity between tables. |
9 |
0 |
9 |
| 4. Retrieving Information
|
39 |
1 |
40 |
| SEZIONE 1
4.1. Main Operations
DOMANDA DI CAMPIONE
|
17
|
0
|
17
|
4.1.1. Use the search command for a specific word, number, date in a field. |
4 |
0 |
4 |
4.1.2. Apply a filter to a table, form. |
10 |
0 |
10 |
4.1.3. Remove the application of a filter from a table, form. |
3 |
0 |
3 |
| SEZIONE 2
4.2. Queries
DOMANDA DI CAMPIONE
|
22
|
1
|
23
|
4.2.1. Understand that a query is used to extract and analyse data. |
0 |
1 |
1 |
4.2.2. Create a named single table query using specific search criteria. |
2 |
0 |
2 |
4.2.3. Create a named two-table query using specific search criteria. |
2 |
0 |
2 |
4.2.4. Add criteria to a query using one or more of the following operators: = (Equal), <> (Not equal to), < (Less than), <= (Less than or equal to), > (Greater than), >= (Greater than or equal to). |
5 |
0 |
5 |
4.2.5. Add criteria to a query to sort records in ascending, descending numeric, alphabetic order. |
1 |
0 |
1 |
4.2.6. Add criteria to a query using one or more of the following logical operators: AND, OR, NOT. |
1 |
0 |
1 |
4.2.7. Use a wildcard in a query, * or %, ? or _. |
4 |
0 |
4 |
4.2.8. Edit a query: modify, remove criteria. |
3 |
0 |
3 |
4.2.9. Edit a query: add, remove, move, hide, unhide fields. |
2 |
0 |
2 |
4.2.10. Run a query. |
2 |
0 |
2 |
| 5. Forms
|
10 |
1 |
11 |
| SEZIONE 1
5.1. Using Forms
DOMANDA DI CAMPIONE
|
10
|
1
|
11
|
5.1.1. Understand that a form is used to display,add and edit records. |
0 |
1 |
1 |
5.1.2. Create and name a simple form. |
3 |
0 |
3 |
5.1.3. Use a form to insert new records. |
1 |
0 |
1 |
5.1.4. Use a form to delete records. |
1 |
0 |
1 |
5.1.5. Use a form to add, modify, delete data in a record. |
2 |
0 |
2 |
5.1.6. Add, modify text in headers, footers in a form. |
3 |
0 |
3 |
| 6. Outputs
|
43 |
8 |
51 |
| SEZIONE 1
6.1. Reports, Data Export
DOMANDA DI CAMPIONE
|
28
|
5
|
33
|
6.1.1. Understand that a report is used to present selected information from a table or query. |
0 |
5 |
5 |
6.1.2. Create and name a simple report based on a table, query. |
2 |
0 |
2 |
6.1.3. Create and name a grouped report. Sort records and calculate summary information like: sum, minimum, maximum, average. |
4 |
0 |
4 |
6.1.4. Edit a report: change arrangement of data fields, headings. |
4 |
0 |
4 |
6.1.5. Edit a report: add, modify text in headers, footers. |
3 |
0 |
3 |
6.1.6. Export a table, query output in spreadsheet, text (.txt, .csv), XML format to a location on a drive. |
14 |
0 |
14 |
6.1.7. Export a report output in pdf format to a location on a drive. |
1 |
0 |
1 |
| SEZIONE 2
6.2. Printing
DOMANDA DI CAMPIONE
|
15
|
3
|
18
|
6.2.1. Change table, form, query output, report orientation: portrait, landscape. Change paper size. |
3 |
0 |
3 |
6.2.2. Print a page, selected record(s), complete table. |
4 |
0 |
4 |
6.2.3. Print all records using form layout, specific pages using form layout. |
2 |
1 |
3 |
6.2.4. Print the result of a query. |
2 |
0 |
2 |
6.2.5. Print specific page(s) in a report, print complete report. |
5 |
2 |
7 |