MS Access 2007 Advance Pre Test

Explanation
Ms Access is indeed a software that is used to manage data and create databases. It falls under the category of Database Management System (DBMS) as it allows users to store, organize, and retrieve data in a structured manner. Therefore, the statement "Ms Access is a software to manage data to produce information which is called Database Management System or DBMS" is true.

Explanation
A table is indeed the central framework of a database that organizes and stores data in a structured manner. It consists of columns (fields) and rows (records) where each column represents a specific attribute or data type, and each row represents a unique set of values or data entries. This structure allows for efficient storage, retrieval, and manipulation of data in a database system. Therefore, the given answer "True" is correct.

Explanation
A query is a request for information from a database. It allows users to retrieve, manipulate, and analyze data stored in tables. By using queries, users can change, delete, add, and arrange data in tables according to their needs. Additionally, queries can be used to gather information for creating forms and reports. Therefore, the statement "Allows for table inquiries. A query can change, delete, add, arrange data in tables. Also aids gathering information for forms and reports" is true.

Explanation
The given statement is true. In Microsoft Access, there are indeed three types of relationships: one-to-many, many-to-many, and one-to-one. These relationships define how tables in a database are connected to each other. A one-to-many relationship means that one record in a table can be related to multiple records in another table. A many-to-many relationship means that multiple records in one table can be related to multiple records in another table. A one-to-one relationship means that one record in a table is related to only one record in another table.

Explanation
A primary key is a unique identifier for each record in a table. It ensures that no two records have the same value for the primary key attribute. This uniqueness prevents duplication of information and helps maintain data integrity within the table. Therefore, the statement that a primary key does not allow duplication of information is true.

Explanation
A form is indeed used to display and enter data in a fitted format. It provides a structured layout for users to input information and submit it. Forms are commonly used in various applications and websites to collect data from users in an organized manner.

Explanation
Assigning appropriate data types to a field is important because it determines the type of data that can be entered into that field. By specifying the data type, the system can validate the input and ensure that only the correct type of data is accepted. This helps to maintain data integrity and prevent errors or inconsistencies in the database.

Explanation
The statement is true because Microsoft Access provides three different ways to create a table: Design View, Datasheet View, and Table Wizard. In Design View, users can define the table's structure by specifying field names, data types, and other properties. Datasheet View allows users to enter data directly into the table, similar to a spreadsheet. Table Wizard is a step-by-step tool that guides users through the process of creating a table by selecting predefined options. Therefore, it is possible to create a table in Microsoft Access using any of these three methods.

Explanation
The statement is true because the text data type in many database systems can only store a maximum of 255 characters in one field. This means that any text entered into a field with the text data type cannot exceed this limit. If more characters need to be stored, a different data type, such as a memo or varchar, should be used.

Explanation
One way to identify inconsistencies between data in two or more tables is to modify the join line. By adjusting the join conditions or using different join types, it is possible to detect inconsistencies in the data. Another way is to use a special Query Wizard, which provides tools and features specifically designed to identify and resolve inconsistencies between tables. Both of these methods can help in comparing and analyzing data from multiple tables to identify any inconsistencies or discrepancies.

Explanation
A macro is a set of instructions or commands that can be executed by running the macro itself. This means that instead of manually carrying out each instruction individually, the macro allows for the automation of multiple instructions with just one command. Therefore, the statement that a macro holds a series of instructions that can be carried out simply by running the one macro is true.

Explanation
The given statement suggests that a special form called Switchboard can be set up in a way that allows anyone to use a database even if they have no knowledge of Access. This implies that the Switchboard form provides a user-friendly interface that simplifies the usage of the database, making it accessible to individuals who may not be familiar with Access. Therefore, the correct answer is true.

Explanation
Crosstab Queries are used to summarize data in tables by providing a way to pivot and aggregate data based on specific criteria. This allows users to analyze and present data in a more organized and concise manner. By using crosstab queries, users can easily calculate totals, averages, and other summary statistics for different categories or groups within a dataset. This feature is commonly used in database management systems and data analysis tools to generate reports and gain insights from large datasets.

Explanation
The given statement is true. There are three types of queries in databases: SELECT, ACTION, and CROSS TAB. SELECT queries are used to retrieve data from the database, ACTION queries are used to modify data in the database, and CROSS TAB queries are used to transform rows into columns for reporting purposes. Therefore, the statement is correct.

Explanation
The given statement is true. In Microsoft Access, Table, Query, Form, Report, Macro, and Module are the objects that can be used to organize and manipulate data. Tables store the actual data, queries retrieve and manipulate the data, forms provide a user-friendly interface to view and enter data, reports generate formatted and printable outputs, macros automate tasks, and modules contain programming code for advanced customization and functionality.

Explanation
The given statement is true. In Microsoft Access, Table, Query, Form, Report, Macro, and Module are all considered objects. These objects serve different purposes in Access. Tables store data, queries retrieve and manipulate data, forms provide a user-friendly interface for data entry and viewing, reports generate formatted and organized data for printing or viewing, macros automate tasks, and modules contain custom code for advanced functionality. Overall, these objects work together to create and manage a database in Microsoft Access.