MS Access - Final Exam 1

All of the above is the correct answer because Access supports multiple data types including Number, Text, and Currency. Number data type is used for storing numeric values, Text data type is used for storing alphanumeric values, and Currency data type is used for storing monetary values. Therefore, all three options are valid data types in Access.

SQL stands for Structured Query Language. It is a programming language used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases. It is widely used in the field of database management systems and is considered the standard language for interacting with databases.

The appropriate data type to store time in MS Access is Date/Time. This data type allows for the storage of both date and time values. It is commonly used when there is a need to store specific time information, such as recording the time of an event or tracking the duration of a task. The Date/Time data type in MS Access provides the necessary functionality to accurately store and manipulate time values.

A wizard is a tool or feature in software applications that guides users through a step-by-step process to complete a task. In the context of creating a table, a wizard would provide a series of prompts and options to help the user define the table structure, specify column names and data types, and set any necessary constraints or properties. By following the prompts and making selections, the user can easily create a table without needing to manually write the underlying code or query. Therefore, a wizard is the correct answer as it leads the user through the process of creating a table.

Currency is the better data type to use for storing the price of an item because it is specifically designed to handle monetary values. It provides built-in formatting and precision for currency calculations, ensuring accurate representation of prices with decimal places. Using the Currency data type also allows for easier integration with financial systems and simplifies calculations involving currency conversions or monetary operations.

The function MPT cannot be used for calculated controls in a report.

The "Hyperlink" data type in MS Access can store all of the above options, including web addresses, email addresses, and paths of files. This means that the Hyperlink data type is versatile and can be used to store different types of data related to links and addresses.

The OLE Object Data type in MS Access is capable of storing various types of data, including Microsoft Word documents, Microsoft Excel spreadsheets, and sounds. Therefore, the correct answer is "All of the Above" as it encompasses all the mentioned options.

An intersection of a row and a column refers to the point where a row and a column meet in a table or grid. This point represents a specific location within the table or grid, known as a cell. In this context, a cell is used to store and display data, making it the correct answer to the question.

The Simple query wizard is the tool used to create a query object. This wizard provides a user-friendly interface that allows users to easily define the criteria and parameters for their query. It simplifies the process of creating a query by guiding users through the necessary steps and providing options for selecting tables, fields, and conditions. By using the Simple query wizard, users can quickly and efficiently create a query object without needing to have in-depth knowledge of SQL or database management.

In MS Access, the Picture data type does not exist. The other three options (Memo, Currency, and AutoNumber) are valid data types in MS Access.

The given query will display all customers with CustID from 11 to 99. The query specifies a condition where the CustID should be greater than 10 and less than 100. Therefore, it will retrieve all customer records that have a CustID between 11 and 99, excluding 10 and 100.

The correct answer is 255 characters. In MS Access, the Text data type is limited to a maximum of 255 characters. This means that any text entered into a field with this data type cannot exceed 255 characters in length.

The "Lookup Wizard" in MS Access is used to select a value from another table. This feature allows users to create a lookup field in a table that retrieves data from a related table. It provides a convenient way to establish relationships between tables and ensure data integrity by only allowing values that exist in the related table to be selected.

The correct answer is OLE Object. In MS Access, the OLE Object data type is used to store pictures. OLE stands for Object Linking and Embedding, which allows users to create and manipulate objects from different applications. By using the OLE Object data type, users can insert and store pictures within an Access database, making it convenient to manage and retrieve images when needed. The Memo data type is used for storing large amounts of text, while the Picture data type does not exist in MS Access.

Setting the format property to "yyyy/mm/dd" allows the date field to store dates in the specified format of "2002/10/17". This means that when a date is entered into the field, it will be displayed and stored in the format of year/month/day. This ensures consistency and standardization in the way dates are entered and stored in the field. The input mask property, on the other hand, is used to control the input format while entering the date, but it does not affect the way the date is stored or displayed. Therefore, the correct answer is setting the format property to "yyyy/mm/dd".

Filtering is the process of restricting the display of records in a table to only those that meet a specific criterion. It involves selecting and displaying only the relevant data that matches the specified condition, while hiding or excluding the rest of the records. This is commonly used to narrow down a large dataset and focus on specific information that meets certain criteria or conditions.

Tables and Queries are used to create a form. Forms are used to input, edit, and view data in a database. Tables store the actual data, while queries are used to retrieve and manipulate the data. By using tables and queries, users can design a form that allows them to interact with the data in a structured and organized manner.

The correct order to sort the Dynaset first by zipcode, then by lastname, and finally by firstname is zipcode, lastname, firstname. This means that the records will be sorted based on their zipcode first, then within each zipcode, the records will be sorted based on their lastname, and finally within each lastname, the records will be sorted based on their firstname.

The criteria "address = 'K*'" will return only those addresses that begin with the letter "K". The asterisk (*) is a wildcard character that represents any number of characters, so when it is used after the letter "K", it will match any address that starts with "K" followed by any number of characters. Therefore, this criteria will only select addresses that begin with "K".

To print a report using letterhead, you must modify the margin setting. By adjusting the margins, you can ensure that the letterhead is properly aligned and positioned on the page when printing the report. This allows for a professional and polished appearance when printing reports with letterhead.

In a database, relations are established between tables through keys. The number of relations that may exist between tables depends on the number of keys present. Since a table can have multiple keys, there can be multiple relations between tables. Therefore, the correct answer is 3, indicating that there can be multiple relations between tables in a database.

The appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line indicates that referential integrity is enforced. This means that there is a relationship between the tables involved and certain rules are in place to maintain the consistency and validity of the data. These symbols represent the cardinality of the relationship, with 1 indicating a one-to-one relationship and the infinity symbol indicating a one-to-many relationship. By enforcing referential integrity, the database ensures that any changes made to the data in one table are consistent with the data in related tables.

A dynaset is a term used in database management systems to describe a collection of records that match the parameters of a query. It is a dynamic set of data that is generated based on the conditions specified in the query. Unlike a static set of records, a dynaset can be updated in real-time as new records that meet the query criteria are added or existing records are modified. Therefore, a dynaset is the correct term to refer to a collection of records matching the parameters of a query.

A select query is used to retrieve specific data from a database. In this case, the query would be used to select employees who earn more than $5000 a month. This query would involve specifying the necessary conditions and selecting the appropriate fields to display the desired information.

A select query is used to retrieve data from a database. In this case, the select query can be used to retrieve the salary data of all employees. By using the appropriate SQL syntax and functions, such as AVG(), the average salary of the employees can be calculated and returned as the result of the query.

The group header is not a legitimate section for form objects. In a form, the form detail section is used to display the main content of the form, the form header section is used to display information about the form, and the page footer section is used to display information at the bottom of each page. However, there is no specific section called the group header in a form.

This question is asking for personal preference. The correct answer is Option 1, indicating that the person likes Option 1 out of the given choices.

Indexing is used to speed up data search. When data is indexed, a separate data structure is created that allows for faster retrieval of specific data items. This is because the index provides a way to quickly locate the desired data without having to search through the entire table or database. By using indexing, the time taken to search for data is significantly reduced, improving the overall performance and efficiency of data retrieval operations.

The phone number format "977-1-1234567" includes both numbers and hyphens, which are not mathematical operations. Therefore, it is better to use the Text data type to store this phone number format, as it allows for the inclusion of non-numeric characters and preserves the specific format of the phone number.

The criteria "position = 'O??icer'" does not return the position "Officer" as a match because the question marks ('?') in the criteria represent wildcard characters that can match any single character. Therefore, the criteria "O??icer" would match any position that starts with 'O', followed by any two characters, and then followed by "icer". Since "Officer" does not have any two characters between 'O' and "icer", it does not match the criteria.

The expression [detail] ! [product] * 1.30 multiplies the contents of product in the detail table by 1.3.

A text box is used to create a calculated control. This is because a text box allows the user to enter and display text or numerical values. By using formulas or expressions, the text box can perform calculations and display the result as a calculated control. This makes it suitable for creating calculated controls in a user interface.

Datasheet view is a view commonly used in database applications to interact with tables or queries, where data is displayed in a spreadsheet-like format. It allows users to view and manipulate individual records and fields directly, but it is not typically used for interacting with form objects, which are designed for data entry, presentation, and interaction in a more structured manner.

The data type used to store logical values in MS Access is "Yes/No". This data type allows for the storage of boolean values, where "Yes" represents true and "No" represents false. It is commonly used for fields that require a binary choice, such as whether a certain condition is met or not.

Datasheet view is not a view for displaying a report object. Datasheet view is typically used for displaying and editing data in a tabular format, similar to a spreadsheet. It is commonly used in database applications for data entry and data manipulation. However, when it comes to displaying a report object, options like Design view, Print preview, and Layout preview are more suitable as they provide better control over the appearance and formatting of the report.

The correct answer is "Only A & B" because in MS Access, the AutoNumber data type can be set to generate sequential numbers or random numbers. It cannot be edited manually as it is automatically generated by the system. Therefore, options C and D are incorrect.

To delete a field in design view after right-clicking the field selector button, the correct option is "delete rows." This option allows you to remove the entire row associated with the selected field, effectively deleting the field from the design view. The other options listed, such as "delete field," "remove field," and "remove rows," do not accurately describe the action of deleting a field in design view.

A text box is most often associated with a bound control because it allows the user to input and edit text, which can be bound to a data source. This means that the data entered in the text box can be stored and retrieved from a database or other data storage system. Other controls like command buttons, labels, and list boxes do not typically have this capability to directly interact with data sources.

The correct answer is "Memo" because it is the appropriate data type in MS Access to store large text and numbers. The Memo data type can store up to 65,536 characters of text, making it suitable for storing large amounts of text data. Additionally, it can also store numbers, making it versatile for storing both text and numeric data.

The tool used to generate a printout of a table's structure is the Documenter. This tool allows users to create a detailed documentation of the table's structure, including information such as column names, data types, constraints, and relationships. It is commonly used in database management systems to provide a visual representation of the table's design, making it easier for users to understand and analyze the structure of the table.

In an application created using the database wizard, the main menu is presented as a form called a switchboard. A switchboard is a user interface element that allows users to navigate through different sections or functions of the application. It typically consists of buttons or links that represent different options or tasks. By presenting the main menu as a form, users can easily interact with the application and access the desired functionalities.

The sort order of a table is determined by the Index field. An index field is used to improve the performance and efficiency of searching, sorting, and filtering data in a database table. It stores a sorted copy of the table's data, allowing for faster retrieval and sorting based on the values in that field. By specifying an index field, the table's data can be organized and displayed in a specific order, such as ascending or descending.

The option to change one row's height is not available for customizing a datasheet window. This means that users cannot adjust the height of a single row in the datasheet window to make it larger or smaller. However, they can still customize the window by hiding a column, changing a column's width, or freezing a column.

Controls are the basic elements of a form or a report. They are used to collect and display data, and they provide functionality to interact with the user. Examples of controls include text boxes, buttons, checkboxes, and dropdown lists. These controls can be used to input data, perform calculations, and present information in a structured manner. Therefore, the correct answer is Controls.

The command "Unhide columns" is not selectable from the right-click menu of a field column. This command is used to reveal any hidden columns in a spreadsheet or table. The other options, "Hide columns", "Freeze columns", and "Sort descending", are commonly available commands that can be selected from the right-click menu of a field column.

The action queries in databases are used to modify or manipulate data, such as adding, deleting, or updating records. The "add" query is an action query as it is used to add new records to a table. Therefore, it is not the correct answer.

To display the table's primary key and indexes in a separate window, you need to click on the "indexes button". This button allows you to view and manage the indexes associated with the table, which are used to improve database performance and enforce data integrity. By clicking on this button, you can access a separate window that displays the primary key and other indexes defined for the table.

The report footer section is most useful for displaying subtotals. This section is typically used to display calculations or summaries of data that are relevant to the entire report, such as the total sales for a certain period or the average score of a group. By placing subtotals in the report footer, it allows the reader to easily see and understand the overall calculations or summaries of the data presented in the report.

In the datasheet formatting dialogue box, the option "datasheet border" is not available in the border and line styles dropdown list box. This means that users cannot select a specific border style for the entire datasheet.