How You Can Use Database Application Computer Science Essay

Published: Last Edited:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

relational database management system also Microsoft access is a properly designed database that makes you be able to access up to date and correct information. Access is known as a desktop database system because it's functions are intended to be run from a single computer. This is in contrast to a server database application (such as SQL Server), where it is intended to be installed on a server, then accessed remotely from multiple client machines.

Microsoft (or MS) Access is a software package that you install just like any other software package, and is bundled as part of the Microsoft Office suite.

Before making a database in MS Access the following need to be addressed

What's is the main purpose of the database

Who will be using the database

What kind of data will the database contain

What queries and reports do the user of the database need

What forms do you need to make the database

Once Access is installed you can Access and create a new file or open an existing file. Before making a database the user should know who the target audiences are and what is required to be stored. Most common data types used are

Number - only to store number, even with decimal point

Character - this is used to store letters, numbers. Data type is known as 'text'

Date - only used to store date and time data. Numerical format

Create a database

Microsoft Access provides three methods to create an Access database.

You can create a database by using the Database wizard. The wizard lets you choose from one of the built-in templates, and customize it to some extent. Then it creates a set of tables, queries, forms, and reports, and also a switchboard for the database. The tables do not have any data in them. Use this method if one of the built-in templates closely match your requirements.

Create a database by using a template

If you want to start creating a database based on your design, create a blank database, then add the tables, forms, reports, and other objects individually - this is the most flexible method, but it requires you to define each database element separately.

After creating your database, you might want to do one or more of the following tasks:

Add data to your database.

Import or link to a data source, such as an Excel spreadsheet or another Access database.

Create a database object, such as a form or a query.

Customize a database object, such as add a field to table

"Simply type what you need to track and Access will use table templates to deliver an app that does the job. Access handles the complexities of fields, relationships, and rules so you can concentrate on your project. You'll have a new app with a natural UI up-and-running before you know it "

The above are simple instructions on how to create tables, queries and reports. Access is user friendly and provides help to guide users through different tasks.


Using Microsoft Access, develop sample inputs and output screens. Use maximum number of controls to demonstrate your understanding


Input can be seen in the editing of the students highlighted post code changed from 7PB to 7BB

Task 3

Evaluate Microsoft access and state how it will be used to develop your own database

Microsoft Access is the database application from the Microsoft Office Suite of applications. It is a powerful personal database and data manipulation tool that is also widely used in many small businesses.

Access allows the user to create "forms" and "reports". A form shows one record in a user-designed format and allows the user to step through records one at a time. A report show selected records in a user-designed format, possibly grouped into sections with different kinds of total (including sum, minimum, maximum, average).

Access is the most commonly used database and has good reputation among database developers and programmers. Access is very easy to use and all buttons give a clear idea of what the users are looking for. Creating tables, forms and queries are simple. User friendly

Users of Microsoft access will discover how to

Create a new Access database

Import and export data

Build forms for efficient data entry

Search tables for specific data

Construct custom reports

Customize your database navigation

Developing my own database

In my database I Simply had to type what I needed to track and Access used table templates to deliver an app that does the job. Access handles the complexities of fields, relationships, and rules so you can concentrate on my project. By using a standardized app framework, access made navigating apps familiar and easy. It remains professional-looking as it grows with the business.

The Navigation Pane

The Navigation Pane appears on the left. This controls navigation within a particular database. A database is made up of several objects, grouped into a single file. This database has been set up to show All Access Objects which currently exist in the database, but there are other types of object as well which do not currently appear

The full list is:

Tables - hold the raw data

Queries - extract part of the raw data to produce dynasets - dynamic sets of data which can change

each time the query is run (to reflect any changes to the data in the tables)

Forms - user-friendly layouts to display data on the screen (either in a table or from a query)

Reports - output files, ready for printing

Pages - for creating/editing WWW pages

Macros - lists of commands to perform particular functions

Modules - programs which expert users write in a programming language called Access Basic to

perform tailor-made functions not generally available


The records are shown in the order that they were first entered into the database - as the data came from the Registrar's Office, it is in Student Number order. For this reason, it wouldn't have been easy to search for Smith simply by scrolling through the records .e.g. trying to find a book in the Library if they were all listed by their date of purchase. If the data is sorted, however, then you can scroll through the records to search for a particular one. To sort any field into alphabetical/numeric order, a quick sort facility is provided.

Eg task 2 diagram


An index can be likened to an index in a book

In my database it is used to speed up searching, sorting and grouping data - one should be set on any field used frequently in these ways. Access records the sort order in a hidden object so that it doesn't need to repeat the sort each time. Indexes also perform a second useful function in that they can be used to guard against duplicate data entry.

Adding, Editing and Deleting Records

Whenever I make any changes to the database (additions, deletions or edits) to a table, it is the original data file that you are altering. Unlike most other applications, a database does not make a working copy of the file first. For this reason, it was essential to keep a back-up copy of my files to which I could always return, just in case I made mistakes when carrying out amendments