USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Primary Key
|
|
Query
|
|
Data Type
|
|
Object
|
Detailed explanation-1: -A primary key, also called a primary keyword, is a column in a relational database table that’s distinctive for each record. It’s a unique identifier, such as a driver’s license number, telephone number with area code or vehicle identification number (VIN). A relational database must have only one primary key.
Detailed explanation-2: -Queries help you find and work with your data A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
Detailed explanation-3: -Click View Type and select Summary. If you want to use a different data source for the view, click Record Source and select the table or query you want to use. Click the Add New View button to create the summary view.
Detailed explanation-4: -A form in Access is a database object that you can use to create a user interface for a database application. A “bound” form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.