A database is an organised store of data held in tables. Data can be searched, sorted and combined quickly.

Define the terms field, record and table in a database.

A field holds one item of data, such as an invoice date. A record is a set of fields about one item, and a table holds all the records of one type.

What is a primary key?

A primary key is a field that uniquely identifies each record, such as a client number. The key prevents duplicate records and links tables together.

What is a relational database?

A relational database stores data in separate linked tables. Client details are held once and linked to every invoice, which avoids repetition.

What is a database query, and how does it support financial management?

A query searches the database for records meeting set criteria. A firm could list every invoice unpaid after 60 days.

How does a database differ from a spreadsheet for financial records?

A database handles large volumes of related records and controls who can change them. A spreadsheet suits calculation and modelling but becomes unreliable with many records.

CCEA A-Level Professional Business Services 3210

The Business Environment

Topic overview Primary, secondary, tertiary and quaternary production Private, public and voluntary sector objectives Sole traders and partnerships Private and public limited companies Stakeholder interests and conflicts Factors of production

The Professional Business Services Sector

Topic overview The nature of professional business services The range of consultancy services Tangible goods and intangible services Local, national and global firms Why businesses use consultancy services

The Consultancy Process

Topic overview The consultancy process and the entry phase The diagnosis phase The action planning phase Implementation and termination phases

Understanding the Client's Market

Topic overview Market size, market share and market growth Reasons for market research and using its findings Primary market research methods Secondary market research and choosing a method Sampling methods in market research Market segmentation

Client Relationships

Topic overview Why client relationships matter Communication, personal contact and client needs Business culture and professionalism Trust, ethical behaviour, intellect and ideas

Business Ethics

Topic overview Fairness, integrity and freedom from bias Trust, confidentiality, transparency and openness The benefits of an ethical code

Persuading, Negotiating and Influencing

Topic overview Persuasion techniques for consultants Negotiation stages and strategies Influencing clients and stakeholders

Business Planning and Risk Management

Topic overview Strategic planning and cost–benefit analysis SWOT and PESTEL analysis in strategic planning The Ansoff matrix and the Boston matrix Assessing and managing business risk

Government Regulation

Topic overview The purpose of business regulation Regulators and compliance in Northern Ireland Codes of conduct versus external regulation

Organisational Structure and Culture

Topic overview Human resources and effective HR management Tall, flat, centralised and decentralised structures Roles, chain of command, span of control and delayering Changing and comparing organisational structures Culture, Schein's model and the McKinsey 7S framework

Recruitment and Selection

Topic overview Internal and external recruitment methods Job descriptions and person specifications Interviews and psychometric testing Competency profiling, situational judgement tests and EI questionnaires Contracts of employment and effective recruitment

Learning and Development

Topic overview Why learning and development matters to a business Induction, on-the-job, off-the-job training and CPD Outcomes of learning and development

Employee Well-Being and Motivation

Topic overview What employee well-being is and why employers value it Methods of supporting employee well-being Causes of low workplace well-being Maslow and Taylor on motivation Herzberg and Mayo on motivation Financial and non-financial methods of motivation

Managing Conflict

Topic overview Functional and dysfunctional conflict Causes of conflict at work Effects of conflict on performance, motivation and behaviour Improving employer–employee relations

Business Research Methods

Topic overview Research aims, objectives and literature searches Questionnaires, interviews and designing research tools Sampling, reliability, validity and research ethics Presenting, analysing and evaluating research findings

Sources of Finance

Topic overview Financial decision making in a client business Internal sources of finance Loans, overdrafts and share issues Leasing, hire purchase and trade credit Choosing the right source of finance

Cash Flow

Topic overview Types of budget and why firms set them Adverse and favourable variances Cash flow, profit and why firms forecast Constructing and analysing a cash flow forecast

Financial Statements

Topic overview Revenue, cost of sales and gross profit Expenses and net profit Assets on the statement of financial position Equity and liabilities

Ratio Analysis

Topic overview Profit margins and return on capital employed The current ratio, liquidity and gearing Trade receivables and trade payables days Earnings per share and return on equity Using and evaluating ratio analysis

Investment Appraisal and Financial Decisions

Topic overview The payback method Net present value and discounting Average rate of return and choosing a method Appraising an investment for a client Using financial data for growth and staffing decisions

IT Systems and Communication Technology

Topic overview The role of technology in business Management information and performance management systems Choosing and integrating IT systems Email, messaging, telephone and text Websites, document sharing, conferencing and social media

Technology for People and Operations

Topic overview Performance management software HR information systems Customer relationship management software Transaction processing technology Inventory management technology

Technology for Finance and Disaster Recovery

Topic overview Spreadsheets for financial decisions Databases and accounting software Data security principles and cyber threats SSL, HTTPS and two-factor authentication Legislation on data and technology Disaster recovery planning and backup strategies

Big Data and the Ethics of Technology

Topic overview Big data, data analytics and KPIs Data storage systems Automated decisions, censorship and monitoring Personal data, the digital divide and acceptable use

Leadership and Management

Topic overview Leadership, management and emotional intelligence Fayol's functions and Mintzberg's roles The Tannenbaum–Schmidt continuum and leadership styles Transformational and transactional leadership The Blake Mouton grid and Adair's Action-Centred Leadership Performance management and review

Managing Teams

Topic overview Team working and Tuckman's stages Belbin's nine team roles Using and evaluating Belbin's model

Managing Change

Topic overview Reasons for change in the business environment Resistance to change Lewin, Kotter and Galbraith's change models Benefits and challenges of managing change

Project Management and Feasibility

Topic overview What a project is and why project management matters Project roles and responsibilities Project documents, plans and registers Client needs and feasibility research The business case and the project brief

Project Initiation and Planning

Topic overview The initiation stage and the project initiation document Project tolerances for time, cost, quality and risk The planning stage: scope, objectives and deliverables Resources, roles, quality and financial plans Gantt charts, risk plans and the stage review

Project Closure and Evaluation

Topic overview Monitoring and reviewing a project during execution Closing a project Evaluating a project and gathering stakeholder feedback

Technology for Finance and Disaster Recovery

Databases and accounting software

3 things to know
A2 1

Overview

Fields, records, tables, primary keys and relational databases, queries, accounting software and bank feeds, Making Tax Digital, fintech and automatic invoice reading.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Evaluation

Evaluate cloud accounting software for a Belfast sole trader client.

Evaluation

Evaluate a database and a spreadsheet for an accountancy practice tracking the deadlines of 2,000 clients.

Key term

What is a database?

Questions from this subtopic

Each one with the model answer underneath.

1
What is a database?
Model answer
A database is an organised store of data held in tables. Data can be searched, sorted and combined quickly.
2
Define the terms field, record and table in a database.
Model answer
A field holds one item of data, such as an invoice date. A record is a set of fields about one item, and a table holds all the records of one type.
3
What is a primary key?
Model answer
A primary key is a field that uniquely identifies each record, such as a client number. The key prevents duplicate records and links tables together.
4
What is a relational database?
Model answer
A relational database stores data in separate linked tables. Client details are held once and linked to every invoice, which avoids repetition.
5
What is a database query, and how does it support financial management?
Model answer
A query searches the database for records meeting set criteria. A firm could list every invoice unpaid after 60 days.
6
How does a database differ from a spreadsheet for financial records?
Model answer
A database handles large volumes of related records and controls who can change them. A spreadsheet suits calculation and modelling but becomes unreliable with many records.

See the rest and revise

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book

2Open book

3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

The Business Environment

The Professional Business Services Sector

The Consultancy Process

Understanding the Client's Market

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

A payback is usually preferred.

shorterlongerslower

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

AA firm might move its staff to a new office.

BA firm might install a new client database.

CA firm might run a graduate recruitment campaign.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

Equity means the owner's investment in the business.

TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in Technology for Finance and Disaster Recovery, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a month See how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.