Access Exam

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, and DOB fields from the Staff table. Select the option to open the query to view information. Name the query Birthdays and view the query results.

...] Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Staff drop-down, you selected Table: InsurancePlans, selected Table: InsuranceProviders, selected Table: Services, selected Table: Pay Schedules, selected Table: Work Logs, selected Table: WageIncreases, selected Table: Departments, selected Table: InsuranceProviders, selected Table: Pay Schedules, selected Query: Dental Insurance Options, selected Query: Medical Insurance Options, selected Query: Staff Insurance Elections, selected Query: Vision Insurance Options, clicked the Query: Staff Insurance Elections list item, clicked the Query: Vision Insurance Options list, clicked the Table: InsurancePlans list item, and selected Table: Staff. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, typed Birthdays in the What title do you want for your query? input, and clicked the Finish button.

what guidelines should you follow when designing a database?*

1. identify all the fields needed to produce the required info 2. organize each piece of data into its smallest useful part 3. group related fields into tables 4. determine each table's primary key 5. include a common field in related tables 6. avoid data redundancy 7. determine the properties of each field

The default field size property setting for a short text field is?

255 characters

data redundancy

A condition that occurs when you store the same data in more than one place; it wastes space and can cause inconsistencies.

Caption property

A field property that specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports.

keyboard shortcut

A key or combination of keys you press to access a feature or perform a command more efficiently.

Ctrl + '

A keyboard shortcut that lets you insert in the current field the value from the same field in the previous record.

composite key

A primary key that consists of two or more fields.

import

A process that allows you to copy the data from a source, without having to open the source file, and to add the imported data in an Access table.

orphaned record

A record whose matching record in either the primary or related table has been deleted.

delimited text file

A type of text file in which fields of data are separated by a character such as a comma or tab.

data type gallery

An Access tool that allows you to add a group of related fields to a table at the same time, rather than adding each field individually.

Cascade Update Related Fields option

An option you can set to enforce the referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key values in related tables.

Cascade Delete Related Records option

An option you can set to enforce the referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that have matching foreign key values.

What is the keyboard shortcut for inserting the value from the same field in the previous record into the current record?

CTRL'

properties

Characteristic of each field in a table.

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

Click the Classification field's criteria row, changed the Classification field's criteria to Sr, clicked the Credits field's criteria row, and changed the Credits field's criteria to >124. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Export the Tuition query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps.

Click the Tuition query, right-clicked the Tuition query. In the Right-Click menu in the Export Options menu, you clicked the Excel menu item. Inside the Export - Excel Spreadsheet dialog, you checked the Export with formatting and layout check box, clicked the OK button. Inside the Export - Excel Spreadsheet dialog, you clicked the Close button.

_______ a database rearranges the data and objects in a database to decrease its file size and enhance the speed and performance of the database

Compacting

A software program that lets you create databases and then manipulate data in them.

Database management system

The new blank table that access created is displayed in _________ ______.

Datasheet view

Compact and Repair tool

Eliminates these unnecessary database objects for optimum efficiency

From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).

In the Access Report, you resized the DeptName column to 224 px by dragging cell 0-0's right border.

Add a new record to the table with the staff ID 10-9999 and advance to the second field.

In the Access Table, you clicked in Cell 13 in the StaffID column, clicked the arrow at the top of the StaffID column. You clicked the Table Column Filter Right-Click menu. In the Access Table, you clicked in Cell 13 in the StaffID column, clicked the row selector, clicked the row selector, clicked in Cell 13 in the StaffID column, typed 10-9999, clicked in the 1 Cell, and typed 10-9999.

Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.

In the Access Table, you clicked in the 10/25/1998 Cell, clicked in the 10/25/1998 Cell, and clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or After "10/25/1998" menu item.

From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.

In the Access Table, you clicked in the Lookup Wizard Cell, clicked the Drop-Down Button, and clicked the Lookup Wizard Item. Inside the Lookup Wizard dialog, you selected the I will type in the values that I want Radio Button, clicked the Next button. Inside the Lookup Wizard dialog in the Access Table, you typed Male, typed Male and pressed Tab, and typed Female. Inside the Lookup Wizard dialog, you clicked the Next button, checked the Limit To List check box, and clicked the Finish button.

From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.

In the Access Table, you clicked in the Lookup Wizard Cell, clicked the Drop-Down Button, and clicked the Lookup Wizard Item. Inside the Lookup Wizard dialog, you selected the I will type in the values that I want Radio Button, clicked the Next button. Inside the Lookup Wizard dialog in the Access Table, you typed Male, typed Male and pressed Tab, and typed Female. Inside the Lookup Wizard dialog, you clicked the Next button, clicked the L W Logo4 item, checked the Limit To List check box, and clicked the Finish button.

Delete the Major field from the table.

In the Access Table, you clicked in the Major Cell, dragged the Major row. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Delete Rows button. Inside the Spa : Database dialog, you clicked the Yes button.

Set the Default Value property for the Classification field to Fr.

In the Access Table, you clicked on Classification. In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Default Value button. Inside the Expression Builder dialog, you typed Fr in the Expression Default Value Input input, clicked the Ok button.

Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.

In the Access Table, you clicked on CourseDescription, clicked the arrow at the top of the CourseDescription column, right-clicked the CourseDescription column header, and clicked the arrow at the top of the CourseDescription column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.

Modify the width of the CourseDescription column to best fit the data.

In the Access Table, you clicked on CourseDescription, right-clicked the CourseDescription column header. In the Right Click Menu menu, you clicked the Field Width menu item. Inside the Column Width dialog, you checked the Standard Width check box, unchecked the Standard Width check box, and clicked the Best Fit button

Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out.

In the Access Table, you clicked on DOB, clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A menu item. In the Access Table, you clicked the arrow at the top of the Classification column. In the Table Column Filter Right-Click menu, you clicked the Sort A to Z menu item.

Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.

In the Access Table, you clicked on Department, clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and clicked the OK button.

Change the Field Size property for the RAStudentID field to 4.

In the Access Table, you clicked on RAStudentID. In the Fields Ribbon Tab in the Properties Ribbon Group, you typed 4 in the Field Size input, pressed the Enter key. Inside the Spa : Database dialog, you clicked the Yes button

Move the Start Date field so it is the last field in the table.

In the Access Table, you clicked on StartDate, clicked the arrow at the top of the StartDate column, and dragged StartDate after LastName.

Modify the width of the Time column to exactly 22.

In the Access Table, you clicked on Time, right-clicked the Time column header. In the Right Click Menu menu, you clicked the Field Width menu item. Inside the Column Width dialog, you typed 22 in the Column width: input, clicked the OK button.

Modify the width of the Time column to exactly 22.

In the Access Table, you clicked on Time. In the Home Ribbon Tab in the Records Ribbon Group, you clicked the More button. In the More menu, you clicked the Field Width menu item. Inside the Column Width dialog, you typed 22 in the Column width: input, clicked the OK button.

From Design view, apply the Medium Time format to the StartTime field.

In the Access Table, you clicked the Format property box, clicked the Drop-Down Button, and clicked the Medium Time Item.

Apply the Short Date input mask format to the selected field (StartDate). Do not change default format or placeholder characters.

In the Access Table, you clicked the Format property box, clicked the Drop-Down Button, clicked the Short Date Item, clicked in the Date/Time Cell, clicked the Drop-Down Button, dragged the StartDate row, clicked the Format property box, clicked the Drop-Down Button, clicked the Long Time Item, clicked the Format property box, clicked the Drop-Down Button, clicked the Short Date Item, clicked the Input Mask property box, and clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Short Date. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish button.

Apply the Zip Code input mask format to the selected field (Zip/Postal Code). Do not change default format or placeholder characters. Store the data without the symbols.

In the Access Table, you clicked the Input Mask property box, clicked the Input Mask property box, and clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Zip Code. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.

Add a new Short Text field to the far right side of the table. Name the field: Description

In the Access Table, you clicked the arrow at the top of the Click To Add column. In the Drop-Down Menu menu, you clicked the Short Text menu item. In the Access Table, you typed Description and pressed Enter.

Clear the sorting from this table.

