Name : Paraggua, Ciara Mae T.

Section : BSA 2A

1. What is database?
A database is a logically organized collection of structured data kept electronically in a
computer system. A database management system (DBMS) is usually in charge of a
database. Data may then be accessed, managed, updated, regulated, and organized with
efficiency.
2. Explain about relational database.
A relational database is a form of database that stores and accesses data items that are
connected to one another. The attributes of the data are stored in the table's columns, and
each record usually includes a value for each property, making it simple to connect data
points.
3. Explain the concept of integrity and its types.

• Database integrity refers to the validity and consistency of stored data. Integrity is
usually expressed in terms of constraints, which are consistency rules that the database is
not permitted to violate. Constraints may apply to each attribute or they may apply to
relationships between tables.
• Domain Integrity - Domain refers to the range of acceptable values. It refers to the
range of values that we are going to accept and store in a particular column within a
database.
• Entity Integrity - Each row for an entity in a table should be uniquely identified i.e. idf
some record is saved in the database then that record should be uniquely identified from
others. This is done with the help of primary keys.
• Referential Integrity - Referential Integrity is used to maintain the data consistency
between two tables. Rules are made in the database structure about how foreign keys
should be used to ensure that changes, addition and deletion in the database maintain the
data integrity.
• User-Defined Integrity - Sometimes these three integrity i.e domain, referential and
entity integrity are not enough to maintain the data integrity. Such integrity is typically
implemented through triggers and stored procedures.
4. How to create a database and tables in MS-Access?

Creating a database
When you open Access, Backstage view displays the New tab. The New tab provides
several ways that you can create a new database:

A blank database You can start from scratch if you want. This is a good option if you
have very specific design requirements or have existing data that you need to
accommodate or incorporate. A template that is installed with Access Consider using a
template if you are starting a new project and would like a head start. Access comes with
several templates installed by default.A template from Office.com In addition to the
templates that come with Access, you can find many more templates on Office.com. You
don't even have to open a browser, the templates are available from the New tab.

One way to create tables in Access is by creating the tables in “Design View.” To create
tables in Access in “Design View,” click the “Create” tab in the Ribbon. Then click the
“Table Design” button in the “Tables” group. Doing this then shows the new table in the
tabbed documents area.

In “Design View,” you will not see the actual data stored in your table. You will only
see a representation of the structure of the table. This gives you more control over the
properties of the fields versus using “Datasheet View” to create a table.

This window is divided into two panes. First, there is the “design grid” at the top,
where you enter field names and data types. Then there is the “properties” section
 beneath it. In the “design grid” at the top of the table design view, there is a small box at
the far left end of each field. This is the “row selector” button. You can click this small
square to select the entire row. You need to do this frequently in Access, so note the
location of this object now.

In “Design View,” you create tables in Access by typing the field names into the “Field
Name” column. Field names must be unique within a table, and should be brief, yet
descriptive. You should also consider not placing spaces within the field names. If you
want, you can adopt a convention such as capitalizing the first letter of each word in a field
name, or using the underscore character instead of a literal space between words in a field
name. Also, the order of fields in this column is the order they appear from left to right in
“datasheet view” of the table. “Datasheet view” is the view that lets you see the actual data
in the tables.

Next, for each field you create when you create tables in Access, you must assign
it a data type. To do this, use the drop-down that appears when you click into the “Data
Type” column to the right of the field name. When you create tables in Access, each field
in the table must have a data type assigned to it. This tells Access what kind of data you
will be storing in the field. “Short Text” is default data type for new fields in Access 2013 or
later. In relational databases, the more varied kinds of data types that exist within a table,
the quicker it is to index and query those tables. So, feel free to change the type, as
needed. Review the various data types you can assign to fields in tables.

5. How to Drop a table and database in MS-Access?

• With your database open, look at the panel on the left side of the workspace. ...
• Right-click the table name in the panel on the left side of the workspace, and choose
Delete from the pop-up menu. ...
• Click Yes in response to the resulting prompt if, in fact, you do want to delete the
table.
6. How to manipulate table structure in MS-Access.

Open the table or query in Datasheet View or form in Form View. Click the field or navigate to the
field by using the TAB or arrow keys, and then press F2. Place the cursor where you want to enter
information. Enter or update the text that you want to insert.

7. Describe query in MS-Access and its manipulation.

A query is a request for data results, and for action on data. You can use a query to
answer a simple question, to perform calculations, to combine data from different tables,
or even to add, change, or delete table data.

• In the Tables tab, on the Show Table dialog, double-click the tblEmployees table and
then Close the dialog box
• In the tblEmployees table, double-click all those fields which you want to see as result of
the query. Add these fields to the query design grid as shown in the following screenshot.
• The query runs, and displays only data in those field which is specified in the query.
8. Explain forms in MS-Access and its manipulation.

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.

•To create a form with no controls or preformatted elements: On the Create tab, click
Blank Form. Access opens a blank form in Layout view, and displays the Field List pane.

•In the Field List pane, click the plus sign (+) next to the table or tables that contain the
fields that you want to see on the form.
 •To add a field to the form, double-click it or drag it onto the form. To add several fields at
once, hold down CTRL and click several fields, and then drag them onto the form at the
same time.
•Use the tools in the Controls group on the Form Layout Tools tab to add a logo, title, page
numbers, or the date and time to the form.

•If you want to add a wider variety of controls to the form, click Design and use the tools in
the Controls group.

9. Define reports in MS-Access and its manipulation.

Reports are a great way to organize and present data from your Access database.
Reports enable you to format your data in an attractive and informative layout for printing
or viewing on screen. Reports are often used to present a big-picture overview,
highlighting main facts and trends.

• In the Navigation Pane, click the table or query on which you want to base the report.

•On the Create tab, in the Reports group, click Report. ...

•For more about viewing and printing your report, see the section View, print, or send your
report as an e-mail message.