access

So, Today I have an excel/access computer exam.

I have no idea what to expect and it is only 40 minutes long so I'm thinking that they cannot ask too much of us.

That said it is a closed book exam and we were told we are not allowed USB drives but can use internet resources.

So it thought I would use my blog as a resource and post a few bits and pieces.

So this is just for my study purposes/please excuse the post.

Hope you have a lovely morning. It is chilly here in Sydney and as a result of sleeping in an extra 15 minutes this morning my socks do not match. Exciting thing though is that Spitpress 2 is out! Hopefully it has my interview in it & I can pick up a copy today! Im excited!

EXCEL

BASIC

Change numbers to currency

Select range of cells

Format: cells

Number: currency

Merge Cells/ centre Vertically/Horizontally/Text Wrap

Select cells

Right click: format cells

Alignment/merge cells/text wrap

Insert Clipart

Insert tab: illustrations: clip art

Sum Formula

=SUM(A1:A4)

Tax formula

Sum x 0.119 etc

Average

=AVERAGE(A1:A4)

Standard Deviation

=STDEV(A1:A4)

Charts

Insert: charts

ADVANCED Ass 2 Help Doc

Conditional Formatting

Select cells

Home: conditional formatting

MACROS:

Totals

Average

Creating a Button

Excel options: customize: macros: choose commands from: select desired macro: modify to change name OK

Reset Button

Profit Formula across spreadsheets

Countif Formula

=Countif(A1:A4)

Max Function

=MAX( argument1, argument2, ... argument30 )

Index/Max function

Pivot Table

Pivot Chart

ACCESS

BASIC

Create Database w/new table

Design view: create new table

Primary Key

Left click to move

Creating Relationships (one to many/enforce referential integrity)

Tools: relationships show tables

QUERIES: DESIGN VIEW QUERY NEW

Total Price & Report

Create tab: query design

Sow tables

Expression Builder price *quant

Create report from query.

Form/Editing

Select desired table

Create- form

Layout view: format title/logo

Advanced Queries

ADVANCED

Report

Select desired table

Create: report

Layout view: page setup

Export as PDF: External Data Tab

Delete QUERY

Create tab: Query Design

Select table

Design Tab: Delete

Double Click Manufacture Field

Enter Criteria

Run it

Yes warning message.

Switchboard

Database tools Tab: Switchboard Manager

Yes new switchboard

Man switchboard

Edit

Add new

Form: open in edit mode

Report: open report

Automatic: Office button, access options, current database, switchboard display form.