The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology
by

1 Answer

Answer :

The different objects supported by MS-Access are tables, queries, forms, and reports.
by

Related questions

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

Database is made up of all the following components except (a) tables (b) queries -Technology

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These

Description : Which of the following is included in the database collection: a) Schemes, Tables, Queries b) Queries, Report, Views and other Objects c) Both of Above d) None of These

Last Answer : c) Both of Above

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

Give the names of five data types used in MS_Access. -Technology

Description : Give the names of five data types used in MS_Access. -Technology

Last Answer : Text, Memo, Date/Time, Yes/No and Currency.

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

What is the use of AutoNumber type field used in MS_Access? -Technology

Description : What is the use of AutoNumber type field used in MS_Access? -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

Explain MS_Access Ribbon. -Technology

Description : Explain MS_Access Ribbon. -Technology

Last Answer : The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows: Home Create External Data Database Tools DatasheetCommand TabCommon Things You ... columns of the table.Set the data type and formatting.Create table relationships and object dependencies.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Last Answer : 2) It consists of separate tables or related data

What software has the use of queries and reports as key functions?

Description : What software has the use of queries and reports as key functions?

Last Answer : database

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Description : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

Description : Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology

Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology

Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.

Which of the following is used to specify the beginning of a table’s row? (a) <table> -Technology

Description : Which of the following is used to specify the beginning of a table’s row? (a) -Technology

Last Answer : (b) tag indicates the beginning of a table’s row.

Which tag is used to add columns in the tables? (a) <colspan> (b) <td> -Technology

Description : Which tag is used to add columns in the tables? (a) (b) -Technology

Last Answer : (b) is used to add columns in the tables.

Which tags divide HTML tables in multiple section? -Technology

Description : Which tags divide HTML tables in multiple section? -Technology

Last Answer : , and

Define cell padding and cell spacing with respect to tables in HTML. -Technology

Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology

Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).

Consider the tables given below. Salesperson -Technology

Description : Consider the tables given below. Salesperson -Technology

Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.

What is the difference between tables and form database objects?

Description : What is the difference between tables and form database objects?

Last Answer : Database table objects store data. Form objects used byapplications provide a visually pleasing or sensible way ofaccessing or updating data contained in the database tables. Thismeans that the form object is a display specification.

Which attribute is not supported by a <BODY> tag? (a) bgcolor -Technology

Description : Which attribute is not supported by a tag? (a) bgcolor -Technology

Last Answer : (b) size is not an attribute of tag.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Description : Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Last Answer : Two graphic objectsare Picture and AutoShapes

Explain an advantage of grouping objects in PowerPoint. -Technology

Description : Explain an advantage of grouping objects in PowerPoint. -Technology

Last Answer : The grouped objects can move, transform, resize and also can change the properties of all the objects in a group together.

Objects on the slide that hold text are called placeholder. -Technology

Description : Objects on the slide that hold text are called placeholder. -Technology

Last Answer : TruePlaceholders hold the text, ClipArt, charts etc.

Explain in detail about Data objects in C Language. -Technology

Description : Explain in detail about Data objects in C Language. -Technology

Last Answer : Definition: A Data object represents a container for data values, a place where data values may be stored and later retrieved.Definition: A runtime grouping of one or more pieces of data in a virtual ... component is often represented by a pointer value. And may be modified by a change in pointer.

Cconsider two objects x and y. x is a list whereas y is a Series. Both have values 20, 40,90, 110. What will be the output of the following -Technology

Description : Cconsider two objects x and y. x is a list whereas y is a Series. Both have values 20, 40,90, 110. What will be the output of the following -Technology

Last Answer : (a). will give the output as:[20,40,90,110,20,40,90,110](b). will give the output as:Justification: In the first statement x represents a list so when a list is multiplied by a number, ... series. When a series is multiplied by a value, then each element of the series is multiplied by that number.

What kind of small objects composes much of the universe? -Technology

Description : What kind of small objects composes much of the universe? -Technology

Last Answer : Normal matter consists of the atoms that make up stars, planets, human beings and every other visible object in the Universe.

Which one of these refers to all objects that have sensors,network connectivity,software,and so on to connect to the network ? :- a) Internet of Things b) Artificial Intelligence c) Machine Learning d) Deep Learning -Technology

Description : Which one of these refers to all objects that have sensors,network connectivity,software,and so on to connect to the network ? :- a) Internet of Things b) Artificial Intelligence c) Machine Learning d) Deep Learning -Technology

Last Answer : internet of things is the correct answer option a

What are the odds declassified government reports will lead to disclosure that earth has been visited by advanced extraterestrials?

Description : What are the odds declassified government reports will lead to disclosure that earth has been visited by advanced extraterestrials?

Last Answer : It would be similar to when Columbus discovered the new world. Earth shattering at first and ho hum after. It could be humans that were sucked into a wormhole decades ago. Like the land bridge around Alaska and Russia, but higher dimensional travel.

Do you believe the scientific reports that oil production is declining, that we are coming to the end of oil?

Description : Do you believe the scientific reports that oil production is declining, that we are coming to the end of oil?

Last Answer : answer:Yes I believe the reports. Oil takes millions of years to make, and mere months to mine. This is my honest, yet cynical point of view on the matter Oil is running out, and we already ... buy out several patents, research several new things, and roll out their new line of shit for the masses.

Why do the news reports say that Facebook's email system is such a huge threat to Google?

Description : Why do the news reports say that Facebook's email system is such a huge threat to Google?

Last Answer : answer:I can take two guesses; 1) Google is paranoid and wants to be the only commonly used messaging system in existence. 2) The news reports want to drum up viewership so they are using the ... that there is already bad blood between the two, but I think that this story is rather sensationalized.

Is the iPhone really worth the expense? Can anyone give firsthand reports?

Description : Is the iPhone really worth the expense? Can anyone give firsthand reports?

Last Answer : answer:Check out the answers to this question, as a start: http://www.ask-public.com/disc/1498/has-anyone-snagged-an-iphone-if-so-what-are-your-thoughts/

What percentage of overall searches are questions and/or subjective queries?

Description : What percentage of overall searches are questions and/or subjective queries?

Last Answer : Most if not all my searches are questions (normally brings up yahoo answers). The rest are searches for anime episodes.

How can I find copies of the queries I have written to ask-publicers privately?

Description : How can I find copies of the queries I have written to ask-publicers privately?

Last Answer : Oh, interesting. I hadn't thought of that. Andrew and I will discuss a way for you to have access to those...