In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Clear Filter menu item.

Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.

In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Newest to Oldest menu item.

Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.

In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and clicked the OK button.

Delete the First Name field.

In the Access Table, you clicked the arrow at the top of the FirstName column, clicked on FirstName. In the Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes button.

Clear the filter from the StaffID field.

In the Access Table, you clicked the arrow at the top of the StaffID column. In the Table Column Filter Right-Click menu, you clicked the Clear Filter menu item.

Delete this student record.

In the Access Table, you clicked the row selector. In the Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes button.

Delete the Attachments field from the table.

In the Access Table, you right-clicked the Attachments cell. You right-clicked the undefined Object. In the Access Table, you clicked in the Attachments Cell, right-clicked the Attachments cell. You right-clicked the undefined Object. In the Right Click menu, you clicked the Delete Rows menu item. Inside the Spa : Database dialog, you clicked the Yes button.

Delete this student record.

In the Access Table, you right-clicked the Row Selector. In the Right-Click menu, you clicked the Delete Record menu item. Inside the Spa : Database dialog, you clicked the Yes button.

Insert a new Date/Time field named StartDate between the DegreeName and Status fields. Save the table when you are finished.

In the Access Table, you right-clicked the Status cell. In the Right Click menu, you clicked the Insert Rows menu item. In the Access Table, you typed StartDate, typed StartDate and pressed Tab, clicked the Drop-Down Button, clicked the Date/Time Item, typed Date/Time and pressed Enter, clicked in the StartDate Cell, clicked in the StartDate Cell, typed StartDate, typed StartDate and pressed Enter, typed Date/Time and pressed Enter, and typed and pressed Enter. You right-clicked the Degrees Tab Header. In the Right Click menu, you clicked the Save menu item.

Use the Form Wizard to create a new form. Include these fields in this order from the Departments table: DeptCode and DeptName fields and then add these fields from the Courses table: CourseNumber and CourseDescription. Organize the form by the Departments table with data from the Courses table as a datasheet subform. Accept the suggested names for the form and subform. Allow Access to open the form in Form view when you are finished.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form Wizard button. Inside the Form Wizard dialog in the Table: Courses drop-down, you selected Table: Departments. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog in the Table: Courses drop-down, you selected Table: Courses. Inside the Form Wizard dialog from the Available Fields list, you selected DeptCode. Inside the Form Wizard dialog, you clicked the > button. Inside the Form Wizard dialog from the Available Fields list, you selected Credits. Inside the Form Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.

Create a Single Record form from the Classes table.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form button.

Add a title to the form header and change the text to: Review Press Enter when you are finished. Do not switch views.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button. You clicked the form header, right-clicked the report area, clicked the form header, right-clicked the report area, clicked the form header, and right-clicked the report area. In the Format Ribbon Tab in the Control Formatting Ribbon Group, you clicked the Quick Styles button. In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Title button. You updated the header title to Review.

Create a new blank form that will open in Layout view.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Navigation button, clicked the Blank Form button.

Start a new query without using one of the query wizards.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button.

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Students. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Advisor. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected GPA. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, typed Tuition in the What title do you want for your query? input, and clicked the Finish button.

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Students. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected ResidenceHall. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the < button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Classification. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected GPA. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, typed Tuition in the What title do you want for your query? input, and clicked the Finish button.

Add a new table in Design view.

In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button.

Create a new table in Design view. Name the first field: RA ID Make the field data type: AutoNumber Add the description: Unique RA ID Set the field as the primary key. Save the table with the Name: Resident Advisors

In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design button. In the Access Table, you typed RA ID, typed RA ID and pressed Tab, clicked the Drop-Down Button, clicked the AutoNumber Item, clicked in the Unique RA ID Cell, clicked in the AutoNumber Cell, typed AutoNumber and pressed Tab, and dragged the RA ID row. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Primary Key button. You right-clicked the Table1 Tab Header. In the Right Click menu, you clicked the Save menu item. Inside the Save As dialog, you typed Resident Advisors in the Table Name: input, clicked the OK button.

Create a new table in Datasheet view. Save it with the name: insurance plans

In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. In the Access Table, you typed. You clicked the Table1 Tab Header. In the application header, you clicked the Save button. Inside the Save As dialog, you typed InsurancePlans in the Table Name: input clicked the OK button.

Run the Performance Analyzer on all database objects at once. Accept the recommendation and allow Access to make the change for you. When you are finished, close the Performance Analyzer.

In the Database Tools Ribbon Tab in the Analyze Ribbon Group, you clicked the Analyze Performance button. You clicked the All Object Types tab. Inside the Performance Analyzer dialog, you clicked the Select All button, clicked the OK button. Inside the Performance Analyzer dialog from the Queries list, you selected Table 'TuitionRates': Add an index to field(s) 'Department'. Inside the Performance Analyzer dialog, you clicked the Optimize button, clicked the Close button.

Modify the table relationships so that when a record is updated in the Department table, the related records in the Professor table will also be updated.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. Inside the Edit Relationships dialog, you clicked the dialog Close button. You clicked the relationships Database. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.

Create a new relationship between the EmployeeID field in the Professor table and the Advisor field in the Student table. Ensure that values in the Advisor field have a corresponding value in the EmployeeID field.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database, dragged the object onto the advisor in the student Database. Inside the Edit Relationships dialog, you checked the Enforce Referential Integrity check box, clicked the Create button.

Create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table. Enforce data integrity between the two tables.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database, dragged the object onto the reviewer in the reviews Database. Inside the Edit Relationships dialog, you checked the Enforce Referential Integrity check box, clicked the Create button.

Modify the table relationships so that when a record is deleted in the Department table, the related records in the Professor table will also be deleted.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Edit Relationships button. Inside the Edit Relationships dialog, you checked the Cascade Delete Related Records check box, clicked the OK button.

Modify the table relationships so that when a record is updated in the Departments table, the related records in the Staff table will also be updated.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the departments and staff tables. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.

Run the Compact & Repair tool to optimize database efficiency.

In the Database Tools Ribbon Tab in the Tools Ribbon Group, you clicked the Compact and Repair Database button.

Add automatic page numbers centered at the bottom of the page footer on every page. Use the format that includes the current page number and the total number of pages. Do not change views.

In the Design Ribbon Tab in the Controls Ribbon Group, you clicked the Insert Image button. In the Background Image menu, you clicked the Browse... menu item. Inside the Insert Picture dialog, you clicked the dialog Close button. In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Page Numbers button. Inside the Page Numbers dialog, you selected the Page N of M Radio Button, selected the Bottom of Page [Footer] Radio Button, and clicked the OK button.

From Layout view, group this report by values in the Classification field.

In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the Classification menu item.

Use the Field List pane to add the following fields to the report: From the Departments table, add the DeptName field. From the Faculty table, add the LastName and FirstName fields. Do not switch views.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Departments field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Departments list, you selected DeptName, clicked the DeptName list item. You clicked the undefined String. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Faculty field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Faculty list, you clicked the LastName list item. You clicked the undefined String. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Faculty list, you clicked the FirstName list item. You clicked the undefined String.

Use the Field List pane to add the DOB field to the form immediately to the right of the LastName controls. Do not switch views.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you clicked the DOB list item. You clicked the undefined view.

Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog, you clicked the Show all tables item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you selected Students, selected Students, and expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you selected LastName, selected LastName, and clicked the LastName list item. You clicked the undefined view.

Insert a new Short Text field named FirstName between the StartDate and LastName fields. Save the table when you are finished.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Insert Rows button. In the Access Table, you typed FirstName, typed FirstName and pressed Tab, clicked the Drop-Down Button, and clicked the Drop-Down Button. You right-clicked the InsurancePlans Tab Header. In the Right Click menu, you clicked the Save menu item.

Open the wizard that will analyze a table and move redundant data into new tables that are linked to a copy of the original table through lookups.

In the External Data Ribbon Tab in the Import & Link Ribbon Group, you clicked the Linked Table Manager button.

Import all of the fields from the Assets worksheet in the Accounting Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the AccountID field as the primary key. Accept the new table Assets. Do not save the import steps.

