DBMS Flashcards
Give an Example of flat file data base
Ms excel
Give an example of relational database
SQL, oracle, mysql
tables are the ________ of a data base
building blocks
tables store the complete matter in the structure of ______ and _______
rows and columns
all columns in a table are called _______
fields
all the tables in a row are called ______
records
a record consists of all the _______ that belong to a single person
fields
what is data
a set of characters that represents valid value is called data
to retrieve the _______ data from a data base queries are used
unfiltered
queries are also used to perform actions such as _______ , ________, ETC
DELETING UPDATING
forms provide a _________ that facilitates the procsess of _________ in tables and queries
interface-friendly, entering data
reports are used to _________ the data in a ________
display , printable format
reports collect the _________ data from one or ore _________
summarized, tables or queries
full form of DBMS
data base management system
Full form of RDBMS
Rational database management system
a relation database allows the prevention of a _________ in the data
duplication
where is the title bar located
at the top of the window
what does the title bar display
the name of the current database
where is the quick access toolbar located
top left
what does the quick access toolbar contain
save undo redo (common command button)
a ribon has various _____
tabs
what are contextual tabs
tabs that appear when you work with certain objects like forms
The navigation pane is present on the ________ of the window
left hand side
how to open a new database
click on blank database
how to open a database after u have already opened one
go to file> new> blank database
if required , you can change the default location of the file by clicking on the ____________ placed next to the ________
file icon, file name text box
a new database will be created when u click on the _______ button
create
after creating a new database an empty file with the name _______ will be displayed on the ________
Table 1 , title bar
after creating a database a new tab , _________ will now be visible on the ______
table tools < title bar
name the two views of a table
datasheet and design view
the design view is divided into ________ parts , __________ and _________
2, field grid pane , field properties pane
in the field grid pane your can define the _______, __________ and _________
field names, data types and description
field properties name is used to enter the ______________ for the fields defined in a table
different properties
________ view is used to enter data
datasheet
the fields names are listed as ______
column header
how do you switch views in DBMS
click on the drop down arrow of the view option present in the views group either on the home tab or fields group
what views can you switch to
design view or datasheet view
you can add new tables to an existing data base using the ________ or __________ view
design or datasheet
how do you create a table in design view
you create a table by clicking on the table design option in the table group in the create tab
in each field of a table , you type the _________ and press the tab key to move to the ______ column and select a data type, such as a shortcut
field name, data type
in the _____ you can add the description for each field , which is optional
description column
what is a query?
a query is a database that allows you to retrieve information from one or more database tables that meet a specific condition or criteria
how do you create a query using query wizard
clic on the create tab
select query wizard button in the queries group
the new query dialog box appears. the simple
the __________ query wizard is selected by default
simple
what is short text
short text is used to store a combination f numbers and letters
