Software Solutions - Access 2003 Skill Assessment
Please provide the following Skill Assessment Report information:
Why do we ask for you email address? Because if you have problems with your password you won't be able to open the final skill assessment report, we need more than your Firstname and Lastname to give you your password and to differentiate you from others with the same Firstname and Lastname.
This is an open book assessment, i.e. you can jump to Access and find the answers to these questions, as you can in the exam, it is not all by memory!
Skill Set: Structuring Databases Skill Measurement: Create Access Databases Being able to create a new Microsoft Access database with or without using the Database Wizard is necessary for those users who must create the structure for a new database. A new, blank database allows you to fully customise the database by creating each table, query, form, report, and other Access objects from scratch. Being able to use the Database Wizard gives you the ability to create a new database on multiple subjects, complete with sample tables, queries, forms, reports, and other objects that you can use “as is” or modify to meet your information management needs.
1) If you were to use the Database Wizard to create a database which template is not available?
1. Asset Tracking 2. Bookings 3. Expenses 4. Resource Scheduling 5. Honestly don't know
2) What is the purpose of the AUTOEXEC macro:
1. To automatically execute a certain macro when the user clicks a button 2. To perform specified actions when the database is opened 3. To automatically execute the quitting of the database 4. Honestly don't know
3) Macro conditions allow macros to be run based on:
1. Choices in a list box 2. Choices in a combo box 3. Both 4. Honestly don't know
4) The AUTOKEYS MACRO is to:
1. Control what actions a key when pressed will do 2. Both 1 and 3 3. Automatically key in data for the user when a key is pressed 4. Honestly don't know
5) Customising the toolbar in an Access database requires the Visual Basic for Applications command:
1. DisplayToolbar 2. DoToolbar 3. ShowToolbar 4. Honestly don't know
Skill Measurement: Create and Modify Tables Microsoft Access includes a table wizard which simplifies the creation and design of tables in a database. The Table wizard includes a number of steps that enables the quick and easy creation of common business and personal type tables including Mailing Lists, Customers, Employees and Products.
6) When creating a table using the Table Wizard are you able to rename fields?
1. Yes 2. No 3. Honestly don't know
Skill Measurement: Define and Modify Field Types Using the Lookup Wizard, the database user can create a field that displays either of two kinds of lists to make data entry simpler. A Lookup list that displays values looked up from an existing table or query, or a value list that displays a fixed set of values that can be entered.
7) The Lookup Wizard is initiated in the design of a table by:
1. Changing the Field Data type to Lookup Wizard 2. Clicking Run in the menu then Lookup Wizard 3. Clicking the Fields Lookup Property 4. Honestly don't know
Skill Measurement: Modify Field Properties Each field has property settings that can be changed to alter the way the data looks and behaves. By default, a field in a query, form, report or page inherits all the properties that it has in the table. Field properties regulate the type of data, format and behaviour of data that can be entered into a specific field. For example, the Format property is used to control the way in which data is displayed. Field properties are therefore a set of characteristics that provide additional control over how a field works.
8) In the design of a form or a table what would you enter in the format property of a memo field to format to uppercase?
1. < 2. > 3. Uppercase 4. Honestly don't know
9) The maximum field size for a text field is:
1. 255 2. 500 3. 50 4. Honestly don't know
10) The purpose of the primary key field is to always:
1. Both 2 and 3 2. Enable a quick search and to always sort data by that field 3. Ensure unique data is entered in to the field 4. Honestly don't know
11) To allow two decimal places to be stored into a field do the following:
1. Format the field to two decimal places 2. Change the field size to a long integer 3. Change the field size to a byte 4. Change the field size to a single or a double 5. Honestly don't know
12) The Index property is set to quickly:
1. Duplicate Data 2. Search Data 3. Sort Data 4. Honestly don't know
Skill Measurement: Create and modify one-to-many Relationships One-to-many relationships relate tables so users can share data and reduce data redundancy. The ability to create one-to-many relationships is a fundamental Access skill.
13) When creating a one to many relationship it is important to?
1. Drag from the primary table to the related table 2. Drag from the related table to the primary table 3. Drag either direction 4. Honestly don't know
14) When faced with a Many to Many relationship you:
1. Create two one to many relationships between two tables 2. Create a third intermediate table 3. Both 4. Honestly don't know
Skill Measurement: Enforce Referential Integrity Enforcing referential integrity on a one-to-many relationship applies a set of rules to the relationship that helps prevent inappropriate records and values from being entered or created in the database.
15)The application of Enforced Referential Integrity is to:
1. Ensure data in the related table exists in the primary table 2. Both 1 and 3 3. Ensure data deleted from the primary table does not have matching data in the related table 4. Honestly don't know
16) The application of Cascade Delete is to:
1. Ensure related and primary records are deleted 2. Ensure primary records are deleted 3. Ensure related records are deleted 4. Honestly don't know
Skill Measurement: Create and modify queries Queries are used to find, view, and edit a subset of records and fields from one or more tables. Queries can also be used to sort information, create calculated fields, and summarise groups of data. In addition, queries are used to define the recordset for a form, report, or page object. The ability to create and modify select queries is an absolutely critical Access skill for users at all levels. There are several query wizards that help users build these objects including the Simple Query Wizard.
17) To find all records greater than and equal to 2 and less than and equal to 10 in a query the criteria would be:
1. >=2 and <=10 2. >&=2 and <&=10 3. >and=2 and <and=10 4. Honestly don't know
18) To find all records that end with R in a query the criteria would be:
1. *R* 2. *R 3. R* 4. Honestly don't know
19) In addition to the simple query wizard there are the following other query wizards:
1. Find Duplicates Query Wizard and Find Unmatched Query Wizard 2.Crosstab Query Wizard, Find Duplicates Query Wizard and Find Unmatched Query Wizard 3. Crosstab Query Wizard, Pivot Query Wizard, Find Duplicates Query Wizard and Find Unmatched Query Wizard 4. Honestly don't know
20) The purpose of a parameter query is to:
1. Run a query to control the parameters entered by the user 2. Run a query for a variety of input 3. Neither 4. Honestly don't know
21) When formatting a query calculation to currency; click:
1. Use the Properties 2.Currency icon 3. Type $#,##.00 after the calculation 4. Honestly don't know
22) A crosstab query is used to:
1. Cross reference tables 2. Cross off old data in a table for archiving purposes 3.Provide a pivot or summary snapshot of data in a matrix format 4. Honestly don't know
23) An action query can:
1. Update data in a table, delete data in a table, append data to a table 2. Update data in a table, make a table, delete data in a table, append data to a table 3. Update data in a table, append data to a table 4. Honestly don't know
24) To make a table include information from other tables and calculations you would:
1. Create a Select query 2. Create a Crosstab query 3. Create an Action query 4. Honestly don't know
Skill Measurement: Create forms Forms are the primary tool used to find, view, enter, and edit data. The ability to create and use forms is a fundamental Access skill.
25) When creating a form using the Form Wizard or the AutoForm it can be based on:
1. A Table 2. Both 1 and 3 3. A Query 4. Honestly don't know
26) To show matching data between a main form and a sub form they must have matching fields in which two properties:
1. Main form and sub form properties 2. Master and Child properties 3. Form and sub form properties 4. Honestly don't know
Skill Measurement: Add and modify form controls and properties Form properties determine all of the characteristics of the form object itself. They range from those that determine the data displayed on the form, such as, the Record Source property, to event-driven properties that run macros or VBA. As such, they cover a wide and important area of knowledge for the form designer.
27) If you put a label into a form page header it will show:
1. On Screen 2. Both 1 and 3 3. When Printed 4. Honestly don't know
28) Which DLOOKUP function in a form is correct:
1. =DLOOKUP("[CustomerName]","tblCustomer","[CustomerID]=Forms![Orders].[CustomerID]") 2. =DLOOKUP([CustomerName],tblCustomer,[CustomerID]=Forms![Orders].[CustomerID]) 3. =DLOOKUP([CustomerName],tblCustomer) 4. Honestly don't know
29) Which IF function in a form is correct:
1. =IF([AmountSpent]=0,[Discount]=0,[Discount]=10%) 2. =IF([AmountSpent]=0,0,0.10) 3. =IIF([AmountSpent]=0,0,0.10) 4. Honestly don't know
30) To indicate that a macro is to run when a field is changed use the event procedure:
1. OnChange 2. AfterUpdate 3. OnEnter 4. Honestly don't know
Skill Measurement: Create Reports The ability to create and format reports is a fundamental Access skill. Reports represent the primary way users share Access information with those not having electronic access to the database file. Formatting includes a variety of topics including colours, fonts, clip art, and special effects.
31) A report created using the Report Wizard can be based on:
1. A Form 2. Both 1 and 3 3. A Query 4. Honestly don't know
32) A Sub Report is:
1. A report embedded and linked into the design of another report 2. A report pasted into another report 3. A report that you can jump to from another report via a command button 4. Honestly don't know
Skill Measurement: Add and modify report control properties The ability to add calculated controls to reports gives the user the ability to group and summarise data in informative ways.
33) Which Average function in a report is correct:
1. =AVERAGE([Amount]) 2. =AVG([Amount]) 3. =AVERAGE("[Amount]") 4. Honestly don't know
34) If you add a calculated control such as SUM to the page footer, will it sum the values for that page?
1. No 2. Yes 3. Honestly don't know
Skill Measurement: Create a Data Access Page The ability to create a Data Access Page dynamically ties an Access database to a Web page. This powerful new feature was first introduced in Access 2000 and gives the user a way to make Access data electronically accessible to a much larger audience.
35) When creating a data access page with the Page Wizard you can...
1. Only apply sorting 2. Only apply grouping 3. Apply grouping and sorting 4. You can't apply either 5. Honestly don't know
Skill Set: Entering Data Skill Measurement: Enter, Edit and Delete Records The ability to enter, edit and delete records in an Access database is a fundamental skill.
36) The following icon is used in a query or table to:
1. Delete a record 2. Add a Record 3. Move to the Last Record 4. Honestly don't know
37) The following icon is used in a query or table to:
1. Delete a record 2. Move to the Last Record 3. Add a Record 4. Honestly don't know
38) To expand a sub datasheet to edit a record click:
1. The right arrow symbol(->) 2. The plus symbol (+) 3. Honestly don't know
Skill Measurement: Find and move among records Access contains navigation functions to move quickly around records in a table, query or form. This is especially useful in objects with large amounts of data. There are many ways to find or go to just the data needed, whether looking for a particular value, one record, or a group of records.
39) If you needed to go to record 137 directly using the navigation bar what would you do?
1. Press CTRL+G and type 137 and press ENTER 2. Click the Next record button on the navigation bar 135 times 3. Replace the record number showing in the navigation bar with 137 and press ENTER 4. In the menu click Edit>Go To>Record and type 137 5. Honestly don't know
Skill Measurement: Import Data to Access Importing data allows an Access user to quickly pull information stored in an external file, such as an Excel workbook or another Access database, into the current Access database.
40) When importing data from Excel into an Access database...
1. Access will assign a primary key 2. You can select which field is to be the primary key 3. Answers 1,2 and 4 are correct 4. You do not need to assign a primary key 5. Honestly don't know
Skill Set: Organizing Data Skill Measurement: Create and modify calculated fields and aggregate function The ability to add calculated fields via a query is an important skill. Calculated fields are created by building expressions that use data from existing fields. Knowing how to create calculated fields gives the user the ability to combine and manipulate data in very powerful and efficient ways.
41) To calculate the GST at 12.5% of Cost in a query which formula is correct:
1. GST:[Cost]*12.5% 2. GST:[Cost]*0.125 3. GST=[Cost]*12.5% 4. Honestly don't know
42) The Totals icon in a query will not allow which function:
1. Average 2. Sum 3. IIF 4. Honestly don't know
Skill Measurement: Modify form layout 43) To quickly align fields in a form or a report go to which option in the menu:
1. Fields 2. Format 3. Align 4. Honestly don't know
44) If you put a control into a form footer it will show:
1. On Screen 2. When Printed 3. Both 4. Honestly don't know
Skill Measurement: Modify report layout and page setup The ability to preview and print a report, as well as print selected pages within a report, is a fundamental Access skill used to share information with those who do not have electronic access to the database file.
45) Is it possible to print the data only from a report and not the report layout?
46) When printing a report can you print a report in two columns?
Skill Measurement: Format Datasheets The ability to format datasheets helps users change the appearance of the datasheet to suit individual tastes. Formatting embellishments range from font, font size, and font attribute (bold, italics, underline) changes to colour (font, cell, borders) and special effects (sunken, raised). Formatting also includes such items as hiding, freezing, and renaming columns, as well as resizing columns and rows.
47) When formatting a datasheet which of the following can be done?
1. Modifying the datasheet gridline colour to Violet 2. Formatting a single column to Bold 3. Formatting a single column to the Background colour Blue 4. Honestly don't know
Skill Measurement: Sort Records The ability to sort records in ascending or descending order using either a datasheet or form is a common database activity.
48) It is possible to sort a table by what number of columns?
1. One 2. Three 3. Up to 255 columns 4. Honestly don't know
Skill Measurement: Filter Records The ability to filter records using the Filter By Form or Filter By Selection criteria helps users find and print specific subsets of data quickly and easily.
49) The Filter by Form works only in?
1. A Table only 2. A Form and a table 3. A Form only 4. Honestly don't know
50) To click in a field and filter all matching records click?
1. Filter by Form 2. Filter by Selection 3. Either 4. Honestly don't know
Skill Set: Managing Databases Skill Measurement: Identify object dependencies
51) To find what forms depend on a specific query, open the query and then from the menu select:
1. View>Object Dependences 2. Database>Object Dependencies 3. View>Form Dependencies 4. This is not possible in Access 5. Honestly don't know
Skill Measurement: View objects and object data in other views The ability to open database objects in multiple views is a fundamental Access skill. For example opening an object allows users to view, enter, and edit data. The Design View of an object allows users to modify the structure of the object. The PivotTable and PivotChart views allow users to summarise and graphically analyse data.
52) Which statement is correct?
1. Form views include Form View, Datasheet View, Design View, PivotTable View and PivotChart View 2. Form views include Datasheet View, Design View, PivotTable View and PivotChart View 3. Form views include Form View, Datasheet View and Design View 4. Honestly don't know
Skill Measurement: Export Data from Access The ability to export data from Access to other file formats such as HTML or as an Excel workbook enhances the user’s ability to share Access data in new ways.
53) Which statement is correct?
1. Only a table can be exported as HTML 2. Only a query can be exported as HTML 3. Only a macro can be exported as HTML 4. A query or a table can be exported as HTML
Skill Measurement: Backup database Microsoft Access 2003 offers a new backup feature.
54) The backup command can be found in what menu?
1. Tools in the menu 2. Database in the menu 3. File in the menu 4. Honestly don't know
Skill Measurement: Compact and repair database Microsoft Access databases can become "bloated" as records are deleted, added and edited, it is therefore necessary to regularly compact and repair a database, this can be set permanently under Tools>Options in the menu, or done as required.
55) To compact a database you would go to:
