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

1 Answer

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 appear.Step 2 Click on Blank Database icon, the Blank Database pane will appear on the right-hand side as shown in the below figure:Step 3 Type a name for the database in the File Name: box. If you do not give a file name extension, Access automatically adds the default extension .accdb. To change the location of the file from the default, click on Browse (Sir ) icon for changing the location.Step 4 Click the Create button. Access creates the database with an empty table named Table 1, which will open in Datasheet View. The cursor is placed in the first empty cell in the Add New Field column as shown in the following figure:

Related questions

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

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

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.

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

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

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.

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.

Description : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Description : Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Last Answer : Microsoft Office Access 2007 includes a set of database templates which are designed for specific business needs.

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

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

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.

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.

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

Last Answer : Datasheet View and Design View.

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.

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.

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.

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

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

Description : MS_Word 2007 allows you to easily create a variety of professional looking documents using features such as Themes, Styles, SmartArt and more. -Technology

Last Answer : TrueMS-Word 2007 is a powerful tool that allows you to create a variety of professional looking documents because in Word 2007, all the things are replaced with a new navigation system.

Description : A new text document can be created by (a) File —> Open (b) File —> New —> Blank Document —> Create -Technology

Last Answer : (b) Steps to create a new document.File —> New —> Blank Document —> Create

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

Description : How do you locate MS_Word 2007 on your computer system? -Technology

Last Answer : To locate MS-Word on our computer system:Click Start —> All Programs —> Microsoft Office —> Microsoft Office Word 2007.

Description : What is the use of ruler in MS_Word 2007 document? -Technology

Last Answer : Ruler is used to set tabs, indents and margins for a document.

Description : Write the name of alignments, which are available in MS_Word 2007. -Technology

Last Answer : Left, Right, Center and Justify.

Description : What is the use of Crop option in MS_Word 2007? -Technology

Last Answer : Crop option allows a user to edit pictures (only cropping).

Description : What are the basic features of printing in MS_Word 2007? -Technology

Last Answer : The basic features of printing in MS-Word 2007 are as follows:1. Print2. Quick Print3. Print Preview

Description : Define MS_Word 2007. -Technology

Last Answer : MS-Word 2007 is a Word processing software package, which allows you to easily create a variety of professional looking documents like letters, reports and other documents using features such as Themes, Styles, SmartArt and more. It is a powerful tool chat you can use to create effective documents.

Description : Explain different types of tabs available in MS_Word 2007. -Technology

Last Answer : TabsThese are similar to the menu system of MS-Word 2003. Instead of having drop down menus, MS-Word 2007 creates a Ribbon system, where buttons and commands are grouped under the tabs. Some groups ... to change the outline or draft views, display the ruler or document map, zoom, switch windows etc.

Description : 1. What is MS_Word 2007? 2. List new features of MS_Word 2007. -Technology

Last Answer : 1. MS-Word 2007 is the Word processing software in the Microsoft 2007 Office suite.2. Some new features of MS-Word 2007 are as follows:(a) The Ribbon System(b) Themes(c) Quick Styles(d) Pictures(e) Live Preview(f) Shapes(g) ClipArt(h) Charts(i) SmartArt

Description : MS_Word 2007 allows you to insert …………. in your documents. -Technology

Last Answer : MS-Word 2007 allows you to insert picturesin your documents.

Description : MS_Word 2007 tool menu is packed full of lines, arrows, squares and much more. -Technology

Last Answer : FalseWord 2007 tool menu is not packed full of lines, arrows, squares but Word 2007 shapes menu is packed full of all these features.

Description : Editing text in MS_Word 2007 only involves inserting text. -Technology

Last Answer : FalseEditing text means making corrections as desired end results.

Description : How many types of Mathematical symbol sets are available in Word 2007? -Technology

Last Answer : 8 types of Mathematical symbol sets are available in Word 2007.

Description : Explain the feature, Track Changes of MS_Word 2007. -Technology

Last Answer : Track Changes is a feature in Microsoft Word which allows us to keep track of the changes that we make to a document. It allows us to accept or reject the track changes, insert or delete comments etc.

Description : Write down the purpose and features of Show Markup option available in Review tab of Word 2007 document. -Technology

Last Answer : Accepting or rejecting changes work much like the Spell Check feature. By cycling through the changes made to a document, the author can accept or reject any or all changes.For accepting or rejecting ... and (iii) until all changes/comments have been reviewed.5. When finished, save your document.

Description : Explain the purpose of AutoFormat feature of Word 2007. How it can be used in a Word document? -Technology

Last Answer : Auto-formatting feature of Word processing tool allows the automatic formatting of certain kinds of text while' typing. By selecting certain formatting options, theMicrosoft Office 2007 system programs can automatically ... .7. Click Add button.8. Click OK button.9. Close the Symbol dialog box.

Description : In PowerPoint 2007 under the Insert tab, there is a button named Text Box. What is the utility of this button? -Technology

Last Answer : Like a title placeholder, a Text Box is used to hold the text information

Description : Explain the various views of a slide available in PowerPoint 2007. -Technology

Last Answer : In Microsoft Office PowerPoint 2007, different views of a slide are used to edit, print and deliver a presentation. PowerPoint slide views can be found in two places as follows:1. On the ... can make universal style changes to every slide, notes page, or handout associated with the presentation.

Description : File extension for a PowerPoint 2007 presentation is ………………. (a) .ptt (b) .pptx (c) .docx (d) .clsx -Technology

Last Answer : (b) .pptx is the file extension given to all PowerPoint 2007 files.

Description : The ………….. field property makes data entry compulsory, so that the field cannot be left blank. -Technology

Last Answer : TheRequired field property makes data entry compulsory so that the field cannot be left blank.

Description : Complete the blank spaces using words from the list. You should use each word only once. -Technology

Last Answer : 1. PowerPoint2. presentation3. projector4. handouts5. slide6. Websites7. templates

Description : Fill in the blank with appropriate numpy method to calculate and print the variance of an array. -Technology

Last Answer : print(np.var(data,ddof=0))

Description : What is part of a database that holds only one type of information? -Technology

Last Answer : Field. Record. is the answer

Description : A software that searches through a database of Web pages for particular information is known as (a) domain -Technology

Last Answer : (d) Search engine searches a software through a database of Web pages for particular information.

Description : Give any one use of database. -Technology

Last Answer : A database is used to store logically related information in the table.

Description : Explain Database Management. What are the features of DBMS? -Technology

Last Answer : It refers to the software that is responsible for storing, maintaining and utilising a database. It enables a user to define, create and maintain the database and provide controlled access on it. A ... Data security e.g. MS-Access, Corel Paradox, Lotus Approach, MySQL, OpenOffice.org Base etc.

Description : What is database? Give example. -Technology

Last Answer : A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc.

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Description : Write any two advantages of using database. -Technology

Last Answer : 1. Can ensure data security.2. Reduces the data redundancy.

Description : What is field in database? Give an example. -Technology

Last Answer : A field is an area, reserved for a specific piece of data. It is also known as an attribute, e.g. Customer_Name.

Description : Give any two disadvantages of the database. -Technology

Last Answer : 1. High complexity2. Database failure

Description : Write any two uses of database management system. -Technology

Last Answer : 1. DBMS is used to store data at a centralized location.2. It is used to minimize data redundancy and data inconsistency.

Description : What is a primary key in database? Give an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.