In the External Data Ribbon Tab in the Import & Link Ribbon Group, you clicked the New Data Source button. In the New Data Source menu in the From File menu, you clicked the Excel menu item. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Browse... button. You clicked Accounting.xlsx. Inside the File Open dialog, you clicked the Open button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the OK button. Inside the Import Spreadsheet Wizard dialog, you clicked the Next > button, checked the First Row Contains Column Headings check box, clicked the Next > button, clicked the Next > button, selected the Choose my own primary key. Radio Button, clicked the Next > button, and clicked the Finish button. Inside the Get External Data - Excel Spreadsheet dialog, you clicked the Close button.

Add the Status Quick Start fields to the right of the DegreeName field.

In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button, clicked the More Fields button. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.

Add the Status Quick Start fields to the right of the DegreeName field.

In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.

Rename the ID field to: DegreeName

In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Name & Caption button. Inside the Enter Field Properties dialog, you typed DegreeName in the Name: input, clicked the OK button.

Use the Find and Replace dialog to find the record with the text julie, matching the case exactly.

In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. Inside the Find and Replace dialog, you typed julie in the Find What input, checked the Match Case check box, and clicked the Find Next button.

Replace all instances of the first name julie with Julie. Be sure to match the case exactly.

In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Replace button. Inside the Find and Replace dialog, you typed julie in the Find What input, typed Julie in the Replace With input, checked the Match Case check box, and clicked the Replace All button. Inside the Appointments dialog, you clicked the Yes button.

Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4.

In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button, clicked the Advanced button. In the Access Table, you clicked the arrow at the top of the Credits column. In the Table Column Filter Right-Click menu, you clicked the 3 checkbox. In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Economics checkbox. In the Access Table, you clicked on Credits, clicked on Department, and clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Economics checkbox, and clicked the OK button. In the Access Table, you clicked the arrow at the top of the Credits column. In the Table Column Filter Right-Click menu, you clicked the 3 checkbox, clicked the OK button.

Use AutoFilter to filter the query results first to show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.

In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button, clicked the Selection button, clicked the Selection button, clicked the Advanced button, clicked the Advanced button, and clicked the Advanced button. In the Access Table, you clicked the arrow at the top of the StaffID column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Mo checkbox, and clicked the OK button. In the Access Table, you clicked the arrow at the top of the IncreaseType column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Merit checkbox, and clicked the OK button.

Switch to the view where you can modify the structure of the report without viewing any live data.

In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Design View menu item.

Switch to the view where you can modify the SQL code for the query.

In the application footer, you clicked the SQL View button.

The ______ is the area of the Access window that list all the objects in a database, and it is the main control center for opening and working with database objects

Navigation Pane

This database has been opened with exclusive access. Remove the password from the database. The password is warner.

Opened the backstage view, clicked the Decrypt Database button. Inside the Unset Database Password dialog, you typed warner in the Password: input, pressed the Enter key.

____ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database.

Referential integrity

In a __________ __________ _________ _________, data is organized as a collection of tables.

Relational database management system

Export the Housing query to a tab-delimited text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps.

Right-clicked the Housing query. In the Right-Click menu in the Export Options menu, you clicked the Text File menu item. Inside the Export - Text File dialog, you clicked the OK button. Inside the Export Text Wizard dialog, you clicked the Advanced... button, clicked the Next > button, selected the Tab Radio Button, checked the Include Field Names on First Row check box, and clicked the Finish button. Inside the Export - Text File dialog, you clicked the Close button. In the application header, you clicked the Save button.

For which three types of fields can you assign a field size?

Text, number, and AutoNumber fields

Replication ID

The Field Size property that establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions in 16 bytes.

double

The Field Size property that stores positive and negative numbers to precisely 15 decimal places in eight bytes.

decimal

The Field Size property that stores positive and negative numbers to precisely 28 decimal places in 12 bytes.

single

The Field Size property that stores positive and negative numbers to precisely seven decimal places in four bytes.

byte

The Field Size property that stores whole numbers from 0 to 255 in one byte.

Long Integer (default)

The Field Size property that stores whole numbers from −2,147,483,648 to 2,147,483,647 in four bytes.

integer

The Field Size property that stores whole numbers from −32,768 to 32,767 in two bytes.

Address Quick Start selection

The Quick Start Selection that adds a collection of fields related to an address to the table at one time.

entity integrity

The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table.

Quick Start selection

The name given to the group of fields you add to a table at the same time using the Data Type gallery.

Field Size property

The property that defines a field's maximum storage size for Short Text, Number, and AutoNumber fields.

Decimal Places property

The property that specifies the number of decimal places that are displayed to the right of the decimal point.

Default Value property

The property that specifies what value will appear, by default, for a field in each new record you add to a table.

null value

The value that results from not entering a value for a field; a null value is not permitted for a primary key.

join

To relate tables using a common field.

set

To select or enter a value for a property of a field.

propagate

Updating field property changes made in Table Design view to the corresponding property on forms and reports that include the modified field.

Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.

You changed the LastName field's criteria to A*. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is FR. Run the query

You clicked the Classification field's criteria row, changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is FR. Run the query.

You clicked the Classification field's criteria row, changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

You clicked the Classification field's criteria row, clicked the Classification field's criteria row, changed the Classification field's criteria to Sr, clicked the Credits field's criteria row, and changed the Credits field's criteria to >124. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to < 90, clicked the Classification field's criteria row, changed the Classification field's criteria to Jr, clicked the classification field's or row, changed the classification field's or row to Sr, clicked the credits field's or row, changed the credits field's or row to <90, clicked the Credits field's criteria row, and changed the Credits field's criteria to <90. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 AND, clicked the credits field's or row, and changed the credits field's or row to <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 And <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >=120. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

You clicked the Credits field's criteria row, clicked the Credits field's criteria row, and changed the Credits field's criteria to >120 And <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

You clicked the Credits field's criteria row, clicked the Credits field's criteria row, changed the Credits field's criteria to >124, clicked the Classification field's criteria row, and changed the Classification field's criteria to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.

You clicked the Credits field's sort row, expanded the Credits field's sort options list, and selected the Ascending option. In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Datasheet View menu item.

Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.

You clicked the Credits field's sort row, expanded the Credits field's sort options list, and selected the Descending option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Modify this query so the DeptCode field is hidden in the query results, and then run the query.

You clicked the DeptCode column's Show box. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.

You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN.

You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to [Enter Department Code]. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button. Inside the Enter Parameter Value dialog, you typed FIN in the Enter last name input, clicked the OK button.

Add a new calculated field named Tuition in the first empty column to the right of the Credits field. The new field should calculate the value in the Credits field multiplied by 150. Run the query to view the results.

You clicked the Drop-Down Menu, right-clicked the Drop-Down Menu. In the Right-Click menu, you clicked the Zoom... menu item. Inside the Zoom dialog, you typed Tuition:[Credits]*150 in the Zoom Value Input input, clicked the Query Zoom Ok Button button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Enable active content in this database.

You clicked the Enable Content button.

Modify this query to show only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query.

You clicked the InsuranceType field's criteria row, changed the InsuranceType field's criteria to Medical . In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Go to the last record.

You clicked the Last Record Button

Change the Navigation Pane grouping option to Object Type.

You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.

Change the Navigation Pane grouping option to Tables and Related Views.

You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Tables and Related Views menu item.

Limit the query results to records where the insurance Premium is greater than 250. Run the query to view the results.

You clicked the Premium field's criteria row, changed the Premium field's criteria to >250. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Open the Services table.

You clicked the Services table, double-clicked the Services table.

Open the Navigation Pane.

You clicked the Shutter Bar Open/Close button.

Insert a new row into the form layout above the TuitionPaid and GPA controls.

You clicked the TuitionPaid control. In the Arrange Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Select Row button, clicked the Insert Above button.

Add a new record to the table with the student ID 6412 and advance to the second field. 1/1

You clicked the undefined view. In the Access Table, you clicked in Cell 33 in the StudentID column, typed 4126, clicked in the 6 Cell, typed 6412, and typed 6412 and pressed Enter.

Run the Compact & Repair tool to optimize database efficiency by compacting unused space and deleting unnecessary temporary objects.

You opened the backstage view, clicked the Compact & Repair Database button.

