Play as Quiz Flashcard. Questions and Answers. A field is a column in a table. A field represents a defined property that is stored for all records in a table. It contains organized details about a person, a location, or some other real-world entity. Which of the following terms is NOT a data type determines they type of data a field can store :. It presents the data from a query in a pre-formatted and useful manner.
A database object that lets you automate tasks in an Access database. It provides a link between the DBMS and the physical data on the hard disk. This view allows the you to see the underlying data for a database object in a tabular view. Microsoft Access allows you to share your database with other users via the web. This means that they don't need to have Access installed on their computers to be able to use the database. If you understand the basic features for other Microsoft applications, like Word and Excel, you are already familiar with many features in Access.
A macro allows you to enter information about a specific record that can be hidden from other users. You run a small advertising business. In at least 5 complete sentences, explain how you would design and implement your database. Be specific: What information would you need to include in each record?
What types of forms would you create? What patterns would you look for in customer information? How would entering this information into a database help your business? Related Topics. More Microsoft Access Quizzes.
Microsoft Access is a tool that helps one store and analyzes large amounts of information. This tool forms interface that allows users to enter information in a graphical form and have that information transparently passed to the Questions: 10 Attempts: Last updated: Nov 16, Sunday, 2 August Admin Which of the following rules apply when you use referential integrity?
You cannot delete a record from the primary table if matching records exist in the related table. You cannot enter a value in the foreign key field of the related table that does not exist in the primary key of the primary table. You can change the primary key value in the primary table, if that record has related records in the related tables.
All of the above. What will be the result of the following? InStr 1, "John Smith", "S". Which of the following functions determines if a phrase exists in a longer string? Password protected databases offer:. Only one password with full rights.
Integrated security with Active Directory. Integrated security with Windows Logins. This question is based upon the figure shown below. It prevents restricted e-mail content from being copied by using the Print Screen feature in Microsoft Windows. It restricts the e-mail content from being copied by using third-party screen-capture programs. It prevents an unauthorized recipient from accessing e-mail content, including attachments. It restricts content wherever the e-mail is sent.
What is the advantage of a Class Module versus a Standard Module? Encapsulation, Inheritance. Data Abstraction. What is the purpose of Option Explicit? It is a database object. Requires variable declarations. It contains all of the data access pages that are currently open in a Microsoft Access project.
It contains all open standard modules and class modules in a Microsoft Access database. When you run the Compatibility Checker in Microsoft Access , in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?
Name of an order by element is not valid. Name of source table is not valid. Sort order is set to an option other than ascending or descending. The expression is not valid. Which of the following is not done when you compact a database? Table records and objects are restructured and then stored in successive memory blocks.
Databases linked to the compacted database are compacted and repaired. Table records are restored into their primary key order, if a primary key exists in the table. The physical size of the database is reduced by making an exact duplicate of the database. How do you create a report for a Crosstab Query if certain column values are missing? Set the Value field in the Crosstab. Set the Column Heading field in the Crosstab.
Set the Pivot list in the Crosstab. Set the report's Crosstab property to True. The name of the index. The ON argument. The list of fields to be included in the index. The name of the table that contains the fields that you want to index.
Using which of the following Microsoft Access database file formats, can we use the Package and Sign tool? Which of the following conditions should be satisfied to create a one-to-one relationship between tables? The primary key and foreign key fields must have a unique index.
The indexed property for the primary key and the foreign key fields should be set to Yes. The common fields must have a unique index. Open Exclusive. Open Exclusive Read-Only. Open Read-Only. Open Password-Enabled. Which of the following is incorrect about the Quick Access Toolbar? You can move the Quick Access Toolbar from its default location. Toolbar can be minimized or collapsed.
You cannot display the Quick Access Toolbar on multiple lines. You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.
You can Filter, Copy, Search, etc. You can make most, but not all, changes to your report. You can display the structure of your report. Resize report sections, such as Headers, Detail, and Footers. Which of the following is not a Relationship and Lookup error? Lookups require an associated Relationship to be compatible with the Web.
A table with more than fields is incompatible with the Web. What happens when a user has a database open in Exclusive mode and another user attempts to open it? The second user can open the database and make changes to objects and data. The second user receives a 'File already in use' message. The second user receives a 'File is deleted' message. The second user can open the database and make changes to data, but not to objects. You can append data to an existing table.
You can create a database containing multiple linked tables. You can edit the Excel spreadsheet by making changes in to the linked table.
0コメント