An Idiot's guide to Microsoft Access

1) To set up a table:

Open Microsoft Access and click on Tables, Then create table in Design View.

Type in your fields under fieldname.

Find a key field. This field must be totally unique to every entry. When you have found it, click on the field and then on the key icon in the top toolbar.

Choose the Data type from what type of data will go in that entry. E.g. for title, text will be in that field so we choose text.

For each field there are various options. You can choose how many characters can go in that field under field size,

You can choose whether a field is required to have data in it, under Required.

You can validate data to only allow certain data in that field. E.g. 1:9 means only the numbers 1,2,3,4,5,6,7,8,9 can be entered in that field. This Prevents GIGO (garbage in garbage out)

You can easily validate fields by clicking on the data type, then on lookup wizard.

Get quality help now
Marrie pro writer
Marrie pro writer
checked Verified writer

Proficient in: Data

star star star star 5 (204)

“ She followed all my directions. It was really easy to contact her and respond very fast as well. ”

avatar avatar avatar
+84 relevant experts are online
Hire writer

Forms

A form is a way of looking at individual data in a nice way.

Click on forms at the main menu and then click create form by using wizard

Choose the table/query etc you want to make a form of and put all the selected fields into the form using the arrows. The double arrow selects all the fields.

Choose what form design you want. The most common design is tabular and it is definitely the best and most clear. Next, choose your form name and click finish.

Get to Know The Price Estimate For Your Paper
Topic
Number of pages
Email Invalid email

By clicking “Check Writers’ Offers”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related email

"You must agree to out terms of services and privacy policy"
Write my paper

You won’t be charged yet!

Reports

A report is used to make a quick selection of certain data that has something in common. For example, all entries with no e-mail address.

To create a report, click on reports in the main menu and then create report using wizard.

Do the same as you did for the form and select the various fields and table/query you want to make a report of.

Choose whether you want a particular order for your data to come in. For example you could have Customer Id on ascending which means Customer Id would come first, and Postcode on descending which means postcode will come last.

Choose the layout of your report (tabular is best this time) Columnar and justified tend to be unclear and messy. The choose whether you want it portrait or landscape, and finally choose whether you mind it being on several pages.

A finished Report

Queries

Queries are used to find particular data you don't know all of the information for. E.g. you want to find customer number 25 but you don't know their name. Or you want to find a Mr. Smith but don't know fully who he is.

To make a query click on query in the main menu and then select create query in design view.

Select what table you want to make a query of and place the desired fields into the query.

Type in the criteria you want to make a query of and then click the red exclamation mark in the top toolbar. E.g. If you want to find a Mr Jones who lives in Coventry, type in Miss under title, Smith under surname and Coventry under town

For mail merge you need two pieces of software, a data source (access database) and a word processor (word). In word you write a document inserting fields where you want the personal data to be. This template is below. Having completed the template you then merge it with the data. The data then replaces the field names. Creating personal documents. From writing one template letter you can produce hundreds of personalised letters e.g. junk mail. This saves a lot of time and effort.

Updated: May 19, 2021
Cite this page

An Idiot's guide to Microsoft Access. (2020, Jun 02). Retrieved from https://studymoose.com/idiots-guide-microsoft-access-new-essay

An Idiot's guide to Microsoft Access essay
Live chat  with support 24/7

👋 Hi! I’m your smart assistant Amy!

Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.

get help with your assignment