Add a new Short Text field to the far right side of the table. Name the field: Description

You opened the backstage view, clicked the New navigation button, and clicked the back arrow button. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the Short Text button. In the Access Table, you typed Description and pressed Enter.

Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.

You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, and typed Students in the File Name box.

Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.

You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, typed Students in the File Name box, and clicked the Create button.

Preview how the results of this query will look when printed.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.

Preview how this report will look when printed.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.

Preview how the results of this query will look when printed when the page orientation is changed to landscape.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button

Preview how the results of this query will look when printed when the page orientation is changed to landscape.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button.

Create a backup of the database. You do not need to change the backup location.

You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Save button.

Create a new blank desktop database named Payroll.

You opened the backstage view, clicked the back arrow button, opened the backstage view, clicked the New navigation button, clicked the Blank desktop database template, typed Payroll in the File Name box, and clicked the Create button.

Database

a collection of data: allowed you to enter, store, organize, and retrieve large amounts of related data

expression

a formula; can reference fields, mathematical operators, and functions

relational database

a group of tables related to one another by common fields

one-to-many relationship

a main table that contains a primary key field that is included as a field (the foreign key) in the secondary table

reports depend on

a record source for their data; cannot enter new data into a report

parameter query

a type of select query that allows the user to provide the criteria

theme

a unified color and font scheme

when a lookup field in one tale reference values in a field in another table

access will automatically create a one-to-many relationship between the tables for you; you can also manually create a relationship between two tables.

default value property

adds a preset value to the field: can save time during data entry

navigation pane

all the database objects are organized in the left side of the screen

Forms

allow users to input data through a friendly interface

lookup field

allows the user to select data from a list or items.; one type of lookup list presents values from a field in another table or a query

calculated control

an unbound text box control that contains an expression (a formula)

page header/footer section

appear at the top and bottom of every printed page in the report

report header/footer section

appear only at the very beginning and the very end of the report

Message bar

at the top of the window, below the ribbon

________ a database is the process of making a copy of the database file to protect the database against loss or damage

backing up

filter

by applying this to a database object, you display a subset of records that meet the filter criteria

PDF (Portable Document Format)

can be read by anyone who had the Adobe Reader software installed

blank form

can start a new one directly in layout or design view

deleting records

cannot undo

The _____ property specifies how a field's name is displayed in database objects, including table and query datasheets, forms and reports?

caption property

split form

combines the convenience of a continuous Datasheet form with the usability of a single record form displaying one record at a time; both formats are displayed and work together in sync

You connect the records in two separate tables through a(n) _______ that appears in both tables

common fields

criteria

conditions that the record must meet in order to be included in the query results

primary key field

contains data unique to that record; often IDs; basis for relationships between tables

backing up database

creating a copy and preserve the data at a certain point

The _____ gallery allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.

data type

insert or delete characters in a field value

database editing mode

access selects an entire field value

database navigation mode

portrait

default page orientation; height of page is greater than width

A(n) ____ text file is one in which fields of data are separated by a character such as a comma or tab.

delimited

reports

display database information for printing or viewing on-screen; do not allow data entry; the are read-only

text box control

display text, numbers, dates, and similar data

multiple items form

displaying multiple records at one; more flexible than a datasheet form because you can modify the layout and design

calculated field

displays a value returned by an expression (formula)

select query

displays data from one or more related tables or queries, based on the fields that you select.

Field Properties Pane

displays detail about the selected field

single record form

displays one record at a time

Format Field Property

does not affect the data stored in the table; only controls the way the data are displayed to the end user

field

each column in the table that represents a specific data value

criterion

each field data type takes a certain type

Record

each row in the table that contains data

referential integrity

ensures that related database records remain accurate

queries

extract data from a table or related tables; can perform actions on tables such as updating values or deleting data

In Design view, which key do you press to move from the table design grid to the field properties pane?

f6

A(n)_____ is a single characteristic of a person,place,object event or idea.

field

The specific value, or content, of a field is called the what?

field value

input mask

forces users to enter data in a consistent format; only available from the design view field properties pane

The primary key, whose values uniquely identify each record in table is called a(n)______ when it is placed in a second table to form a relationship between two tables.

