Explain secure an access database, Operation Management

Assignment Help:

1. To delete the filter shown below click Filter in the Sort & Filter group and select Clear Filter. Click Remove Filter in the Sort & Filter group. Right click on any number in the Quantity column and select Clear filter from Quantity. Right click on any record in the table and select Clear filter from Quantity. 2. In what situation would Access be a better choice than Excel You have a limited amount of data? You have an extensive amount of data. You need to conduct extensive statistical analyses on your data. You require a flat file view of your data. 3. To design a report you should do all of the following EXCEPT draw a paper design of the report. Identify all sources of data, fields and groups. Input the data. Select a reporting tool. 4. Filters are used to do all of the following EXCEPT a filter can be removed by selecting Remove Filter from the Sort & Filter group. All records in a table will be displayed if all of the filters are removed. Filter effects are cumulative. It does not matter whether you apply a filter or a sort first. 5. A Report section that is used to summarize grouped field data is detail. Group header. Group footer. Report footer. 6. For the following image, which of the following is TRUE? The Order ID field will be unique within both the Orders and Order Details tables. Within the Orders table, the Order ID field will contain more than one of the same value. Within the Order Details table, the Order ID field will contain more than one of the same value. Within the Orders Details table, the Product ID field will contain unique values only. 7. Which of the following should be considered when designing a database? How calculated fields are used Store data in its smallest parts the relationship between attribute keys the relationships between records 8. All of the following apply to the relationships image found below EXCEPT a one-to-many relationship is found between the Suppliers table and the Products table. A relationship exists between the two primary keys of the Suppliers table and the Products table. One table is not joined to the two other tables. The primary key for the Categories table is Category ID. 9. Summarized data in an easy-to-read view is known as a design. PivotTable. report. table. 10. Which of the following does NOT apply to the following relationship image? A one-to-many relationship is applied. The display is showing the Design View of relationships. One table is not joined to the other two tables. A join exists on two primary keys. 11. Which function is used to isolate a specific portion of a date such as year, month, or day in a date field? Date DateDiff DateParse DatePart 1. To edit a form, use datasheet view. design view. layout view. layout view or design view. 2. Clicking on the form tool will open a(n) existing form. new form in design view. new form in layout view. wizard to design a form. 3. Which of the following statements is NOT correct about a query? Changing data values in a query will not change data values in a table. Data is not saved within a query. Instructions on which data to display are saved within a query. Instructions on the format to display data are saved within a query. 4. Which of the following expressions is NOT correct? Cost: [Price] * [Qty] DiscountAmt = [Price] * [Qty] * [Discount] PrPerSqFt: [SalePr] / [SqFt] Sales: [GP] * [Qty] 5. (TCO 7) Which term best describes demographics? It is a bar code on a card that contains information about you. It defines population into segmented groups such as age, income, gender, and race. It is the quantity of merchandise a store will purchase. It is tracking customer purchases. 6. Continuous data are measured in integer values. Cannot be subdivided into meaningful information. Could be subdivided into smaller and smaller units. Describe classifications or categories. 7. A switchboard is a form that looks like a menu or a series of menus that ties objects in a database. Design tool to analyze and optimize a database. report that looks like a menu or a series of menus that ties objects in a database. screen that is used to hide objects from users. 8. To secure an Access database, all of the following should be done EXCEPT digitally sign a database and open it in a trusted location. Require a password to open a database. run the Table Analyzing Wizard and Performance Analyzer. Save a database with the .accde file extension. 9. All of the following describe a certification authority EXCEPT a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database. A certification authority is a commercial company that is highly regulated in most countries. A fee is charged for the service of issuing and validating identities using a digital signature. Certification authority companies establish their own rules and regulations that users must follow. 10. All of the following are Access file format types EXCEPT ACCDB. ACCDE. ACCDC. MDE. 11. The term "cascading" refers to data changes travel from one table to another. Data is put in sequential order. Queries can retrieve data at a faster rate. records are arranged in order. Describe three-tier architecture. Explain the functions performed by each tier. Explain business logic and describe how it relates to a relational database. Describe the update problem caused by a de-normalized design. Explain 1NF, 2NF, and 3NF as related to database design.


Related Discussions:- Explain secure an access database

Explain the role viruses other malicious code, Explain how the Internet has...

Explain how the Internet has aided criminal activity. 2. Provide three (3) specific examples of how the Internet has aided criminal activity. 3. Identify the types of crime that tr

Record of operations in an organisation, Record of operations in an organis...

Record of operations in an organisation If the operation to be studied already exists it is important to record its details by direct observation. To help in this, many tools

Explain yellow pages listed a funeral home under what, In 1980 the Yellow P...

In 1980 the Yellow Pages listed a Funeral Home under what

Explain why has globalization become so important, What specific challenges...

What specific challenges P&G and Colgate-Palmolive face, and why has globalization become so important to them?

Explain what is the total cost of this policy, Rocky Mountain Tire Center s...

Rocky Mountain Tire Center sells 20,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. Th

Locational break - even analysis, Locational Break - even analysis In ...

Locational Break - even analysis In comparing several  potential location on  an economic  basis,( i., e, tangible factor)  the only  revenues  and costs  that need  to be con

Explain intent or motive behind sexual harassment activities, Should be int...

Should be intent or motive behind Lewiston's conduct be considered when deciding sexual harassment activities? Explain

Explain employees explicit rights to free speech, Giving employees explicit...

Giving employees explicit rights to free speech, just cause dismissal, and information are three possibilities for transforming U.S. labour law.

Types of manufacturing system & layout, Types of Manufacturing System & Lay...

Types of Manufacturing System & Layout A layout essentially refers to the arranging and grouping of machines which are meant to produce goods. Grouping is done on different li

Explain test market prior to an advertising campaign, A research team condu...

A research team conducted a study of soft- drink preferences among residents in a test market prior to an advertising campaign for a new cola product. Of the participants, 130 are

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd