How You Can Use Database Application Computer Science Essay

Published:

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.

http://office.microsoft.com/en-gb/access-help/create-an-access-database-HP005187442.aspx

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 " http://www.microsoft.com/office/preview/en/access-2013-preview

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.

TASK 2

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

Output

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). http://dictionary.die.net/microsoft%20access

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

Sorting

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

Indexes

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

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.