foreign key

The quickest way to create a form is to use the ________

form tool

subform

form within the form

form view

forms open which provides a user-friendly interface for entering data; if similar to a table, it will open ina special form datasheet view; cannot change the form layout or formatting from these view

In the Navigation pane, each database object has a unique _______ to its left that identifies the object's type.

icon

______ data is a process that allows you to copy the data from a source without having to open the source file.

importing

Change the Field Size property for the StaffID field to 7.

in the Access Table, you clicked on StaffID, right-clicked the StaffID column header, and clicked on StaffID. In the Fields Ribbon Tab in the Properties Ribbon Group, you typed 7 in the Field Size input, pressed the Enter key. Inside the Spa : Database dialog, you clicked the Yes button.

What is the purpose of the Data Type property for a field?

it determines what field values you can enter for the field and what other properties the field will have

what is the purpose of the data type property for a field? *

it determines what field values you can enter for the field and what other properties the field will have

look up field does not

need to reference data in another table or query, you can enter your own values to create a custom list; "i will type the values i want"

controls

needed when starting with a blank form

unbound control

not connected to field data directly

enable data integrity

only values from the lookup list are allowed in the field

grouping

organizes the report into sections (groups) by the value of a specific field; makes a long report much easier to follow; allows you to add group-specific headers/footers where you can calculate totals for each group

a field, or a collection of fields, whose values uniquely identify each record in a table. no two records can contain the same value for this field.

primary key

The _____ is the "one" table in one-to-many relationship, and the ___ is the "many" table in the relationship

primary table,related

Which view enables you to see the total number of pages in a report and navigate through the report page?

print preview

Relationship window

provides a visual representation of the relationships in your database

A(n) _________ is a question you ask about the data stored in a database

query

total row

quickly calculate an aggregate function such as the sum or average of all the values in a column

A set of field values

record

Access

relational database

datasheet form

reproduces the exact look and layout of the table datasheet as a form

control layout

restricts movement of controls to the layout rows and columns ensuring that controls align with one another

Rename the table IncomingFreshmenStudents to: NewStudents

right-clicked the IncomingFreshmanStudents table. In the Right-Click menu, you clicked the Rename menu item. You clicked the Tables navigation item, renamed the IncomingFreshmanStudents table to NewStudents

Queries in datasheet view

show the record that matches the query criteria; doesnt allow you to modify fields

report view

shows a static view of the report; cannot change the layout or formatting of the report in this view

print preview

shows how the report will look when printed

landscape

sideways on the page; meant for columns

Tables

stores all the database data; essential building blocks of the database; looks similar to a spreadsheet

Attachment Fields

stores files as attachments to records: can be pictures, word docs. any type of data file except program files or files greater than 256 MG

To Copy the records from a table in one database to another table in a different database, the two tables must have the same _______

structure

A collection of fields that describe a person, place, object, event, or idea

table

datasheet view

tables open where you can enter, sort, and filter data; can also add new fields and modify some field properties

A predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database.

template

bound control

text box control that displays data from a table or a query field; connected to the field

margins

the blank spaced at the top, bottom, left, and right of the printed page

form header/report header

the section directly above the detail section where the data are displayed

find unmatched query wizard

to create a query that shows records from one table that have no corresponding records in another table

only an interface to the

underlying table or query (record source)

expression builder

used to build a formula

design view

used to modify the structure of the database object; you see only the structural elements of the object, not the data

find duplicated

useful for finding records that may have been entered more than once

report wizard

walks you step by step through the process of creating a report; allows you to combine fields from more than one table or query and gives you more layout and design option than using the basic report button

form wizard

walks you through the steps of creating the form, including selecting fields and a layout.

Rich Text Format (RTF)

when exporting Access data to word

stacked layout

where an unbound text control, called a label control, displays the name of the field to the left of a bound text box control displaying the field data

query grid

where you specify which fields to include in the query

tabular layout

which the data are arranged similar to a table with the label controls at the top of each column

sort

you can control the order in which the records appear in a table, query, or form

What is the effect of deleting a field from a table structure?

you delete all the values for the field from the table