There are many ways which you can use to create a table, to create a table, select
Table under objects then click the new button to display the new table dialog box.
Select from the different options the one to use in creating a new table
CREATING A QUERY
a. On the database window, click on query tab under object
b. Click on New button on the database toolbar and select design view
c. A new add table dialog box appears showing tables that are in your
d. Select the ta
These are restrictions/ conditions placed in a query or an advanced filter that Ms
Access should use to retrieve the data from the specified tables e.g. instead of
viewing all the suppliers that your company uses, you can just view supplier
Review Questions: Multiple Choice
1. A person who takes overall responsibility for data, metadata, and the policies about data use is
A. Data administrator
B. Database administrator
C. Database steward
D. Both A and B.
2. The _ has a more hands-on,
DATABASE FORM SECTIONS
All forms have a details section but form can also include form leader, page footer
and form footers section.
FORM HEADER is used to display information that remains, the same for every
record such as form title or form heading. It
To create an update query:
a. Click on the Queries tab under Objects on the left side of the screen.
b. Double-click Create query in Design view or click on the New button (the
New Query dialogue box appears) and select Desig
DATA MODELLING CONCEPT:
ENTITY RELATIONSHIP MODDELLING (E R MODEL)
All databases contain data. Data describes things. A school database for example
describes such things as student courses, teachers etc for any of these things, it is
not difficult to imag
A database - This is a kind of electronic filing cabinet or a collection of information in form of records
which are related to a particular subject or purpose such as tracking customersrecords, students details,
stock control etc.
The logical c
CREATING A DATABASE USING THE DATABASE WIZARD
When launching Ms Access, a dialog box is displayed with options to choose
from in creating your database. The options include database wizard, blank
database and open an existing database. When you want to cr
LOGICAL DATABASE DESIGN
After designing the physical structure of the database, it is important to design
also the logical part of your database, which defines how data flow in the
database. This is accomplished in accordance to the database model you sel
SETTING A FIELD PROPERTY
Each field has a set of properties you use to specify how you want data stored,
handled and displayed. The properties you can set for each field are determined
by the datatype you select for the field.
To select a field property;
FORMATING DATABASE FORMS
The appearance of the form can be enhanced so as to attract the audience who
will use the form/ the database. The background of the form can be changed so as
to have a different color that will clearly reflect other controls that
Manual/ Conventional Database Model
Manual systems are the traditional filing systems where individuals manually
record information and file them in physical files and filing cabinets; a filing
cabinet is where all related information on a particular subj
CREATING A DATABASE FROM SCRATCH
When you create a database from scratch, Access gives you a chance to create a
database that will consist of all the required objects that you can use to come up
with your own database design, color scheme etc
To create a
A report is an effective way to present your data in a printed or displayed format.
This is provided for by the fact that the user has control over the sides &
appearance of everything on a report and therefore you can display the
CREATING A DB FORM USING DESIGN VIEW
In the database window, click form under objects then click new button on
the database window, tool bar.
In the new form dialog box, click design view; select the name of the table
or query that you want to base your
Features of a Database
A database structure is a specialised format for organising and storing of data so
that it can be used efficiently. Any data structure is designed to organise data to
suit a specific purpose so that it can be accesse
Network database model
This type of database organisation is similar to the hierarchical model in the sense
that, just like the hierarchical model, it is a collection of physically linked record
types in a one-to-many relationships. However, in the networ
CREATING A REPORT USING DESIGN VIEW.
You can create a blank report and select a record source as follows:
In the database window, click reports tab under objects
Click new button on the database objects window toolbar
In the new report dialog box click de
Are there any shared administration functions?
These are share administration functions
1. Database design
DA is responsible for logical design
DBA is responsible for the external model design (subschemas), the physical design
(construction), and for
A macro is one or set of one or more actions that each performs a particular
operation. Such as opening a form, printing a report etc
Macro can help you to automate common tasks e.g. you can run a macro that
prints a report when a user clicks comma
SORTING AND GROUPING DATA IN REPORTS
You can print data in a specified order. If you want to highlight or summarize
certain information, you can divide data into separate groups and sort
records within the groups.
To sort data;
In the reports design view,
Before trying to understand the functions of the database administrator, it is necessary to first
learn the three different functional levels needed to maintain a database. These levels are the
data administration (DA), the database
This process entails the graphical presentation of association/ interaction of
objects within the database depending on the structure of the database.
The relationships are used to assist us in the data flow analysis within the
A form is a graphical representation of a table. A form is a database object on
which you place controls for performing various actions e.g. opening another
form, a report, a table etc or for entering, displaying and editing data in fields.
EDITING A RELATIONSHIP
To edit relationship, first close the relational table.
Click on the relationship icon on the toolbar
Select the relational table, where you want to edit their relationship
Double click the relationship line of the relationship
Basic database management system concepts
A database fileis the entire database.
A table/ entity is a basic unit of a database and contains data on a specific topic,
e.g. all the personal information about all the members of a sports club.
A record/ tuple
Referential integrity is a system of rules that Microsoft Access uses to ensure that
relationships between records in related tables are valid and that you dont
accidentally delete or change related data. You set referential integrit
DATABASE MANAGEMENT SYSTEM (DBMS): - This is a program/ software that
organizes the storage the storage of data to facilitate its retrieval for many
DBMS consists of the hardware and software working together to record, store,
COMBINING TEXT VALUES FROM MULTIPLE FIELDS
When you want multiple values from several text fields to appear as one item, you
can combine them by using an expression . to combine text;
In the design view of the form or report, add a text dox for the fields