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 " 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.
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
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
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